public function connect() { require_once "connect.inc"; $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); var_dump($link); $link = mysqli_init(); /* @ is to suppress 'Property access is not allowed yet' */ @var_dump($link); $mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket); $mysql->query("DROP TABLE IF EXISTS test_bug34810_table_1"); $mysql->query("CREATE TABLE test_bug34810_table_1 (a int not null)"); $mysql->query("SET sql_mode=''"); $mysql->query("INSERT INTO test_bug34810_table_1 VALUES (1),(2),(NULL)"); $warning = $mysql->get_warnings(); if (!$warning) { printf("[001] No warning!\n"); } if ($warning->errno == 1048 || $warning->errno == 1253) { /* 1048 - Column 'a' cannot be null, 1263 - Data truncated; NULL supplied to NOT NULL column 'a' at row */ if ("HY000" != $warning->sqlstate) { printf("[003] Wrong sql state code: %s\n", $warning->sqlstate); } if ("" == $warning->message) { printf("[004] Message string must not be empty\n"); } } else { printf("[002] Empty error message!\n"); var_dump($warning); } }
<?php require_once "connect.inc"; $mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket); $mysql->query("DROP TABLE IF EXISTS not_exists"); var_dump($mysql->warning_count); $w = $mysql->get_warnings(); var_dump($w->errno); var_dump($w->message); var_dump($w->sqlstate); $mysql->close(); echo "done!";
<?php require_once "connect.inc"; /*** test mysqli_connect 127.0.0.1 ***/ $mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket); $mysql->query("DROP TABLE IF EXISTS test_066_table_1"); $mysql->query("CREATE TABLE test_066_table_1 (a int not null) ENGINE=myisam"); $mysql->query("INSERT INTO test_066_table_1 VALUES (1),(2),(NULL)"); if ($warning = $mysql->get_warnings()) { do { printf("Warning\n"); } while ($warning->next()); } $mysql->close(); print "done!"; require_once "connect.inc"; if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) { printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); } if (!mysqli_query($link, "DROP TABLE IF EXISTS test_066_table_1")) { printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } mysqli_close($link);