File manager - Edit - /home/autoph/public_html/connect/home/CL_save_update_Template.php
Back
<?php include 'core/database/connect.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); //$userID=$user_data['u_id']; $toDate = date_create() ->format("Y-m-d"); //if submit/ save to databasevar if(isset($_POST['done'])){ $divID = mysql_escape_string($_POST['divID']); $unitID = mysql_escape_string($_POST['unitID']); $officerID = mysql_escape_string($_POST['officerID']); $compID = mysql_escape_string($_POST['compID']); $templateID = mysql_escape_string($_POST['templateID']); $userID = mysql_escape_string($_POST['userID']); $rank = mysql_escape_string($_POST['rank']); //===================================================================================================================================================== //===================================================================================================================================================== $chkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM `cl_approving_officers` WHERE `cl_template_id`='$templateID' AND `cl_div_id`= '$divID' AND `cl_unit_id`='$unitID' AND `cl_comp_id`='$compID'"),0); if($chkIfExist > 0){ mysql_query("UPDATE cl_approving_officers SET `cl_emp_id_a`='$officerID', `cl_sla_a`='3' WHERE `cl_template_id`='$templateID' AND `cl_div_id`= '$divID' AND `cl_unit_id`='$unitID' AND `cl_comp_id`='$compID'"); //echo "<p style='padding:5px;margin:5px;font-family:Calibri;font-size:18px;font-weight:bold;color:blue'>SELECTED RECORD HAS BEEN UPDATED</p>"; }else{ //echo '<script>alert("New Record has been saved...")</script>'; mysql_query("INSERT INTO cl_approving_officers (cl_div_id, cl_template_id, cl_unit_id, cl_comp_id, cl_emp_id_a, cl_sla_a,cl_level) VALUES('{$divID}','{$templateID}','{$unitID}','{$compID}','{$officerID}','3','{$rank}')"); //echo "<p style='padding:5px;margin:5px;font-family:Calibri;font-size:18px;font-weight:bold;color:blue'>NEW RECORD HAS BEEN ADDED.</p>"; } //echo '<script>alert("New Record has been saved...")</script>'; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings