/PHP-5.5/ext/mysqli/tests/ |
H A D | 032.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_info($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 | 033.phpt | 14 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 16 $hinfo = mysqli_get_host_info($link); 20 mysqli_close($link);
|
H A D | 034.phpt | 14 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 16 $pinfo = mysqli_get_proto_info($link); 20 mysqli_close($link);
|
H A D | 035.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 $sinfo = substr(mysqli_get_server_info($link),0,1); 19 mysqli_close($link);
|
H A D | 036.phpt | 19 mysqli_select_db($link, $db); 21 mysqli_query($link, "DROP TABLE IF EXISTS t036"); 24 mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo1')"); 25 $test[] = mysqli_insert_id($link); 33 mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo2')"); 36 $x = mysqli_insert_id($link); 41 mysqli_query($link, "DROP TABLE IF EXISTS t036"); 42 mysqli_close($link); 51 if (!mysqli_query($link, "DROP TABLE IF EXISTS t036")) 52 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 037.phpt | 16 mysqli_select_db($link, $db); 18 mysqli_query($link, "DROP TABLE IF EXISTS test_result"); 22 mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')"); 23 $ir[] = mysqli_field_count($link); 25 mysqli_real_query($link, "SELECT * FROM test_result"); 26 $ir[] = mysqli_field_count($link); 31 mysqli_query($link, "DROP TABLE IF EXISTS test_result"); 32 mysqli_close($link); 41 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_result")) 42 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 038.phpt | 15 mysqli_select_db($link, $db); 17 mysqli_query($link, "DROP TABLE IF EXISTS test_result"); 21 mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')"); 23 mysqli_real_query($link, "SELECT * FROM test_result"); 24 if (mysqli_field_count($link)) { 25 $result = mysqli_store_result($link); 32 mysqli_query($link, "DROP TABLE IF EXISTS test_result"); 33 mysqli_close($link); 41 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_result")) 42 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 039.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 mysqli_real_query($link, "SHOW VARIABLES"); 17 if (mysqli_field_count($link)) { 18 $result = mysqli_store_result($link); 25 mysqli_close($link);
|
H A D | 040.phpt | 15 mysqli_select_db($link, $db); 17 mysqli_query($link, "DROP TABLE IF EXISTS test_result"); 19 mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')"); 21 mysqli_real_query($link, "SELECT * FROM test_result"); 22 if (mysqli_field_count($link)) { 23 $result = mysqli_store_result($link); 30 mysqli_query($link, "DROP TABLE IF EXISTS test_result"); 31 mysqli_close($link); 40 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_result")) 41 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 041.phpt | 14 $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_warnings"); 18 mysqli_query($link, "DROP TABLE IF EXISTS test_warnings"); 20 var_dump(mysqli_warning_count($link)); 22 mysqli_close($link); 28 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 31 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_warnings")) 32 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 34 mysqli_close($link);
|
H A D | 042.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 $result = mysqli_query($link, "SELECT * FROM test_bind_fetch"); 47 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); 48 mysqli_close($link); 57 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch")) 58 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 043.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_update"); 18 mysqli_query($link,"CREATE TABLE test_update(a varchar(10), 21 mysqli_query($link, "INSERT INTO test_update VALUES ('foo', 2)"); 23 $stmt = mysqli_prepare($link, "UPDATE test_update SET a=?,b=? WHERE b=?"); 39 mysqli_query($link, "DROP TABLE IF EXISTS test_update"); 40 mysqli_close($link); 49 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_update")) 50 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 044.phpt | 13 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 15 $i = mysqli_get_server_version($link); 21 mysqli_close($link);
|
H A D | 045.phpt | 10 $link = my_mysqli_connect($host, $user, $passwd); 12 $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'"); 19 mysqli_close($link); 26 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 28 $stmt = mysqli_prepare($link, "SHOW VARIABLES LIKE 'port'"); 34 …if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && mysqli_get_server_version($link) < 50000)… 43 mysqli_close($link);
|
H A D | 046.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_affected"); 20 mysqli_query($link, "INSERT INTO test_affected VALUES (1),(2),(3),(4),(5)"); 22 $stmt = mysqli_prepare($link, "DELETE FROM test_affected WHERE foo=?"); 33 mysqli_query($link, "DROP TABLE IF EXISTS test_affected"); 34 mysqli_close($link); 40 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 43 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_affected")) 44 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 047.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_affected"); 20 mysqli_query($link, "INSERT INTO test_affected VALUES (1, 'Zak'),(2, 'Greant')"); 22 $stmt = mysqli_prepare($link, "SELECT * FROM test_affected"); 44 mysqli_query($link, "DROP TABLE IF EXISTS test_affected"); 45 mysqli_close($link); 51 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 54 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_affected")) 55 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 048.phpt | 46 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 49 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_fetch_null")) 50 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 52 mysqli_close($link);
|
H A D | 050.phpt | 15 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 17 $stmt = mysqli_prepare($link, "SELECT CURRENT_USER()"); 20 mysqli_close($link);
|
H A D | 051.phpt | 15 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 17 $stmt1 = mysqli_prepare($link, "SELECT CURRENT_USER()"); 20 mysqli_close($link);
|
H A D | 052.phpt | 15 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 17 $stmt2 = mysqli_prepare($link, "SELECT CURRENT_USER()"); 19 mysqli_close($link);
|
H A D | 053.phpt | 15 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 17 $result = mysqli_query($link, "SELECT CURRENT_USER()"); 18 mysqli_close($link);
|
H A D | 054.phpt | 15 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 17 $result1 = mysqli_query($link, "SELECT CURRENT_USER()"); 18 mysqli_close($link);
|
H A D | 055.phpt | 15 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 17 $result2 = mysqli_query($link, "SELECT CURRENT_USER()"); 18 $stmt2 = mysqli_prepare($link, "SELECT CURRENT_USER()");
|
H A D | 057.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_store_result"); 18 mysqli_query($link,"CREATE TABLE test_store_result (a int)"); 22 $stmt = mysqli_prepare($link, "SELECT * FROM test_store_result"); 33 $stmt = mysqli_prepare($link, "SELECT * FROM test_store_result"); 42 var_dump($stmt = @mysqli_prepare($link, "SELECT * FROM test_store_result"), mysqli_error($link)); 45 $stmt = mysqli_prepare($link, "SELECT * FROM test_store_result"); 62 mysqli_close($link); 72 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|
H A D | 058.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 mbind"); 18 mysqli_query($link,"CREATE TABLE mbind (a int, b varchar(10))"); 20 $stmt = mysqli_prepare($link, "INSERT INTO mbind VALUES (?,?)"); 37 $stmt = mysqli_prepare($link, "SELECT * FROM mbind"); 48 mysqli_close($link); 54 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 57 if (!mysqli_query($link, "DROP TABLE IF EXISTS mbind")) 58 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); [all …]
|