0) { for($i = 0; $i < count($_FILES['item_img']['name']); $i++){ $tmp_file = $_FILES['item_img']['tmp_name'][$i]; $ext = pathinfo($_FILES["item_img"]["name"][$i], PATHINFO_EXTENSION); $rand = md5(uniqid().rand()); $upd_image = $rand.".".$ext; move_uploaded_file($tmp_file,"images/item/".$upd_image); $sql_prd="INSERT into ah_item_images(item_id,image) values ('$last_id','$upd_image')"; $prd_res=mysqli_query($conn, $sql_prd) or die(mysqli_error()); } } echo ""; } }*/ if (isset($_POST['submit'])) { // Extract POST data securely $item_name = $_POST['item_name'] ?? ''; $item_hsn = $_POST['item_hsn'] ?? ''; $item_code = $_POST['item_code'] ?? ''; $sale_price = $_POST['sale_price'] ?? 0; $tax_type = $_POST['tax_type'] ?? ''; $disc_sale = $_POST['disc_sale'] ?? 0; $disc_type = $_POST['disc_type'] ?? ''; $wholesale_price = $_POST['wholesale_price'] ?? 0; $wtax = $_POST['wtax'] ?? 0; $min_wqty = $_POST['min_wqty'] ?? 0; $purchase_price = $_POST['purchase_price'] ?? 0; $ptax = $_POST['ptax'] ?? 0; $tax_rate = $_POST['tax_rate'] ?? 0; // Set timezone and get current datetime date_default_timezone_set('Asia/Kolkata'); $datetime = date('Y-m-d H:i:s'); // Prepared statement to insert into `ah_item_details` $sql = "INSERT INTO ah_item_details (item_name, item_hsn, item_code, sale_price, tax_type, disc_sale, disc_type, wholesale_price, wtax, min_wqty, purchase_price, ptax, tax_rate) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; $stmt = mysqli_prepare($conn, $sql); mysqli_stmt_bind_param($stmt, "sssdsdsddidid", $item_name, $item_hsn, $item_code, $sale_price, $tax_type, $disc_sale, $disc_type, $wholesale_price, $wtax, $min_wqty, $purchase_price, $ptax, $tax_rate); if (mysqli_stmt_execute($stmt)) { $last_id = mysqli_insert_id($conn); // Insert into `ah_item_tracking_details` $opening_stock = $_POST['opening_stock'] ?? 0; $at_price_unit = $_POST['at_price_unit'] ?? 0; $item_date = $_POST['item_date'] ?? date('Y-m-d'); $min_stock_quantity = $_POST['min_stock_quatity'] ?? 0; $item_location = $_POST['item_location'] ?? ''; $sql_tracking = "INSERT INTO ah_item_tracking_details (item_id, opening_stock, at_price_unit, item_date, min_stock_quatity, item_location) VALUES (?, ?, ?, ?, ?, ?)"; $stmt_tracking = mysqli_prepare($conn, $sql_tracking); mysqli_stmt_bind_param($stmt_tracking, "iddsis", $last_id, $opening_stock, $at_price_unit, $item_date, $min_stock_quantity, $item_location); mysqli_stmt_execute($stmt_tracking); // Redirect echo ""; } else { echo "Error: " . mysqli_error($conn); } // Close statements mysqli_stmt_close($stmt); mysqli_stmt_close($stmt_tracking); mysqli_close($conn); } ?>

Add New Item

Pricing

Sale Price

Wholesale Price

Purchase Price

Stock