File manager - Edit - /home/autoph/public_html/connect/home/PRF/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'])){ $UpdatePRFReferenceNumber = mysql_escape_string($_POST['UpdatePRFReferenceNumber']); $selItemDesc = mysql_escape_string($_POST['selItemDesc']); $ActionReferenceIDDescXX = mysql_escape_string($_POST['ActionReferenceIDDescXX']); mysql_query("UPDATE `prf_request_detl` SET `item_description`='$selItemDesc' WHERE `id`='$ActionReferenceIDDescXX'"); $getItemDetl = mysql_query("SELECT * FROM prf_request_detl WHERE header_ref_code='$UpdatePRFReferenceNumber'"); echo "<table>"; echo "<thead>"; echo "<th style='width:100px'>Rec.#</th>"; echo "<th style='width:155px'>REF. #</th>"; echo "<th style='width:320px'>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; ?><tr onDblclick="javascript:POPUPShowDeleteSubItem(this);"><?php echo "<td>".$row['id']."</td>"; echo "<td>".strtoupper($row['header_ref_code'])."</td>"; echo "<td>".strtoupper($row['item_description'])."</td>"; echo "<td>".strtoupper($row['uom'])."</td>"; echo "<td style='text-align:center'>".strtoupper($row['quantity'])."</td>"; echo "<td style='tet-align:center;padding-left:15px'><button id='UpdatedeletePRFItem' class='XdeleteButton'></button></td>"; echo "</tr>"; } echo "</table>"; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings