Hệ thống quản lý hàng tồn kho bằng PHP

1 <?php
2     require_once(
'../../inc/config/constants.php');
3     require_once(
'../../inc/config/db.php');
4
5     
// Execute the script if the POST request is submitted
6     
if(isset($_POST['itemNumber'])){
7         
8         $itemNumber = htmlentities($_POST[
'itemNumber']);
9         
10         $itemDetailsSql =
'SELECT * FROM item WHERE itemNumber = :itemNumber';
11         $itemDetailsStatement = $conn->prepare($itemDetailsSql);
12         $itemDetailsStatement->execute([
'itemNumber' => $itemNumber]);
13         
14         
// If data is found for the given item number, return it as a json object
15         
if($itemDetailsStatement->rowCount() > 0) {
16             $row = $itemDetailsStatement->fetch(PDO::FETCH_ASSOC);
17             echo json_encode($row);
18         }
19         $itemDetailsStatement->closeCursor();
20     }
21 ?>


Gõ tìm kiếm nhanh...