1<?PHP 2require_once('connect.inc'); 3 4if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 5 printf("Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 6 $host, $user, $db, $port, $socket); 7 exit(1); 8} 9 10if (!mysqli_query($link, 'DROP TABLE IF EXISTS test')) { 11 printf("Failed to drop old test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 12 exit(1); 13} 14 15if (!mysqli_query($link, 'SET SESSION sql_mode=\'\'')) { 16 printf("Failed to drop old test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 17 exit(1); 18} 19 20if (!mysqli_query($link, 'CREATE TABLE test(id INT DEFAULT 0, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine)) { 21 printf("Failed to create test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 22 exit(1); 23} 24 25if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e'), (6, 'f')")) { 26 printf("[%d] %s\n", mysqli_errno($link), mysqli_error($link)); 27} 28?> 29
