Add Fruit

$maxFileSize) { die("File size exceeds the limit. Maximum allowed size is 1 MB."); } // Sanitize user input $name = mysqli_real_escape_string($conn, $_POST["name"]); $simpledesc = mysqli_real_escape_string($conn, $_POST["simpledesc"]); $fulldesc = mysqli_real_escape_string($conn, $_POST["fulldesc"]); $quantities = mysqli_real_escape_string($conn, $_POST["quantities"]); $buyer_price = mysqli_real_escape_string($conn, $_POST["buyer_price"]); $seller_price = mysqli_real_escape_string($conn, $_POST["seller_price"]); $buyer_availability = mysqli_real_escape_string($conn, $_POST["buyer_availability"]); $seller_availability = mysqli_real_escape_string($conn, $_POST["seller_availability"]); // Insert data into the database $sql_add_inventory = "INSERT INTO `inventory` (`name`, `img`, `simpledesc`, `fulldesc`, `quantities`, `buyer_price`, `seller_price`, `buyer_availability`, `seller_availability`) VALUES ('$name', '$imageData', '$simpledesc', '$fulldesc', '$quantities', '$buyer_price', '$seller_price', '$buyer_availability', '$seller_availability')"; $sql_add_buyer = "ALTER TABLE `buyer` ADD `$name` INT NOT NULL DEFAULT '0'"; $sql_add_seller = "ALTER TABLE `seller` ADD `$name` INT NOT NULL DEFAULT '0'"; // Execute the SQL statements $res_1 = mysqli_query($conn, $sql_add_inventory); $res_2 = mysqli_query($conn, $sql_add_buyer); $res_3 = mysqli_query($conn, $sql_add_seller); // Check if any query failed if ($res_1 && $res_2 && $res_3) { echo "Inventory added successfully!"; } else { echo "Error adding inventory. Please try again."; } } ?>