smLm4UC3

1$servername = "localhost";
2        $username = "root";
3        $password = "";
4        $dbname = "someDbName";
5        $conn = mysqli_connect($servername, $username, $password, $dbname);
6                if (!$conn) {
7                    die("Connection failed: " . mysqli_connect_error());
8                }
9                    $sql = "CREATE TABLE IF NOT EXISTS someTableName(
10                    someID INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
11                    someVar1 VARCHAR(30) NOT NULL,
12                    someVar2 INT NOT NULL);
13                    INSERT INTO someTableName (someVar1 , someVar2 ) VALUES ('someString1', someInteger1),
14                    ('someString2',someInteger2);";
15	
16$sql = mysqli_real_escape_string($conn, $sql);    
17            if (mysqli_multi_query($conn, $sql)) {
18                dtconsole("Tables populated successfully");
19            } else {
20                dtconsole("Error creating table: " . mysqli_error($conn));
21            }
22	
23function dtconsole($data){
24        $output=$data;
25        if(is_array($output)){
26            $output=implode(',',$output);
27        }
28        echo '<script>console.log("'.$output.'");</script>';
29    }