treeking20@gmail.com – Page 2

Professional PHP for working with MySQ

treeking20@gmail.com Feb 29, 2024 0 Comments

homeworkDownload index <?php require_once('util/main.php'); require_once('model/database.php'); require_once('model/product_db.php'); require_once('model/category_db.php'); require_once('model/product.php'); require_once('model/category.php'); /********************************************* * Select some products **********************************************/ // Sample data $cat_id = 1; // Get the products $products = ProductDB::getProductsByCategory($cat_id); /*************************************** *…

Please sort

Week 5 – Case Assignment – How to use SQL to work with a database

treeking20@gmail.com Feb 11, 2024 0 Comments

select products(7) USE my_guitar_shop2; SELECT productName,description,listPrice FROM products WHERE description LIKE '%electric%'; select billing(8) USE my_guitar_shop2; SELECT firstName, lastName, line1, line2, city, state, zipCode FROM customers c INNER JOIN addresses…

Please sort

How to use SQL to create a database

treeking20@gmail.com Feb 3, 2024 0 Comments

DROP 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)…

Please sort

create some simple database designs

treeking20@gmail.com Jan 27, 2024 0 Comments

16-2 1 16-2 2

Please sort

Case Assignment – How to use PHP with a MySQL database

treeking20@gmail.com Jan 21, 2024 0 Comments

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) )…