How to use SQL to create a database
treeking20@gmail.comDROP DATABASE IF EXISTS ap; CREATE DATABASE IF NOT EXISTS ap; USE ap; CREATE TABLE vendors ( vendorID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, vendorName VARCHAR(45) NOT NULL, vendorAddress VARCHAR(45)…
Case Assignment – How to use PHP with a MySQL database
edit product.php <?php // Get the product data $category_id = $_POST['category_id']; $code = $_POST['code']; $name = $_POST['name']; $price = $_POST['price']; $product_id = $_POST['productID']; // Validate inputs if (empty($code)|| empty($name)||empty($price) )…