Advertisement
Guest User

Untitled

a guest
Sep 26th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.96 KB | None | 0 0
  1. <?php
  2.    
  3.     //connection to database
  4.     $dbHost = "localhost";
  5.     $dbUser = "homestead";
  6.     $dbPass = "secret";
  7.  
  8.  
  9.     //4th param is option, would be database name but we are creating one
  10.     $conn = mysqli_connect($dbHost, $dbUser, $dbPass);
  11.  
  12.     if (!$conn) {
  13.         die("connection failed: ".mysqli_connect_error());
  14.     }
  15.  
  16.     echo "connected to database";
  17.  
  18.  
  19.  
  20.     //create a db if it doesn't already exist
  21.     $sql = "CREATE DATABASE IF NOT EXISTS testDB";
  22.     mysqli_query($conn, $sql);
  23.  
  24.  
  25.  
  26.     mysqli_close($conn);
  27.     //======================CREATING A TABLE==============================\\
  28.     $dbName = "testDB";
  29.     $conn = mysqli_connect($dbHost, $dbUser, $dbPass, $dbName);
  30.  
  31.     if (!$conn) {
  32.         die("connection failed: ".mysqli_connect_error());
  33.     }
  34.  
  35.     $sql = "CREATE TABLE IF NOT EXISTS customers (
  36.             customer_id int(11) NOT NULL AUTO_INCREMENT,
  37.             firstName varchar(100) NOT NULL,
  38.             lastName varchar(100) NOT NULL,
  39.             billingAddress varchar(255) NOT NULL,
  40.             billingCity varchar(100) NOT NULL,
  41.             billingProvince varchar(100) NOT NULL,
  42.             billingCountry varchar(100) NOT NULL,
  43.             billingPostal varchar(20) NOT NULL,
  44.             shippingAddress varchar(255) NULL,
  45.             shippingCity varchar(100) NULL,
  46.             shippingProvince varchar(100) NULL,
  47.             shippingCountry varchar(100) NULL,
  48.             shippingPostal varchar(20) NULL,
  49.             PRIMARY KEY (customer_id) ) CHARSET=utf8";
  50.  
  51.     mysqli_query($conn, $sql) or die (mysqli_error());
  52.  
  53.  
  54.     $sql = "CREATE TABLE IF NOT EXISTS products (
  55.             product_id int(11) NOT NULL AUTO_INCREMENT,
  56.             product_name varchar(100) NOT NULL,
  57.             price DECIMAL(10,2) NOT NULL,
  58.             PRIMARY KEY (product_id) ) CHARSET=utf8";
  59.  
  60.     mysqli_query($conn, $sql) or die (mysqli_error());
  61.  
  62.     $sql = "CREATE TABLE IF NOT EXISTS order_lookup (
  63.             cart_id int(11) NOT NULL AUTO_INCREMENT,
  64.             customer_id varchar(100) NOT NULL,
  65.             product_id varchar(100) NOT NULL,
  66.             quantity int(11) NOT NULL,
  67.             PRIMARY KEY (cart_id) ) CHARSET=utf8";
  68.  
  69.     mysqli_query($conn, $sql) or die (mysqli_error());
  70. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement