· 8 years ago · Nov 24, 2017, 02:32 AM
1<?php
2
3 require_once("sqlconnect.php");
4
5 $sql = sqlConnect("phpdb");
6 if (!$sql)
7 {
8 echo "Problems...";
9 }
10 else
11 {
12 mysqli_query($sql, "DROP TABLE IF EXISTS user");
13
14 mysqli_query($sql, "
15
16 CREATE TABLE user(
17
18 username VARCHAR(30) NOT NULL,
19 password VARCHAR(30) NOT NULL,
20 access_level INT(1) NOT NULL,
21 first_name VARCHAR(20) NOT NULL,
22 middle_name VARCHAR(20),
23 last_name VARCHAR(30) NOT NULL,
24 address1 VARCHAR(30) NOT NULL,
25 address2 VARCHAR(30),
26 suburb VARCHAR(30) NOT NULL,
27 state VARCHAR(3) NOT NULL,
28 postcode INT(4) NOT NULL,
29 home_phone INT(10) NOT NULL,
30 mobile_phone INT(10),
31 email VARCHAR(50) NOT NULL,
32 dob DATE NOT NULL,
33 date_joined DATE NOT NULL,
34 member_type VARCHAR(20) NOT NULL,
35 fee INT(10) NOT NULL,
36 date_due DATE NOT NULL,
37 activities VARCHAR(100),
38 wish_list VARCHAR(100),
39 PRIMARY KEY (username, last_name)
40
41 ");
42
43 mysqli_close($sql);
44 echo("Done.");
45 }
46
47?>
48
49
50
51sqlconnect.php
52
53<?php
54
55$hostname = "localhost";
56$username = "root";
57$password = "";
58$port = 3306;
59
60function sqlConnect ( $database_ )
61{
62 $sql = mysqli_connect( $GLOBALS["hostname"], $GLOBALS["username"], $GLOBALS["password"], $database_, $GLOBALS["port"] );
63
64 if ( mysqli_connect_errno() )
65 {
66 exit();
67 return false;
68 }
69 return $sql;
70}
71
72?>