prepare($sqlproducts);
$stmt1->execute();
$resultsproducts = $stmt1->fetchAll(PDO::FETCH_ASSOC);
// read from suppliers table
$sqlsuppliers = "SELECT supplier_name, ID FROM suppliers ORDER BY supplier_name ASC";
$stmt2 = $pdo->prepare($sqlsuppliers);
$stmt2->execute();
$resultssupliers = $stmt2->fetchAll(PDO::FETCH_ASSOC);
if($_SERVER['REQUEST_METHOD'] == 'POST') {
$pdo->beginTransaction();
$prodnumber = $_REQUEST["output"];
$suppliernumber = $_REQUEST["output1"];
$amount = $_POST['amount'];
$project_number = 0;
$amount_out = 0;
/*
echo "Prod:";
echo $prodnumber;
echo '
';
echo "Supplier:";
echo $suppliernumber;
echo '
';
echo "Amount:";
echo $amount;
echo '
';
*/
if(empty($prodnumber) || empty($suppliernumber) || empty($amount)) {
?>
prepare($sql);
$stmt->execute(['product_number' => $prodnumber, 'supplier_ID' => $suppliernumber, 'project_number' => $project_number, 'amount_in' => $amount, 'amount_out' => $amount_out]);
$pdo->commit();
?>
rollBack();
?>
" . 'N° : '.$e->getCode();
echo "
" . 'Error : '.$e->getMessage();
$pdo = null;
}
?>
הכנסה למלאי