/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_num_rows.phpt | 45 func_test_mysqli_num_rows($link, "INSERT INTO test(id, label) VALUES (100, 'z')", NULL, 15); 46 func_test_mysqli_num_rows($link, "SELECT id FROM test LIMIT 2", 2, 20, true); 48 if ($res = mysqli_query($link, 'SELECT COUNT(id) AS num FROM test')) { 53 func_test_mysqli_num_rows($link, "SELECT id, label FROM test", (int)$row['num'], 25); 61 if ($res = mysqli_query($link, 'SELECT id FROM test', MYSQLI_USE_RESULT)) {
|
H A D | mysqli_options_int_and_float_native.phpt | 49 if (!mysqli_query($link, sprintf("CREATE TABLE test (id %s)", $data[0]))) { 54 if (!mysqli_query($link, sprintf("INSERT INTO test(id) VALUES (%f)", $data[1]))) { 59 if (!$res = mysqli_query($link, "SELECT id FROM test")) { 67 if ($row['id'] !== $data[1]) { 70 $data[1], gettype($data[1]), $row['id'], gettype($row['id'])); 85 if (!$res = mysqli_query($link, "SELECT id FROM test")) { 93 if (!is_string($row['id']) || ($row['id'] != $data[1])) { 96 $data[1], $row['id'], gettype($row['id']));
|
H A D | mysqli_pconn_kill.phpt | 39 …printf("[004] Cannot find thread id of the regular link, [%d] %s\n", mysqli_errno($link), mysqli_e… 42 …printf("[005] Cannot find thread id of the persistent link, [%d] %s\n", mysqli_errno($link), mysql… 70 if (!$res3 = @mysqli_query($plink, 'SELECT id FROM test ORDER BY id LIMIT 1')) { 83 if (!$res4 = mysqli_query($link, 'SELECT id FROM test ORDER BY id LIMIT 1'))
|
H A D | mysqli_pconn_max_links.phpt | 84 if (!$res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1')) 157 if (!$res = mysqli_query($plink, 'SELECT id, label FROM test WHERE id = 1')) 226 ["id"]=> 256 ["id"]=>
|
H A D | mysqli_poll_mixing_insert_select.phpt | 28 'CREATE TABLE IF NOT EXISTS bogus(id INT)', 30 'SELECT * FROM test ORDER BY id ASC LIMIT 2', 31 "INSERT INTO test(id, label) VALUES (100, 'z')", 32 'SELECT * FROM test ORDER BY id ASC LIMIT 2', 34 'UPDATE test SET id = 101 WHERE id > 3', 35 'UPDATE_FIX test SET id = 101 WHERE id > 3', 37 'DELETE FROM test WHERE id = @a', 38 'DELETE FROM test WHERE id = 1', 180 [003] 'UPDATE test SET id = 101 WHERE id > 3' caused 1062 181 [003] 'UPDATE_FIX test SET id = 101 WHERE id > 3' caused 1064 [all …]
|
H A D | mysqli_ps_select_union.phpt | 50 http://bugs.mysql.com/bug.php?id=47483
|
H A D | mysqli_query_iterators.phpt | 73 ["id"]=> 77 ["id"]=> 81 ["id"]=> 85 ["id"]=> 89 ["id"]=> 93 ["id"]=> 98 ["id"]=> 102 ["id"]=> 106 ["id"]=> 110 ["id"]=> [all …]
|
H A D | mysqli_query_stored_proc.phpt | 23 …query($link, 'CREATE PROCEDURE p() READS SQL DATA BEGIN SELECT id, label FROM test ORDER BY id ASC; 74 …PROCEDURE p() READS SQL DATA BEGIN SELECT id, label FROM test ORDER BY id ASC; SELECT id FROM test… 168 ["id"]=> 174 ["id"]=> 180 ["id"]=> 186 ["id"]=> 192 ["id"]=>
|
H A D | mysqli_query_unicode.phpt | 90 if (false !== ($tmp = mysqli_query($link, "SELECT id FROM test")))
|
H A D | mysqli_get_warnings.phpt | 39 if (!mysqli_query($link, "CREATE TABLE test (id SMALLINT)")) 42 if (!mysqli_query($link, "INSERT INTO test (id) VALUES (1000000)")) 68 if (!mysqli_query($link, "INSERT INTO test (id) VALUES (1000000), (1000001)"))
|
H A D | mysqli_info.phpt | 22 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, 'a')")) 29 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (101, 'a'), (102, 'b')")) 35 if (!$res = mysqli_query($link, 'INSERT INTO test(id, label) SELECT id + 200, label FROM test')) 47 if (!$res = mysqli_query($link, "UPDATE test SET label = 'b' WHERE id >= 100"))
|
H A D | mysqli_fetch_assoc_no_alias_utf8.phpt | 52 …if (!$res = mysqli_query($link, "CREATE TABLE автори_на_mysqlnd (id integer not null auto_incremen… 65 …if (!$res = mysqli_query($link, "SELECT id, име, фамилия FROM автори_на_mysqlnd ORDER BY фамилия, … 93 ["id"]=> 101 ["id"]=> 109 ["id"]=> 117 ["id"]=> 125 ["id"]=> 133 ["id"]=> 141 ["id"]=> 149 ["id"]=> [all …]
|
H A D | mysqli_fetch_assoc_oo.phpt | 30 if (!$res = $mysqli->query("SELECT id, label FROM test ORDER BY id LIMIT 1")) { 64 ["id"]=>
|
H A D | mysqli_fetch_field.phpt | 32 … if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1")) { 60 // Read http://bugs.php.net/bug.php?id=42344 on defaults! 67 if (!mysqli_query($link, "CREATE TABLE test(id INT NOT NULL DEFAULT 1)")) 70 if (!mysqli_query($link, "INSERT INTO test(id) VALUES (2)")) 73 if (!$res = mysqli_query($link, "SELECT id as _default_test FROM test")) { 94 string(2) "id" 157 string(2) "id"
|
H A D | mysqli_fetch_field_types.phpt | 20 … $create = sprintf("CREATE TABLE test(id %s) DEFAULT CHARSET %s", $sql_type, $default_charset); 28 $sql = sprintf("INSERT INTO test(id) VALUES ('%s')", $php_value); 30 $sql = sprintf("INSERT INTO test(id) VALUES (%s)", $php_value); 38 if (!$res = mysqli_query($link, 'SELECT id FROM test')) {
|
H A D | mysqli_fetch_object_oo.phpt | 27 if (!$res = $mysqli->query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) { 113 if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST")) {
|
H A D | mysqli_fetch_assoc_bit.phpt | 48 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id BIGINT, bit_value BIT(%d) NOT NULL, bit_… 73 $sql = sprintf("INSERT INTO test(id, bit_value) VALUES (%s, b'%s')", $value, $bin); 81 …$sql = sprintf("SELECT id, BIN(bit_value) AS _bin, bit_value + 0 AS _bit_value0, bit_value, bit_nu… 88 if (($value != $row['id']) || (($bin != $row['_bin']) && ($bin2 != $row['_bin']))) { 90 … printf("[006 - %d] Insert of %s in BIT(%d) column might have failed. id = %s, bin = %s (%s/%s)\n", 91 $bits, $value, $bits, $row['id'], $row['_bin'], $bin, $bin2);
|
H A D | mysqli_free_result.phpt | 23 if (!$res = mysqli_query($link, "SELECT id FROM test ORDER BY id LIMIT 1")) { 32 if (!$res = mysqli_query($link, "SELECT id FROM test ORDER BY id LIMIT 1")) { 41 if (!$res = mysqli_query($link, "SELECT id FROM test ORDER BY id LIMIT 1")) {
|
H A D | mysqli_get_charset.phpt | 60 if (!($id = $tmp['Id'])) 95 ($charset->number !== (int)$id)) 96 … printf("[021] Expecting int/%d, got %s/%s\n", $id, gettype($charset->number), $charset->number);
|
H A D | mysqli_get_client_stats.phpt | 367 $id = $label = null; 368 if (!mysqli_stmt_bind_result($stmt, $id, $label)) 408 $id = $label = null; 409 if (!mysqli_stmt_bind_result($stmt, $id, $label)) 456 $id = $label = null; 457 if (!mysqli_stmt_bind_result($stmt, $id, $label)) 493 $id = $label = null; 494 if (!mysqli_stmt_bind_result($stmt, $id, $label)) 802 if (!$res = mysqli_query($link, "SELECT id, label FROM test WHERE id = 100")) 865 if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id")) [all …]
|
H A D | mysqli_fetch_field_direct.phpt | 27 … if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1")) { 54 string(2) "id"
|
H A D | mysqli_fetch_field_direct_oo.phpt | 27 if (!$res = $mysqli->query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1")) { 63 string(2) "id"
|
H A D | mysqli_fetch_field_flags.phpt | 115 $create = sprintf('CREATE TABLE test(id INT, col1 %s)', $column_def); 191 $create = 'CREATE TABLE test(id INT, '; 202 // id column - skip it
|
H A D | mysqli_fetch_all.phpt | 25 if (!$res = mysqli_query($link, "SELECT * FROM test ORDER BY id LIMIT 2")) { 33 if (!$res = mysqli_query($link, "SELECT * FROM test ORDER BY id LIMIT 2")) { 41 if (!$res = mysqli_query($link, "SELECT * FROM test ORDER BY id LIMIT 2")) { 101 …(!mysqli_query($link, $sql = sprintf("CREATE TABLE test(id INT NOT NULL, label %s, PRIMARY KEY(id)… 125 if (!$res = mysqli_query($link, "SELECT id, label FROM test")) { 369 ["id"]=> 380 ["id"]=> 392 ["id"]=> 399 ["id"]=> 412 ["id"]=> [all …]
|
H A D | mysqli_fetch_field_oo.phpt | 37 if (!$res = $mysqli->query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1")) { 77 string(2) "id"
|