Annotation of embedaddon/php/ext/mysqli/tests/table.inc, revision 1.1
1.1 ! misho 1: <?PHP
! 2: require_once('connect.inc');
! 3:
! 4: if (!$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:
! 10: if (!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:
! 15: if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine)) {
! 16: printf("Failed to create test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 17: exit(1);
! 18: }
! 19:
! 20: if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e'), (6, 'f')")) {
! 21: printf("[%d] %s\n", mysqli_errno($link), mysqli_error($link));
! 22: }
! 23: ?>
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>