Server IP : 162.240.98.243 / Your IP : 3.17.157.6 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 session_start(); include("headers.php"); include("dbconnection.php"); if(isset($_POST[submit])) { if(isset($_GET[editid])) { $sql ="UPDATE treatment SET treatmenttype='$_POST[treatmenttype]',treatment_cost='$_POST[treatmentcost]',note='$_POST[textarea]',status='$_POST[select]' WHERE treatmentid='$_GET[editid]'"; if($qsql = mysqli_query($con,$sql)) { echo "<script>alert('treatment record updated successfully...');</script>"; } else { echo mysqli_error($con); } } else { $sql ="INSERT INTO treatment(treatmenttype,treatment_cost,note,status) values('$_POST[treatmenttype]','$_POST[treatmentcost]', '$_POST[textarea]','$_POST[select]')"; if($qsql = mysqli_query($con,$sql)) { echo "<script>alert('treatment record inserted successfully...');</script>"; } else { echo mysqli_error($con); } } } if(isset($_GET[editid])) { $sql="SELECT * FROM treatment WHERE treatmentid='$_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 treatment</li></ul> </div> </div> <div class="wrapper col4"> <div id="container"> <h1>Add new treatment record</h1> <form method="post" action="" name="frmtreat" onSubmit="return validateform()"> <table width="472" border="3"> <tbody> <tr> <td width="34%">Treatment Type</td> <td width="66%"><input type="text" name="treatmenttype" id="treatmenttype" value="<?php echo $rsedit[treatmenttype]; ?>"/></td> </tr> <tr> <tr> <td width="34%">Treatment Cost</td> <td width="66%"><input type="text" name="treatmentcost" id="treatmentcost" value="<?php echo $rsedit[treatment_cost]; ?>"/></td> </tr> <tr> <td>Note</td> <td><textarea name="textarea" id="textarea" cols="45" rows="5"><?php echo $rsedit[note] ; ?></textarea></td> </tr> <tr> <td>Status</td> <td><p> <select name="select" id="select"> <option value="">Select</option> <?php $arr = array("Active","Inactive"); foreach($arr as $val) { if($val == $rsedit[status]) { echo "<option value='$val' selected>$val</option>"; } else { echo "<option value='$val'>$val</option>"; } } ?> </select> </p></td> </tr> <tr> <td colspan="2" align="center"><input type="submit" name="submit" id="submit" value="Submit" /></td> </tr> </tbody> </table> </form> <p> </p> </div> </div> </div> <div class="clear"></div> </div> </div> <?php include("footers.php"); ?> <script type="application/javascript"> var alphaExp = /^[a-zA-Z]+$/; //Variable to validate only alphabets var alphaspaceExp = /^[a-zA-Z\s]+$/; //Variable to validate only alphabets and space var numericExpression = /^[0-9]+$/; //Variable to validate only numbers var alphanumericExp = /^[0-9a-zA-Z]+$/; //Variable to validate numbers and alphabets var emailExp = /^[\w\-\.\+]+\@[a-zA-Z0-9\.\-]+\.[a-zA-z0-9]{2,4}$/; //Variable to validate Email ID function validateform() { if(document.frmtreat.treatmenttype.value == "") { alert("Treatment type should not be empty.."); document.frmtreat.treatmenttype.focus(); return false; } else if(!document.frmtreat.treatmenttype.value.match(alphaspaceExp)) { alert("Treatment type not valid.."); document.frmtreat.treatmenttype.focus(); return false; } else if(document.frmtreat.select.value == "" ) { alert("Kindly select the status.."); document.frmtreat.select.focus(); return false; } else { return true; } } </script>