Home
last modified time | relevance | path

Searched refs:id (Results 126 – 150 of 800) sorted by last modified time

12345678910>>...32

/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_num_rows.phpt45 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 Dmysqli_options_int_and_float_native.phpt49 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 Dmysqli_pconn_kill.phpt39 …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 Dmysqli_pconn_max_links.phpt84 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 Dmysqli_poll_mixing_insert_select.phpt28 '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 Dmysqli_ps_select_union.phpt50 http://bugs.mysql.com/bug.php?id=47483
H A Dmysqli_query_iterators.phpt73 ["id"]=>
77 ["id"]=>
81 ["id"]=>
85 ["id"]=>
89 ["id"]=>
93 ["id"]=>
98 ["id"]=>
102 ["id"]=>
106 ["id"]=>
110 ["id"]=>
[all …]
H A Dmysqli_query_stored_proc.phpt23 …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 Dmysqli_query_unicode.phpt90 if (false !== ($tmp = mysqli_query($link, "SELECT id FROM test")))
H A Dmysqli_get_warnings.phpt39 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 Dmysqli_info.phpt22 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 Dmysqli_fetch_assoc_no_alias_utf8.phpt52 …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 Dmysqli_fetch_assoc_oo.phpt30 if (!$res = $mysqli->query("SELECT id, label FROM test ORDER BY id LIMIT 1")) {
64 ["id"]=>
H A Dmysqli_fetch_field.phpt32 … 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 Dmysqli_fetch_field_types.phpt20 … $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 Dmysqli_fetch_object_oo.phpt27 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 Dmysqli_fetch_assoc_bit.phpt48 …!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 Dmysqli_free_result.phpt23 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 Dmysqli_get_charset.phpt60 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 Dmysqli_get_client_stats.phpt367 $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 Dmysqli_fetch_field_direct.phpt27 … 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 Dmysqli_fetch_field_direct_oo.phpt27 if (!$res = $mysqli->query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1")) {
63 string(2) "id"
H A Dmysqli_fetch_field_flags.phpt115 $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 Dmysqli_fetch_all.phpt25 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 Dmysqli_fetch_field_oo.phpt37 if (!$res = $mysqli->query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1")) {
77 string(2) "id"

Completed in 77 milliseconds

12345678910>>...32