Server IP : 162.240.98.243 / Your IP : 3.129.210.102 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/public_html/login.easenup.in/ |
Upload File : |
<?php include("header.php"); include("dbconnection.php"); if(isset($_GET[delid])) { $sql ="DELETE FROM prescription_records WHERE prescription_record_id='$_GET[delid]'"; $qsql=mysqli_query($con,$sql); if(mysqli_affected_rows($con) == 1) { echo "<script>alert('prescription deleted successfully..');</script>"; } } if(isset($_POST[submit])) { if(isset($_GET[editid])) { $sql ="UPDATE prescription_records SET prescription_id='$_POST[prescriptionid]',medicine_name='$_POST[medicine]',cost='$_POST[cost]',unit='$_POST[unit]',dosage='$_POST[select2]',status=' $_POST[select]' WHERE prescription_record_id='$_GET[editid]'"; if($qsql = mysqli_query($con,$sql)) { echo "<script>alert('prescription record updated successfully...');</script>"; } else { echo mysqli_error($con); } } else { $sql ="INSERT INTO prescription_records(prescription_id,medicine_name,cost,unit,dosage,status) values('$_POST[prescriptionid]','$_POST[medicine]','$_POST[cost]','$_POST[unit]','$_POST[select2]','$_POST[select]')"; if($qsql = mysqli_query($con,$sql)) { $billtype = "Prescription update"; $prescriptionid= $_POST[prescriptionid]; echo "<script>alert('prescription record inserted successfully...');</script>"; } else { echo mysqli_error($con); } } } if(isset($_GET[editid])) { $sql="SELECT * FROM prescription_records WHERE prescription_record_id='$_GET[editid]' "; $qsql = mysqli_query($con,$sql); $rsedit = mysqli_fetch_array($qsql); } ?> <div class="wrapper col2"> <div id="breadcrumb"> <ul> <li class="first">Add New Prescription Record</li></ul> </div> </div> <div class="wrapper col4"> <div id="container"> <table width="200" border="3"> <tbody> <tr> <td><strong>Doctor</strong></td> <td><strong>Patient</strong></td> <td><strong>Prescription Date</strong></td> <td><strong>Status</strong></td> </tr> <?php $sql ="SELECT * FROM prescription WHERE prescriptionid='$_GET[prescriptionid]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { $sqlpatient = "SELECT * FROM patient WHERE patientid='$rs[patientid]'"; $qsqlpatient = mysqli_query($con,$sqlpatient); $rspatient = mysqli_fetch_array($qsqlpatient); $sqldoctor = "SELECT * FROM doctor WHERE doctorid='$rs[doctorid]'"; $qsqldoctor = mysqli_query($con,$sqldoctor); $rsdoctor = mysqli_fetch_array($qsqldoctor); echo "<tr> <td> $rsdoctor[doctorname]</td> <td> $rspatient[patientname]</td> <td> $rs[prescriptiondate]</td> <td> $rs[status]</td> </tr>"; } ?> </tbody> </table> <h1>View Prescription record</h1> <table width="200" border="3"> <tbody> <tr> <td><strong>Medicine</strong></td> <td><strong>Cost</strong></td> <td><strong>Unit</strong></td> <td><strong>Dosage</strong></td> <?php if(!isset($_SESSION[patientid])) { ?> <td><strong>Action</strong></td> <?php } ?> </tr> <?php $sql ="SELECT * FROM prescription_records WHERE prescription_id='$_GET[prescriptionid]'"; $qsql = mysqli_query($con,$sql); while($rs = mysqli_fetch_array($qsql)) { echo "<tr> <td> $rs[medicine_name]</td> <td> Rs. $rs[cost]</td> <td> $rs[unit]</td> <td> $rs[dosage]</td>"; if(!isset($_SESSION[patientid])) { echo " <td> <a href='prescriptionrecord.php?delid=$rs[prescription_record_id]&prescriptionid=$_GET[prescriptionid]'>Delete</a> </td>"; } echo "</tr>"; } ?> <tr> <td colspan="6"><div align="center"> <input type="submit" name="print" id="print" value="Print" onclick="myFunction()"/> </div></td> </tr> </tbody> </table> <script> function myFunction() { window.print(); } </script> <?php if(!isset($_SESSION[patientid])) { ?> <form method="post" action="" name="frmpresrecord" onSubmit="return validateform()"> <input type="hidden" name="prescriptionid" value="<?php echo $_GET[prescriptionid]; ?>" /> <table width="200" border="3"> <tbody> <tr> <td width="34%">Medicine</td> <td width="66%"><input type="text" name="medicine" id="medicine" value="<?php echo $rsedit[medicine_name]; ?>" /></td> </tr> <tr> <td>Cost</td> <td><input type="text" name="cost" id="cost" value="<?php echo $rsedit[cost]; ?>"/></td> </tr> <tr> <td>Unit</td> <td><input type="number" min="1" name="unit" id="unit" value="<?php echo $rsedit[unit]; ?>" /></td> </tr> <tr> <td>Dosage</td> <td><select name="select2" id="select2"> <option value="">Select</option> <?php $arr = array("1-0-1","1-1-1","1-1-0","0-1-1","0-1-0","0-0-1","1-0-0"); foreach($arr as $val) { if($val == $rsedit[dosage]) { echo "<option value='$val' selected>$val</option>"; } else { echo "<option value='$val'>$val</option>"; } } ?> </select></td> </tr> <tr> <td colspan="2" align="center"><input type="submit" name="submit" id="submit" value="Submit" /> </td> </tr> </tbody> </table> </form> <?php } ?> <p> </p> </div> </div> </div> <div class="clear"></div> </div> </div> <?php include("footer.php"); ?> <script type="application/javascript"> function validateform() { if(document.frmpresrecord.prescriptionid.value == "") { alert("Prescription id should not be empty.."); document.frmpresrecord.prescriptionid.focus(); return false; } else if(document.frmpresrecord.medicine.value == "") { alert("Medicine field should not be empty.."); document.frmpresrecord.medicine.focus(); return false; } else if(document.frmpresrecord.cost.value == "") { alert("Cost should not be empty.."); document.frmpresrecord.cost.focus(); return false; } else if(document.frmpresrecord.unit.value == "") { alert("Unit should not be empty.."); document.frmpresrecord.unit.focus(); return false; } else if(document.frmpresrecord.select2.value == "") { alert("Dosage should not be empty.."); document.frmpresrecord.select2.focus(); return false; } else if(document.frmpresrecord.select.value == "" ) { alert("Kindly select the status.."); document.frmpresrecord.select.focus(); return false; } else { return true; } } </script>