File manager - Edit - /home/autoph/public_html/connect/home/prf_updatenewREQ.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'])){ $newREQ = mysql_escape_string($_POST['newREQ']); $userID = mysql_escape_string($_POST['userID']); $prfCode = mysql_escape_string($_POST['prfCode']); $gmFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$newREQ'"),0); $gmLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$newREQ'"),0); mysql_query("UPDATE `prf_request_hdr` SET `request_by`='$newREQ' WHERE `reference_code`='$prfCode'"); mysql_query("UPDATE `prf_validate_links` SET `uid`='$newREQ' WHERE `po_code`='$prfCode' AND `completed`=0"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== mysql_query("INSERT INTO prf_changes_logs(action_taken,user_id,old_info,new_info,ref_number) VALUES('Change Requestor','{$userID}','','{$newREQ}','{$prfCode}')"); //AUDIT LOGS====================================================== //AUDIT LOGS====================================================== echo $gmLName.", " .$gmFName; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings