File manager - Edit - /home/autoph/public_html/connect/home/save_added_new_item.php
Back
<?php include 'core/init.php'; error_reporting(0); //if submit/ save to databasevar ` if(isset($_POST['done'])){ $SelBoxID = mysql_escape_string($_POST['SelBoxID']); $itemDesc = mysql_escape_string($_POST['itemDesc']); $itemQTY = mysql_escape_string($_POST['itemQTY']); $itemCondition = mysql_escape_string($_POST['itemCondition']); $itemUoM = mysql_escape_string($_POST['itemUoM']); $addDate = $toDate; $addTime = $currentTime; mysql_query("INSERT INTO gots_box_items (box_id, item_desc, item_qty, uom, item_condition, add_date, add_time) VALUES('{$SelBoxID}','{$itemDesc}','{$itemQTY}','{$itemUoM}','{$itemCondition}','{$addDate}','{$addTime}')"); exit(); } //display from database if(isset($_POST['display'])){ $SelBoxID = mysql_escape_string($_POST['SelBoxID']); $itemDesc = mysql_escape_string($_POST['itemDesc']); $itemQTY = mysql_escape_string($_POST['itemQTY']); $itemCondition = mysql_escape_string($_POST['itemCondition']); $itemUoM = mysql_escape_string($_POST['itemUoM']); $addDate = $toDate; $addTime = $currentTime; $itemresult = mysql_query("SELECT * FROM gots_box_items WHERE `box_id`='$SelBoxID' AND `deleted`='0' ORDER BY `add_date` DESC"); echo "<table style='width:100%;'>"; echo "<thead> <tr> <th style='border:0px solid white;padding:5px;font-weight:bold'>NO</th> <th style='border:0px solid white;padding:5px;font-weight:bold'>BOX NO</th> <th style='border:0px solid white;padding:5px;font-weight:bold'>ITEM DESCRIPTION</th> <th style='border:0px solid white;padding:5px;font-weight:bold'>QTY</th> <th style='border:0px solid white;padding:5px;font-weight:bold'>UOM</th> <th style='border:0px solid white;padding:5px;font-weight:bold'>CONDITION</th> <th style='border:0px solid white;padding:5px;font-weight:bold'></th> </tr> </thead>"; while($row=mysql_fetch_array($itemresult)){ $no = $no + 1; echo "<tr>"; echo "<td style='border:0px solid white;padding:5px;font-family:Calibri;font-weight:normal;color:#4a789b ;font-size:16px'>".$no."</td>"; echo "<td style='border:0px solid white;padding:5px;font-family:Calibri;font-weight:normal;color:#4a789b ;font-size:16px'>".$row['box_id']."</td>"; echo "<td style='border:0px solid white;padding:5px;font-family:Calibri;font-weight:normal;color:#4a789b ;font-size:16px'>".$row['item_desc']."</td>"; echo "<td style='border:0px solid white;padding:5px;font-family:Calibri;font-weight:normal;color:#4a789b ;font-size:16px'>".$row['item_qty']."</td>"; echo "<td style='border:0px solid white;padding:5px;font-family:Calibri;font-weight:normal;color:#4a789b ;font-size:16px'>".$row['uom']."</td>"; echo "<td style='border:0px solid white;padding:5px;font-family:Calibri;font-weight:normal;color:#4a789b ;font-size:16px'>".$row['item_condition']."</td>"; echo "<td style='border:0px solid white;padding:5px;font-family:Calibri;font-weight:normal;color:#4a789b ;font-size:16px'>✕</td>"; echo "</tr>"; } echo "</table>"; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings