File manager - Edit - /home/autoph/public_html/connect/home/PRF/PRF_SaveValidatorByCompany.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'])){ $SelCompanyID = mysql_escape_string($_POST['SelCompanyID']); $validatorID = mysql_escape_string($_POST['validatorID']); $SelCategoryID = mysql_escape_string($_POST['SelCategoryID']); //===================================================================================================================================================== //===================================================================================================================================================== $chkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_company_asset_approver` WHERE `comp_id`='$SelCompanyID' AND `expense_item_id`= '$SelCategoryID'"),0); if($chkIfExist > 0){ mysql_query("UPDATE prf_company_asset_approver SET `approver_id`='$validatorID' WHERE `comp_id`='$SelCompanyID' AND `expense_item_id`= '$SelCategoryID'"); //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 prf_company_asset_approver (comp_id, expense_item_id, approver_id) VALUES('{$SelCompanyID}','{$SelCategoryID}','{$validatorID}')"); //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