8JKHvzk7

1<?php
2
3//DB connection variables
4$host = 'localhost';
5$user = 'root';
6$password = '';
7
8//create mysql connection
9$mysqli = new mysqli($host,$user,$password);
10if ($mysqli->connect_errno) {
11    printf("Connection failed: %s\n", $mysqli->connect_error);
12    die();
13}
14
15//Drop database if exist
16$mysqli->query('
17DROP DATABASE IF EXISTS `accounts`;
18') or die($mysqli->error);
19
20
21//create the database
22if ( !$mysqli->query('CREATE DATABASE accounts') ) {
23    printf("Errormessage: %s\n", $mysqli->error);
24}
25
26
27//create admin table
28$mysqli->query('
29CREATE TABLE `accounts`.`admins`
30(
31    `admin_id` VARCHAR(100) NOT NULL,
32    `fname` VARCHAR(50) NOT NULL,
33    `lname` VARCHAR(50) NOT NULL,
34	  `password` VARCHAR(50) NOT NULL,
35	  PRIMARY KEY (`admin_id`)
36);') or die($mysqli->error);
37
38//create user table
39$mysqli->query('
40CREATE TABLE `accounts`.`users`
41(
42    `email` VARCHAR(50) NOT NULL,
43    `fname` VARCHAR(50) NOT NULL,
44	  `lname` VARCHAR(50) NOT NULL,
45	  `password` VARCHAR(50) NOT NULL,
46	  `age` INT NOT NULL,
47	  `country` VARCHAR(100) NOT NULL,
48	  `image` BLOB,
49	 PRIMARY KEY (`email`)
50);') or die($mysqli->error);
51
52
53?>