OLD FILE
Table name: categories
# ID - type: int(11) - AUTO_INCREMENT
# stock_in_date - type: timestamp - current_timestamp()
# product_number - type: varchar(255) utf8_unicode_ci
# categorie_number - type: int(11)
# supplier_ID - type: int(11)
# amount_in - type: int(11)
prepare($sql);
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
// read from products table, to select in form
$sqlproducts = "SELECT product_name, product_number FROM products ORDER BY product_name ASC";
$stmt1 = $pdo->prepare($sqlproducts);
$stmt1->execute();
$resultsproducts = $stmt1->fetchAll(PDO::FETCH_ASSOC);
// read from suppliers table, to select in form
$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();
$categorienumber = $_REQUEST["output"];
$prodnumber = $_REQUEST["output1"];
$suppliernumber = $_REQUEST["output2"];
$amount = $_POST['amount'];
/*echo "Prod:";
echo $prodnumber;
echo '
';
echo "Cat:";
echo $categorienumber;
echo '
';
echo "Supplier:";
echo $suppliernumber;
echo '
';
echo "Amount:";
echo $amount;
echo '
';*/
if(empty($prodnumber) || empty($categorienumber) || empty($suppliernumber) || empty($amount)) {
$status = "יש למלא את כל השדות";
echo "";
} else {
// way 1
$sql = "INSERT INTO stock_input (product_number, categorie_number, supplier_ID, amount_in) VALUES (:product_number, :categorie_number, :supplier_ID, :amount_in)";
$stmt = $pdo->prepare($sql);
$stmt->execute(['product_number' => $prodnumber, 'categorie_number' => $categorienumber, 'supplier_ID' => $suppliernumber, 'amount_in' => $amount]);
// way 2
/*
$table_data_integration = "stock_input";
$data_integration = array
(
"product_number" => "$prodnumber",
"categorie_number" => "$categorienumber",
"supplier_ID" => "$suppliernumber",
"amount_in" => "$amount",
);
$pdo->query("INSERT INTO `$table_data_integration` (`".implode('`,`',array_keys($data_integration))."`) VALUES ('".implode('\',\'',array_values($data_integration))."');");
*/
// $last_id = $conn->lastInsertId(); // read last ID from the table
// way 3
/*
$data = [
'product_number' => $prodnumber,
'categorie_number' => $categorienumber,
'supplier_ID' => $suppliernumber,
'amount_in' => $amount,
];
$sql = "INSERT INTO stock_input (product_number, categorie_number, supplier_ID, amount_in) VALUES (:product_number, :categorie_number, :supplier_ID, :amount_in)";
$stmt= $pdo->prepare($sql);
$stmt->execute($data);
*/
$status = "נקלט בהצלחה";
echo "";
}
}
//$prodnumber = "";
//$categorienumber = "";
//$suppliernumber = "";
//$amount = "";
}
catch(Exception $e){
$pdo->rollBack();
// echo "שגיאה, לא נעשה עדכון
";
echo "";
// echo "
" . 'N° : '.$e->getCode();
$pdo = null;
}
?>
הכנסה למלאי