· 8 years ago · Dec 19, 2017, 08:44 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 }