/PHP-5.5/ext/mysqli/tests/ |
H A D | 007.phpt | 15 if (!mysqli_query($link, "SET sql_mode=''")) 16 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 18 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 19 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 29 printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 32 printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 34 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 44 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); 45 mysqli_close($link); 55 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 008.phpt | 15 if (!mysqli_query($link, "SET sql_mode=''")) 16 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 18 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 19 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 29 printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 32 printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 34 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 44 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); 45 mysqli_close($link); 55 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 009.phpt | 20 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 23 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 34 printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 39 printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 60 printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 63 printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 66 printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 78 mysqli_close($link); 88 printf("[002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 91 printf("[002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 010.phpt | 15 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 17 if (!mysqli_query($link, "SET sql_mode=''")) 18 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 20 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 21 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 31 printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 37 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 47 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); 48 mysqli_close($link); 58 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 011.phpt | 15 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 17 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result")) 18 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 26 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 32 printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 34 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_result"); 44 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result"); 45 mysqli_close($link); 54 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result")) 55 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 012.phpt | 15 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 17 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result")) 18 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 26 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 31 printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 33 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_result"); 43 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result"); 44 mysqli_close($link); 53 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result")) 54 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 013.phpt | 15 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result")) 16 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 24 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 29 printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 31 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_result"); 40 $result = mysqli_query($link, "select * from test_bind_result"); 50 mysqli_get_server_version($link) > 50000) 55 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result"); 56 mysqli_close($link); 66 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 014.phpt | 10 if (!$link) 14 die(sprintf("Needs InnoDB support, [%d] %s", $link->errno, $link->error)); 22 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 25 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 28 printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 31 printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 34 printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 37 printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 40 printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 43 printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 015.phpt | 13 die(sprintf("Needs InnoDB support, [%d] %s", $link->errno, $link->error)); 20 if (!$link) 25 mysqli_errno($link), mysqli_error($link)); 29 mysqli_errno($link), mysqli_error($link)); 35 mysqli_errno($link), mysqli_error($link)); 39 mysqli_errno($link), mysqli_error($link)); 44 mysqli_errno($link), mysqli_error($link)); 48 mysqli_errno($link), mysqli_error($link)); 52 printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 61 mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 016.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 if (!mysqli_query($link, "SET @dummy='foobar'")) 16 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 18 if (!$stmt = mysqli_prepare($link, "SELECT @dummy")) 19 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 28 mysqli_close($link);
|
H A D | 017.phpt | 14 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 16 if (!$stmt = mysqli_prepare($link, "SELECT md5('bar'), database(), 'foo'")) 17 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 31 mysqli_close($link);
|
H A D | 018.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 if (!mysqli_query($link, "SET AUTOCOMMIT=0")) 16 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 18 if (!$stmt = mysqli_prepare($link, "SELECT @@autocommit")) 19 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 28 mysqli_close($link);
|
H A D | 019.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 if (!mysqli_query($link, "DROP TABLE IF EXISTS insert_read")) 16 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 26 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 29 printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 42 printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 54 mysqli_query($link, "DROP TABLE IF EXISTS insert_read"); 55 mysqli_close($link); 64 if (!mysqli_query($link, "DROP TABLE IF EXISTS insert_read")) 65 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 020.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 mysqli_select_db($link, $db); 16 mysqli_query($link, "SET sql_mode=''"); 18 mysqli_query($link,"DROP TABLE IF EXISTS test_bind_result"); 20 $rc = @mysqli_query($link,"CREATE TABLE test_bind_result( 30 $rc = mysqli_query($link,"CREATE TABLE test_bind_result( 65 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result"); 66 mysqli_close($link); 76 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result")) 77 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 021.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 mysqli_select_db($link, $db); 17 mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch"); 18 mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 char(10), c2 text)"); 20 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?)"); 27 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 37 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); 38 mysqli_close($link); 47 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 48 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 022.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 mysqli_select_db($link, $db); 17 mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch"); 18 mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 char(10), c2 text)"); 21 $stmt = mysqli_prepare($link, "INSERT INTO test_bind_fetch VALUES (?,?)"); 30 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 41 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); 42 mysqli_close($link); 52 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 53 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 023.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 mysqli_select_db($link, $db); 16 mysqli_query($link, "SET sql_mode=''"); 18 mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch"); 19 mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 int unsigned, 40 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 50 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); 51 mysqli_close($link); 61 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 62 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 024.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 mysqli_select_db($link, $db); 16 mysqli_query($link, "SET sql_mode=''"); 18 mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch"); 19 mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 smallint unsigned, 41 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 51 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); 52 mysqli_close($link); 61 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 62 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 025.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 mysqli_select_db($link, $db); 16 mysqli_query($link, "SET sql_mode=''"); 18 mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch"); 19 mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 tinyint, 45 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 55 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); 56 mysqli_close($link); 66 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 67 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 026.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 mysqli_select_db($link, $db); 16 mysqli_query($link, "SET sql_mode=''"); 18 mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch"); 21 $stmt = mysqli_prepare ($link, "INSERT INTO test_bind_fetch VALUES (?,?)"); 33 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch"); 43 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); 44 mysqli_close($link); 53 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 54 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 027.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 $status = mysqli_stat($link); 19 mysqli_close($link);
|
H A D | 028.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 $cset = substr(mysqli_character_set_name($link),0,6); 19 mysqli_close($link);
|
H A D | 029.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 mysqli_select_db($link, $db); 17 mysqli_query($link, "DROP TABLE IF EXISTS general_test"); 18 mysqli_query($link, "CREATE TABLE general_test (a INT)"); 19 mysqli_query($link, "INSERT INTO general_test VALUES (1),(2),(3)"); 21 $afc = mysqli_affected_rows($link); 25 mysqli_query($link, "DROP TABLE IF EXISTS general_test"); 26 mysqli_close($link); 35 if (!mysqli_query($link, "DROP TABLE IF EXISTS general_test")) 36 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 030.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 14 $errno = mysqli_errno($link); 17 mysqli_select_db($link, $db); 19 mysqli_query($link, "SELECT * FROM non_exisiting_table"); 20 $errno = mysqli_errno($link); 24 mysqli_close($link);
|
H A D | 031.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 14 $error = mysqli_error($link); 17 mysqli_select_db($link, $db); 19 mysqli_query($link, "SELECT * FROM non_exisiting_table"); 20 $error = mysqli_error($link); 24 mysqli_close($link);
|