· 8 years ago · Dec 19, 2017, 08:48 AM
1$db = new mysqli('localhost', 'user.name', 'user.pass', 'db');
2
3 if ($db === FALSE) {
4 echo "ERRROR";
5 }
6
7 $sql = "CREATE TABLE IF NOT EXISTS db (
8 ID INT NOT NULL AUTO_INCREMENT,
9 NAME VARCHAR(20) NULL
10 )";
11
12 $db->query($sql);
13
14 if (mysqli_query($db, $sql)) {
15 echo "TABLE CREATED SUCCESSFULLY";
16 } else {
17 echo "TABLE CREATED UNSUCCESSFULLY";
18 }
19
20$sql = "CREATE TABLE IF NOT EXISTS db (
21 ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
22 NAME VARCHAR(20) NULL
23 )";
24
25CREATE TABLE IF NOT EXISTS db (
26 ID INT NOT NULL AUTO_INCREMENT,
27 NAME VARCHAR(20) NULL;
28
29CREATE TABLE IF NOT EXISTS db (
30 ID INT NOT NULL AUTO_INCREMENT,
31 NAME VARCHAR(20) NULL,
32 key idx_ID(ID)
33 );
34
35$db = new mysqli('localhost', 'user.name', 'user.pass', 'db');
36
37 if ($db === FALSE) {
38 echo "ERRROR";
39 }
40
41 $sql = "CREATE TABLE IF NOT EXISTS db (
42 ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
43 NAME VARCHAR(20) NULL
44 )";
45
46 $db->query($sql);
47
48 if (mysqli_query($db, $sql)) {
49 echo "TABLE CREATED SUCCESSFULLY";
50 } else {
51 echo "TABLE CREATED UNSUCCESSFULLY";
52 }