<?PHP
//if($_POST['action'] == 'call_this') {
  // call removeday() here

//header("Access-Control-Allow-Origin: *");
//header("Content-Type: application/json; charset=UTF-8");

$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password=""; // Mysql password 
$db_name="vsaDB"; // Database name  
$tbl_name="vsaqtns"; // Table name 
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
// get data that sent from form 
$pos=mysql_real_escape_string($_POST['Qpos']);
$qnatr=mysql_real_escape_string($_POST['qnatr']);
$exmtyp=mysql_real_escape_string($_POST['exmtyp']);
$dt=mysql_real_escape_string($_POST['dt']);
//$figpath=mysql_real_escape_string($_POST['figname']);
$sbj=mysql_real_escape_string($_POST['sbj']);
$yr=mysql_real_escape_string($_POST['yr']);
$questn=mysql_real_escape_string($_POST['questn']);
$cha=mysql_real_escape_string($_POST['chA']);
$chb=mysql_real_escape_string($_POST['chB']);
$chc=mysql_real_escape_string($_POST['chC']);
$chd=mysql_real_escape_string($_POST['chD']);
$resp=mysql_real_escape_string($_POST['Ans']);
$soln=mysql_real_escape_string($_POST['soln']);
$pQ=mysql_real_escape_string($_POST['pQ']);
$btch=mysql_real_escape_string($_POST['btch']);
$tps=mysql_real_escape_string($_POST['tps']);
$qsttus=mysql_real_escape_string($_POST['qsttus']);
$stMark=mysql_real_escape_string($_POST['stMark']);
$sql="UPDATE $tbl_name 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', paragraphQ='$pQ', btch='$btch', tps='$tps', qsttus='$qsttus', stMark='$stMark' WHERE pos='$pos'";
//$sql="UPDATE $tbl_name SET qnatr ='$qnatr', exmtyp ='$exmtyp', dt ='$dt', figpath='$figpath', sbj='$sbj', yr='$yr', questn='$que', cha='$cha', chb='$chb', chc='$chc', chd='$chd', resp='$resp', soln='$soln',fig='$fig' WHERE pos='$pos'";
//$sql="UPDATE $tbl_name SET tranid ='$tranid', pvno ='$pvno', amtFG='$amtFG', payee='$payee', dcpn='$dcpn', pydt='$pydt', pyofcr='$pyofcr', amtpaid='$amtpaid',datebox='$datebox' WHERE sno='$sno';";
$result=mysql_query($sql) or die(mysql_error());
//$num=mysql_numrows($result);
if($result){
echo "Data Submitted";
/*echo "!<BR>";
echo "<html>";
echo "<head>";
echo "<title>Data Sent</title>";
echo " <body><a href=../dmp.htm>goback</a></body>";
echo " </html>";*/
}
else {
echo mysql_error(); 

}
mysql_close();
<?php
/*
$host="198.71.225.59"; // Host name 
$username="roots"; // Mysql username 
$password="rOhr%107"; // Mysql password 
$db_name="vsaDB"; // Database name  
$tbl_name="vsaqtns"; // Table name 
*/
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "vsaqtns";
$tbl_name="vsaqtns"; // Table name 

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql = "UPDATE MyGuests SET lastname='Doe' WHERE id=2";

    // Prepare statement
    $stmt = $conn->prepare($sql);

    // execute the query
    $stmt->execute();

    // echo a message to say the UPDATE succeeded
    echo $stmt->rowCount() . " records UPDATED successfully";
    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage();
    }

$conn = null;
?> 
?>