<input type="text" size="100" name="drug4" value=""/> <input type="time" size="5" name="time4" value="21:00"/> <input type="number" size="2" name="days4" value=""/> <br> Reports <br> <textarea name="reports" rows="4" cols="50"> X-ray </textarea> <br> Next appointment <input type="text" size="10" name="nextappointment" maxlength="10" value="2014-12-31 23:30"/> <br> </p><p> <input type="submit" name="run" value="Save Patient data"/> </p><p> */ // include db handler require_once 'include/DB_update.php'; if (empty($_POST["phone"]) or empty($_POST["problem"])) { echo "\n"; } else { $db = new DB_update(); $med1 = ""; $med2 = ""; $med3 = ""; $med4 = ""; if (!empty($_POST["drug1"])) { $med1 = $_POST["drug1"] . "#" . $_POST["time1"] . "#" . $_POST["days1"]; } if (!empty($_POST["drug2"])) { $med2 = $_POST["drug2"] . "#" . $_POST["time2"] . "#" . $_POST["days2"]; } if (!empty($_POST["drug3"])) { $med3 = $_POST["drug3"] . "#" . $_POST["time3"] . "#" . $_POST["days3"]; } if (!empty($_POST["drug4"])) { $med4 = $_POST["drug4"] . "#" . $_POST["time4"] . "#" . $_POST["days4"];
<?php /* ?phone= */ // include db handler require_once 'include/DB_update.php'; if (empty($_POST["phone"])) { echo "Error: in input data\n"; } else { $db = new DB_update(); $resultarray = $db->get_record($_POST["phone"]); $entry = 1; echo "<table style=\"border:1px solid black;\">"; //Display column names if (mysql_num_rows($resultarray) > 0) { $numfields = mysql_num_fields($resultarray); for ($i = 0; $i < $numfields; $i++) { echo '<th>' . mysql_field_name($resultarray, $i) . '</th>'; } } //Display Entries while ($row = mysql_fetch_array($resultarray)) { echo "<tr>"; for ($i = 0; $i < $numfields; $i++) { //foreach($row as $key => $value){ echo '<td>' . $row[$i] . '</td>'; } echo "</tr>"; $entry++; }
<?php /* ?phone= &name= &age= &DOB=YYYY-MM-DD &sex=M */ // include db handler require_once 'include/DB_update.php'; if (empty($_POST["phone"]) or empty($_POST["name"])) { echo "Error: in input data\n"; } else { $db = new DB_update(); $result = $db->put_patient_details($_POST["phone"], $_POST["name"], $_POST["age"], $_POST["DOB"], $_POST["sex"]); if ($result == false) { echo "Error in saving the user details"; } else { echo $result; } } // UPDATE `medpil`.`patient_info` SET `phone` = '9489244684' WHERE `patient_info`.`phone` =2147483647;
height:50px; line-height:50px; width:126px; text-decoration:none; text-align:center; }.classname:hover { background-color:#53537A; }.classname:active { position:relative; top:1px; }</style> <?php // include db handler require_once 'include/DB_update.php'; if (empty($_POST["phone"])) { echo ""; } else { $db = new DB_update(); $result = $db->get_patient_details($_POST["phone"]); $name = $result["name"]; $age = $result["age"]; $DOB = $result["DOB"]; $sex = $result["sex"]; echo "<br>Name: " . $name; echo "<br>Age: " . $age; echo "<br>DOB: " . $DOB; echo "<br>Sex: " . $sex; } ?> </center> </font>