" . $row[0] . ""; } $SQL = mysqli_query($link, "SELECT Product_ID FROM products"); while ($row = mysqli_fetch_array($SQL)) { $ProductIDs = $ProductIDs . ''; } $SupplierID_err = $qty_err = $billed_err = $Ordered_err = $Received_err = ''; if ($_SERVER["REQUEST_METHOD"] == "POST") { if (empty(($_POST["supplier"]))) { $SupplierID_err = "Select a Username for the account."; } else { $supplierID = trim($_POST['supplier']); } $qty = trim($_POST['qty']); $billed = trim($_POST['billed']); $Ordered = trim($_POST['Ordered']); $Received = trim($_POST['Received']); if (empty($qty) || strlen($qty) > 10) { $qty_err = 'Please enter a valid name.'; } if (empty($billed) || strlen($billed) > 17) { $billed_err = 'Please enter a valid phone number'; } if (empty($Ordered)) { $Ordered_err = 'please enter a date of birth'; } if (empty($Received)) { $Received_err = 'please enter a valid house number.'; } echo $SupplierID_err; if (empty($SupplierID_err) && empty($qty_err) && empty($billed_err) && empty($Ordered_err) && empty($Received_err)) { $sql = "INSERT INTO invoces (Invoice_ID, Supplier_ID, Total_Quantity, Billed_Amount, Date_Ordered, Date_Recived) VALUES (?,?,?,?,?,?)"; if ($stmt = mysqli_prepare($link, $sql)) { mysqli_stmt_bind_param($stmt, "ssssss", $invoiceID, $supplierID, $qty, $billed, $par_Ordered, $par_Received); $time = strtotime($Ordered); $nwFormat = date('Y-m-d', $time); $par_Ordered = $nwFormat; $time = strtotime($Received); $nwFormat = date('Y-m-d', $time); $par_Received = $nwFormat; $invoiceID = rand(1000000000, 9999999999); if (mysqli_stmt_execute($stmt)) { $checkitems = true; $checkitemsint = 0; while ($checkitems) { if (isset($_POST[$checkitemsint])) { $checkitemsint = $checkitemsint + 1; } else { $checkitems = false; } } $sql = "INSERT INTO recived_stock (Invoice_ID, Product_ID, quantity, price) VALUES (?,?,?,?)"; for ($i = 0; $i < $checkitemsint; $i++) { if ($stmtW = mysqli_prepare($link, $sql)) { $product_ID = trim($_POST['ProductID' . $i]); $subQty = trim($_POST['subqty' . $i]); $totalamount = trim($_POST['price' . $i]); mysqli_stmt_bind_param($stmtW, "ssii", $invoiceID, $product_ID, $subQty, $totalamount); if (mysqli_stmt_execute($stmtW)) { } else { echo 'fail'; } } } header('location: ../invoices'); } else { echo "something went wrong, please try again later"; } } } } ?> Dashboard

Add new employee

" method="post">

supplier ID

Total Quantity " . $qty_err . "

"; ?>

Amount Billed " . $billed_err . "

"; ?>

Date Ordered " . $Ordered_err . "

"; ?>

Date Received " . $Received_err . "

"; ?>

Items delivered:

Product ID

quantity

Total amount