setAttribute(PDO::ATTR_EMULATE_PREPARES, FALSE); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //$sql="UPDATE vsaqtns SET qnatr ='$qnatr', exmtyp ='$exmtyp', dt ='$dt', sbj='$sbj', yr='$yr', questn='$questn', cha='$cha', chb='$chb', chc='$chc', chd='$chd', resp='$resp', soln='$soln', paragT='$paragT', btch='$btch', tps='$tps', qsttus='$qsttus', stMark='$stMark' WHERE pos=". $conn->quote($pos); $sql="INSERT INTO vsaqtns(qid, qnatr, exmtyp, dt, figpath, sbj, yr, questn, cha, chb, chc, chd, resp, soln, stMark, btch, tps, qsttus, fig)VALUES('$qid', '$qnatr','$exmtyp', '$dt', '$figpath', '$sbj','$yr','$questn', '$cha', '$chb', '$chc', '$chd', '$resp', '$soln', '$stMark', '$btch', '$tps', '$qsttus', '$fig')"; //$sql = "Select * from vsaqtns WHERE pos=". $conn->quote($pos); //$sql = "UPDATE vsaqtns SET questn=? WHERE pos=?"; // Prepare statement $stmt = $conn->prepare($sql); //$stmt = $conn->exec($sql); // execute the query $stmt->execute(); // echo a message to say the UPDATE succeeded echo $stmt->rowCount() . " records UPDATED successfully"; // " records UPDATED successfully"; $conn = null; } catch(PDOException $e) { echo $sql . "
" . $e->getMessage(); } ?>