xref: /PHP-5.5/ext/mysqli/tests/table.inc (revision 4e2c0161)
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