query("SELECT DISTINCT products.product_name, products.product_number, products.IDCategorie FROM inventory_stock
INNER JOIN products ON inventory_stock.product_number = products.product_number WHERE products.product_number = $product_number");
$sth->setFetchMode(PDO::FETCH_BOTH);// Mode par défaut (tableau)
while($row = $sth->fetch())
{
$firstname = $row['product_name'] ;
$lastname = $row['product_number'] ;
}
echo "
דף חשבון של ", $firstname, ' ', $lastname,"
";
*/
// read product name from a specific product
$prod = $pdo->prepare("SELECT product_name FROM products WHERE product_number = :product_number");
$prod->bindValue(':product_number', $product_number);
$prod->execute();
$row = $prod->fetch(PDO::FETCH_ASSOC);
$product_name = $row['product_name'];
// echo $row['product_name'];
// read sum total input from a specific product
$sum = $pdo->prepare("SELECT SUM(amount_in) AS 'Total_Input' FROM inventory_stock WHERE product_number = :product_number");
$sum->bindValue(':product_number', $product_number);
$sum->execute();
$row = $sum->fetch(PDO::FETCH_ASSOC);
$total_in = $row['Total_Input'];
// echo $row['Total_Input'];
// read sum total output from a specific product
$sum = $pdo->prepare("SELECT SUM(amount_out) AS 'Total_Output' FROM inventory_stock WHERE product_number = :product_number");
$sum->bindValue(':product_number', $product_number);
$sum->execute();
$row = $sum->fetch(PDO::FETCH_ASSOC);
$total_out = $row['Total_Output'];
// echo $row['Total_Output'];
$total = $total_in - $total_out;
$total = max($total, 0);
echo "