Caliber Inventory
prepare("SELECT part_number, on_hand, concat('$', format(list, 2)) as list_price
FROM fbparts_inventory WHERE part_number = ?");
$stmt->bind_param("s", $part_number);
$stmt->execute();
$result = $stmt->get_result();
echo "
| Part Number |
On Hand |
List Price |
";
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "";
echo "| " . htmlspecialchars($row['part_number']) . " | ";
echo "" . htmlspecialchars($row['on_hand']) . " | ";
echo "" . htmlspecialchars($row['list_price']) . " | ";
echo "
";
}
} else {
echo "| No results found |
";
}
echo "
";
$stmt->close();
}
mysqli_close($con);
?>
