Back to index

php5  5.3.10
table.inc
Go to the documentation of this file.
00001 <?PHP
00002 require_once('connect.inc');
00003 
00004 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
00005        printf("Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
00006               $host, $user, $db, $port, $socket);
00007        exit(1);
00008 }
00009 
00010 if (!mysqli_query($link, 'DROP TABLE IF EXISTS test')) {
00011        printf("Failed to drop old test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
00012        exit(1);
00013 }
00014 
00015 if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine)) {
00016        printf("Failed to create test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
00017        exit(1);
00018 }
00019 
00020 if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e'), (6, 'f')")) {
00021        printf("[%d] %s\n",  mysqli_errno($link), mysqli_error($link));
00022 }
00023 ?>