File manager

File manager - Edit - /home/autoph/public_html/connect/home/prf_UpdateItemDescription.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); 193 * 1067 * 215 $prfDate = date_create() ->format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $myUID = $user_data['u_id']; if(isset($_POST['done'])){ $selUOM = mysql_escape_string($_POST['selUOM']); $selQuantity = mysql_escape_string($_POST['selQuantity']); $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $selItemDesc = mysql_escape_string($_POST['selItemDesc']); $ActionReferenceIDDescXX = mysql_escape_string($_POST['ActionReferenceIDDescXX']); $getOldQTY = mysql_result(mysql_query("SELECT `quantity` FROM `prf_request_detl` WHERE `id`='$ActionReferenceIDDescXX'"),0); mysql_query("INSERT INTO prf_changes_logs(id,action_taken,user_id,old_info,new_info, ref_number) VALUES('','Change Item QTY','{$myUID}','{$getOldQTY}','{$selQuantity}','{$UpdatePRFReferenceNumber}')"); mysql_query("UPDATE `prf_request_detl` SET `item_description`='$selItemDesc',`uom`='$selUOM',`quantity`='$selQuantity' WHERE `id`='$ActionReferenceIDDescXX'"); //mysql_query("UPDATE `prf_request_hdr` SET `ahg_admin_id`='$myUID', `ahg_admin_date`='$myDate' WHERE `reference_code`='$UpdatePRFReferenceNumber'"); $getItemDetl = mysql_query("SELECT * FROM prf_request_detl WHERE header_ref_code='$UpdatePRFReferenceNumber' AND `deleted`=0"); echo "<table>"; echo "<thead>"; echo "<th style='width:50px'>Rec.#</th>"; echo "<th style='width:100px'>REF. #</th>"; echo "<th style='width:100px'>TYPE</th>"; echo "<th style='width:300px'>ITEM DESCRIPTION</th>"; echo "<th style='width:50px'>UoM</th>"; echo "<th style='width:50px'>QUANTITY</th>"; echo "<th style='width:5px'>-</th>"; echo "</thead>"; while($row=mysql_fetch_array($getItemDetl)){ $count = $count + 1; $itemStatusChk=$row['ahg_admin_id']; if($itemStatusChk !=0){ $itemStatus='Ok'; }else{ $itemStatus='???'; } ?><tr onclick="javascript:POPUPShowDeleteSubItem(this);"><?php echo "<td style='font-family:Calibri;color:$txtcolor'>".$row['id']."</td>"; echo "<td style='font-family:Calibri;color:$txtcolor'>".strtoupper($row['header_ref_code'])."</td>"; echo "<td style='font-family:Calibri;color:$txtcolor'>"; $getClass = mysql_result(mysql_query("SELECT `item_category` FROM `prf_item_category` WHERE `id`='".$row['item_class']."'"),0); echo strtoupper($getClass); echo"</td>"; echo "<td style='font-family:Calibri;color:$txtcolor'>".strtoupper($row['item_description'])."</td>"; echo "<td style='font-family:Calibri;color:$txtcolor'>".strtoupper($row['uom'])."</td>"; echo "<td style='text-align:center;color:$txtcolor'>".strtoupper($row['quantity'])."</td>"; echo "<td style='tet-align:center;padding-left:15px;color:$txtcolor'>"; echo $itemStatus; echo "</td>"; echo "</tr>"; } echo "</table>"; exit(); } ?>

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