Stock Records

connect_error) { die("Connection failed: " . $conn->connect_error); } // Retrieve stock information from the database $sql = "SELECT * FROM product_stock"; $result = $conn->query($sql); if ($result->num_rows > 0) { // Display stock information in a table echo ""; echo ""; while ($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

ID	Product Name	Stock Quantity	Sales Price	Cost Price	Date and Time	Staff Name	Contact	Category
" . $row['id'] . "	" . $row['product_name'] . "	" . $row['stock_qty'] . "	" . $row['sales_price'] . "	" . $row['cost_price'] . "	" . $row['datetime'] . "	" . $row['staff_name'] . "	" . $row['contact'] . "	" . $row['category'] . "

"; } else { echo "No records found"; } // Close the database connection $conn->close(); ?>