Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //connection to database
- $dbHost = "localhost";
- $dbUser = "homestead";
- $dbPass = "secret";
- //4th param is option, would be database name but we are creating one
- $conn = mysqli_connect($dbHost, $dbUser, $dbPass);
- if (!$conn) {
- die("connection failed: ".mysqli_connect_error());
- }
- echo "connected to database";
- //create a db if it doesn't already exist
- $sql = "CREATE DATABASE IF NOT EXISTS testDB";
- mysqli_query($conn, $sql);
- mysqli_close($conn);
- //======================CREATING A TABLE==============================\\
- $dbName = "testDB";
- $conn = mysqli_connect($dbHost, $dbUser, $dbPass, $dbName);
- if (!$conn) {
- die("connection failed: ".mysqli_connect_error());
- }
- $sql = "CREATE TABLE IF NOT EXISTS customers (
- customer_id int(11) NOT NULL AUTO_INCREMENT,
- firstName varchar(100) NOT NULL,
- lastName varchar(100) NOT NULL,
- billingAddress varchar(255) NOT NULL,
- billingCity varchar(100) NOT NULL,
- billingProvince varchar(100) NOT NULL,
- billingCountry varchar(100) NOT NULL,
- billingPostal varchar(20) NOT NULL,
- shippingAddress varchar(255) NULL,
- shippingCity varchar(100) NULL,
- shippingProvince varchar(100) NULL,
- shippingCountry varchar(100) NULL,
- shippingPostal varchar(20) NULL,
- PRIMARY KEY (customer_id) ) CHARSET=utf8";
- mysqli_query($conn, $sql) or die (mysqli_error());
- $sql = "CREATE TABLE IF NOT EXISTS products (
- product_id int(11) NOT NULL AUTO_INCREMENT,
- product_name varchar(100) NOT NULL,
- price DECIMAL(10,2) NOT NULL,
- PRIMARY KEY (product_id) ) CHARSET=utf8";
- mysqli_query($conn, $sql) or die (mysqli_error());
- $sql = "CREATE TABLE IF NOT EXISTS order_lookup (
- cart_id int(11) NOT NULL AUTO_INCREMENT,
- customer_id varchar(100) NOT NULL,
- product_id varchar(100) NOT NULL,
- quantity int(11) NOT NULL,
- PRIMARY KEY (cart_id) ) CHARSET=utf8";
- mysqli_query($conn, $sql) or die (mysqli_error());
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement