File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_UPDATECLEARANCEFORM.php

Back
<?php include 'core/init.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); <p style="border-radius:0px;float:right;width:100%;padding:10px;padding-top:5px;height:40px">❖   CLEARANCE INFORMATION: </p> $compID= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); if(isset($_POST['done'])){ $EffectiveDate = mysql_escape_string($_POST['EffectiveDate']); $headerData = mysql_escape_string($_POST['headerData']); $clearingID = mysql_escape_string($_POST['clearingID']); $recomendA = mysql_escape_string($_POST['recomendA']); $recomendB = mysql_escape_string($_POST['recomendB']); $approverA = mysql_escape_string($_POST['approverA']); $approverB = mysql_escape_string($_POST['approverB']); $ClearanceDataID = mysql_escape_string($_POST['ClearanceDataID']); //$hedID = mysql_result(mysql_query("SELECT `cl_hdr_id` FROM `cl_clearance_data` WHERE `cl_id`='$ClearanceDataID'"),0); if($EffectiveDate !=''){ mysql_query("UPDATE `cl_clearance_header` SET `cl_effectivity_date`='$EffectiveDate' WHERE `h_id`='$ClearanceDataID'"); echo "Effectivity date has been updated.<br>"; } if($recomendA !=''){ mysql_query("UPDATE `cl_clearance_header` SET `cl_recommender_a_id`='$recomendA' WHERE `h_id`='$ClearanceDataID'"); echo "Recommending Officer 1 has been changed.<br>"; } if($recomendB !=''){ mysql_query("UPDATE `cl_clearance_header` SET `cl_recommender_b_id`='$recomendB' WHERE `h_id`='$ClearanceDataID'"); echo "Recommending Officer 2 has been changed.<br>"; } if($approverA !=''){ mysql_query("UPDATE `cl_clearance_header` SET `cl_approver_id`='$approverA' WHERE `h_id`='$ClearanceDataID'"); } if($approverB !=''){ mysql_query("UPDATE `cl_clearance_header` SET `cl_approver_id_b`='$approverB' WHERE `h_id`='$ClearanceDataID'"); echo "Approving Officer 2 has been changed.<br>"; } if($headerData !=''){ mysql_query("UPDATE `cl_clearance_data` SET `cl_approver_id_a`='$clearingID' WHERE `cl_id`='$headerData'"); echo "Clearing Officer 1 has been changed.<br>"; } // echo "<script>Alert('ERROR: PO Number ".$myPONumber." cannot be found in the PO Table. Please contact your system support for assistance. Thank yoU!');</script>"; exit; } ?>

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