diff options
Diffstat (limited to 'ext/mysqli/tests/table.inc')
| -rw-r--r-- | ext/mysqli/tests/table.inc | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/ext/mysqli/tests/table.inc b/ext/mysqli/tests/table.inc new file mode 100644 index 0000000..aa1207a --- /dev/null +++ b/ext/mysqli/tests/table.inc @@ -0,0 +1,23 @@ +<?PHP +require_once('connect.inc'); + +if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { + printf("Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", + $host, $user, $db, $port, $socket); + exit(1); +} + +if (!mysqli_query($link, 'DROP TABLE IF EXISTS test')) { + printf("Failed to drop old test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + exit(1); +} + +if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine)) { + printf("Failed to create test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + exit(1); +} + +if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e'), (6, 'f')")) { + printf("[%d] %s\n", mysqli_errno($link), mysqli_error($link)); +} +?>
\ No newline at end of file |