File manager

File manager - Edit - /home/autoph/public_html/ahglegal/includes/addnewpatient.php

Back
<html> <head> <title>UNIVERSAL STUDIO</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="css/screen_white.css"> <link rel="stylesheet" href="ajs/vendors/jQueryUI/jquery-ui.css"> <script src="ajs/vendors/jQueryUI/jquery-1.12.4.js"></script> <script src="ajs/vendors/jQueryUI/jquery-ui.js"></script> </head> <?php if(isset($_POST['SaveRecord'])){ $book =$_GET['book']; $date =$_POST['date']; $signatory =$_POST['signatory']; $govID =$_POST['govID']; $account =$_POST['account']; $desc =$_POST['desc']; $pageCount = mysql_result(mysql_query("SELECT MAX(`page_no`) FROM `notary_public` WHERE `book_id`='$book' ORDER BY `page_no` DESC LIMIT 1"),0); $pageDocNo = mysql_result(mysql_query("SELECT MAX(`doc_no`) FROM `notary_public` WHERE `book_id`='$book' ORDER BY `page_no` DESC LIMIT 1"),0); $newpageDocNo = $pageDocNo + 1; $checkCount = mysql_result(mysql_query("SELECT COUNT(`page_no`) FROM `notary_public` WHERE `page_no`='$pageCount' and `book_id`='$book'"),0); if($checkCount ==0){ $newPage = 2; }else if($checkCount > 0 && $checkCount < 5){ $newPage =$pageCount; }else { $newPage =$pageCount + 1; } $sql="INSERT INTO `notary_public` (`id`,`doc_no`, `book_id`,`page_no`,`date`, `time`, `des`,`signatory`,`account`, `gov_id`,`encoded_by`,`status`) VALUES('','$newpageDocNo','$book','$newPage','$toDate','$currentTime', '$desc', '$signatory','$account','$govID','$user','1')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ $tID = mysql_result(mysql_query("SELECT `id` FROM `talents_profile` WHERE `lname`='$lname' AND `fname`='$fname' AND `pemail`='$email' AND `mobile`='$mobile'"),0); echo "<div class='ContinueMSG'>"; echo " <h3 class='lightGradient' style='width:99%;font-family:Calibri Light;font-size:18px;font-weight:bold;padding-left:5px;padding-top:2px;'>NEW RECORD SAVED...</h3>"; echo "<div style='top:3px;left:95.5%;position:absolute;z-index:3;background:transparent'> <a href='main_new.php?view=100&sid=M1&sview=100&tab=0#id-0' > <center>X</center> </a> </div>"; echo " < <p style='font-family:Calibri Light;font-size:14px;color:#0B610B;font-weight:bold;padding-top:0px'><img src='images/rica/bullet_c.png' width='8px' style='padding-right:10px;'>Record has been saved...</p>"; echo "<center><br><a href='main_new.php?book=".$_GET['book']."&view=100&sview=100&sid=".$_GET['sid']."&action=&tab=0#id-0'><input type='button' class='button' name='Exit' value='Close' style='width:80px;'></a></center>"; echo "</div>"; } } ?> <body> <center> <div style='width:98.5%;border:1px solid white;height:25px;text-align:left;padding-left:10px;padding-top:5px;font-family:Calibri;font-size:14px;color:#000;text-shadow:1px 1px 5px #fff' class='plainBlue'>DOCUMENT INFORMATION <div style='position:relative;float:right;font-family:Calibri;font-size:12px;margin-right:10px'> Page 1 of 4</div> </div> <div style='width:98%;border:1px solid #E6E6E6;height:350px;padding:5px'> <form action='' method='POST'> <table style='width:100%;border:1px solid white'> <tr style='background:white;border:1px solid white'> <td valign='top' style='background:white;border:1px solid white;border-right:1px solid white;width:50%'> <div align='left' class="form-group" style='padding:10px'> <p style='text-align:bottom;line-height:80%;font-family:Calibri Light;font-size:12px;padding-left:0px;color:black;font-weight:bold'> <ABBR title='DOCUMENT DATE'><input REQUIRED id='datepickerA' class='textbox' value='<?php echo $toDate; ?>' type="text" placeholder="DOCUMENT DATE" name="date" style='background:white;min-width:200px;margin-top:5px'></ABBR> </p> </div> <div align='left' class="form-group" style='padding:10px'> <p style='text-align:bottom;line-height:80%;font-family:Calibri Light;font-size:12px;padding-left:0px;color:black;font-weight:bold'> <ABBR title='NAME OF SIGNATORY'><input class='textbox' REQUIRED type="text" placeholder="NAME SIGNATORY" name="signatory" style='background:white;min-width:50%;margin-top:5px'></ABBR> </p> </div> <div align='left' class="form-group" style='padding:10px'> <p style='text-align:bottom;line-height:80%;font-family:Calibri Light;font-size:12px;padding-left:0px;color:black;font-weight:bold'> <ABBR title='GOVT. ID NO'><input class='textbox' REQUIRED type="text" placeholder="GOVT. ID NO" name="govID" style='background:white;min-width:98%;margin-top:5px'></ABBR> </p> </div> <div align='left' class="form-group" style='padding:10px'> <p style='text-align:bottom;line-height:80%;font-family:Calibri Light;font-size:12px;padding-left:0px;color:black;font-weight:bold'> <ABBR title='COMPANY ACCOUNT'><input class='textbox' REQUIRED type="text" placeholder="COMPANY ACCOUNT" name="account" style='background:white;min-width:50%;margin-top:5px'></ABBR> </p> </div> <div align='left' class="form-group" style='padding:10px'> <p style='text-align:bottom;line-height:80%;font-family:Calibri Light;font-size:12px;padding-left:0px;color:black;font-weight:bold'> <ABBR title='DESCRIPTION'><input class='textbox' REQUIRED type="text" placeholder="DESCRIPTION" name="desc" style='background:white;min-width:98%;margin-top:5px'></ABBR> </p> </div> </td> </tr> </table> <div align='right' class="form-group" style='padding:10px'> <input type='submit' class='submit' name='SaveRecord' value='Save Record'> <input type='reset' class='submit' name='Clear' value='Clear'> <?php echo "<a href='main_new.php?book=".$_GET['book']."&view=100&sview=100&sid=".$_GET['sid']."&action=&tab=0#id-0'><input type='button' class='submit' name='Exit' value='Exit'></a>";?> </div> </form> </div> </center> </body> </html>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings