";
echo "FNAME : "."$sevvaki2"."
";
echo "Dr_username : "."$sevvaki3"."
";
echo "Dr_pwd : "."$sevvaki4"."
";
$conn = mysqli_connect($servername, $username, $password, $db);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "SUCCESS"."
";
// WHERE fname = `$sevvaki2`
//$sql = "INSERT INTO `pcemrtbl` (`seno`, `date`, `time`, `druna`, `drpwd`, `clinicid`, `fname`, `lname`, `age`, `agem`,`sex`, `contact`, `notes`, `fsosx`, `fsodx`, `fsotx`,`ssosx`, `ssodx`, `ssotx`, `illdt`, `labdt`, `dxdt`, `txdt`, `fupdt`) VALUES (NULL, '$today', '$now', '$druna', '$drpwd', '$cid', '$fna', '$lna', '$agey','$agem', '$sex', '$mobile', '$notes', '$inpsx', '$camdx', '$camtx', '$inpsx1', '$camdx1', '$camtx1', '$illdt', '$ixdt', '$dxdt', '$txdt', '$fupdt')";
$result = mysqli_query($conn, "SELECT `clinicid`, `fsosx`, `illdt`, `dxdt`, `fupdt` FROM pcemrtbl WHERE `clinicid`= '$sevvaki1' ");
$records = mysqli_num_rows($result);
echo "TOTAL NO OF RECORDS RETRIEVED : "."$records"."
";
echo "ARRANGED FROM LATEST TO REMOTE"."
";
echo "
"."
";
if($records>0)
while($row=mysqli_fetch_row($result)){
echo "RETRIEVED RECORD : "."$records"."
";
echo "CLINIC ID : "."$row[0]"."
";
echo "SYMPTOM DATA : "."$row[1]"."
";
echo "ILLNESS DATA : "."$row[2]"."
";
echo "DIANGOSIS DATA : "."$row[3]"."
";
echo "FOLLOW UP DATA : "."$row[4]"."
";
echo "
"."
";
$records --;
}
else{
echo "NO RECORDS"."
";
}
?>