Home
last modified time | relevance | path

Searched refs:id (Results 51 – 75 of 800) sorted by last modified time

12345678910>>...32

/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_store_result.phpt24 if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id"))
44 if (!$res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id"))
H A Dmysqli_store_result_copy.phpt44 printf("id = %d, label = %s\n", $row['id'], $row['label']);
79 …if (!$res = mysqli_query($link, "SELECT CONCAT(id, id) AS _c, label FROM test ORDER BY id DESC LIM…
90 …if (!$res = mysqli_real_query($link, "SELECT CONCAT(id, id) AS _c, label FROM test ORDER BY id DES…
166 …SQL DATA BEGIN SELECT id FROM test WHERE id >= 100 ORDER BY id; SELECT id + 1, label FROM test WHE…
203 ["id"]=>
208 id = 1, label = a
209 id = 2, label = b
245 id = 6 label = f
246 id = 5 label = e
248 ["id"]=>
[all …]
H A Dmysqli_thread_id.phpt28 // should work if the thread id is correct
H A Dmysqli_use_result.phpt24 if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id"))
44 if (!$res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id"))
H A Dmysqli_warning_count.phpt27 if (!$res = mysqli_query($link, "SELECT id, label FROM test"))
H A Dmysqli_warning_unclonable.phpt23 if (!mysqli_query($link, "CREATE TABLE test (id SMALLINT)"))
26 if (!mysqli_query($link, "INSERT INTO test (id) VALUES (1000000)"))
H A Dtable.inc20 if (!mysqli_query($link, 'CREATE TABLE test(id INT DEFAULT 0, label CHAR(1), PRIMARY KEY(id)) ENGIN…
25 if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd')…
H A Dmysqli_stmt_fetch_bit.phpt30 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id INT, label BIT(%d)) ENGINE="%s"', $bits,…
39 … $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, b'%s')", $value, decbin($value));
45 $id = $_label0 = $label = null;
46 … $sql = sprintf("SELECT id, label + 0 AS _label0, label FROM test WHERE id = %d", $value);
49 !mysqli_stmt_bind_result($stmt, $id, $_label0, $label))
55 if (($id !== $_label0) || ($value !== $_label0)) {
56 …ight have failed. MySQL reports odd values, id = %s, _label0 = %s, label = %s.\n", $bits, $value, …
59 …printf("[008 - %d] Wrong values, (original) value = %s, id = %s, label + 0 AS label0 = %s, label …
60 $bits, $value, $id, $_label0, $label);
H A Dmysqli_stmt_fetch_fields_win32_unicode.phpt14 $bind_res = $id = null;
16 !mysqli_stmt_prepare($stmt, "SELECT id, label FROM test") ||
19 !mysqli_stmt_bind_result($stmt, $id, $bind_res) ||
30 !mysqli_stmt_prepare($stmt, "SELECT id, label FROM test") ||
33 !mysqli_stmt_bind_result($stmt, $id, $bind_res)) {
H A Dmysqli_stmt_field_count.phpt44 if (!mysqli_stmt_prepare($stmt, 'SELECT id, label FROM test'))
62 if (!mysqli_stmt_prepare($stmt, 'INSERT INTO test(id) VALUES (100)'))
67 if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'z' WHERE id = 1") ||
76 if (mysqli_stmt_prepare($stmt, 'SELECT id FROM test'))
H A Dmysqli_stmt_get_result2.phpt37 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 1"))
70 !mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2") ||
74 $id = $label = null;
89 !mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2") ||
98 $id = $label = null;
108 !mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2") ||
117 $id = $label = null;
122 if (NULL !== $id || NULL !== $label)
129 !mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2") ||
160 ["id"]=>
[all …]
H A Dmysqli_stmt_get_result_bit.phpt51 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id BIGINT UNSIGNED, bit_value BIT(%d) NOT N…
79 $sql = sprintf("INSERT INTO test(id, bit_value) VALUES (%s, b'%s')", $value, $bin);
88 …$sql = sprintf("SELECT bin(bit_value) AS _bin, id, bit_value, bit_null FROM test WHERE id = %s", $…
100 if (($value != $row['id']) || (($bin != $row['_bin']) && ($bin2 != $row['_bin']))) {
102 … printf("[008 - %d] Insert of %s in BIT(%d) column might have failed. id = %s, bin = %s (%s/%s)\n",
103 $bits, $value, $bits, $row['id'], $row['_bin'], $bin, $bin2);
H A Dmysqli_stmt_get_result_non_select.phpt51 if (mysqli_query($link, 'PREPARE mystmt FROM "DESCRIBE test id"')) {
54 if (!$stmt->prepare('DESCRIBE test id') ||
62 if ($description['Field'] != 'id') {
70 if (mysqli_query($link, 'PREPARE mystmt FROM "EXPLAIN SELECT id FROM test"')) {
73 if (!$stmt->prepare('EXPLAIN SELECT id FROM test') ||
H A Dmysqli_stmt_get_result_seek.phpt19 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3"))
44 if (($row[0] !== $row['id']) || ($row[0] !== $i + 1)) {
49 unset($row['id']);
82 printf("[016] Expecting id = %d for pos %d got %s/%s\n",
H A Dmysqli_stmt_get_result_types.phpt25 …if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT, label %s, PRIMARY KEY(id)) ENGINE = %s…
35 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) {
40 $id = null;
41 if (!mysqli_stmt_bind_param($stmt, "i" . $bind_type, $id, $bind_value)) {
47 for ($id = 1; $id < 4; $id++) {
49 … printf("[%04d] [%d] %s\n", $offset + 3 + $id, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
58 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) {
240 /* Is this one related? http://bugs.php.net/bug.php?id=35759 */
H A Dmysqli_stmt_get_warnings.phpt17 !mysqli_query($link, "CREATE TABLE test(id SMALLINT)"))
20 if (!@mysqli_query($link, "SET sql_mode=''") || !@mysqli_query($link, "INSERT INTO test(id) VALUES …
55 …if (!mysqli_stmt_prepare($stmt, "CREATE TABLE test(id SMALLINT, label CHAR(1))") || !mysqli_stmt_e…
61 …if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (100000, 'a'), (100001, 'b')")…
H A Dmysqli_store_result_buffered_c.phpt21 if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id"))
H A Dmysqli_stmt_fetch.phpt36 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
53 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2"))
59 $id = NULL;
61 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label)))
H A Dmysqli_stmt_fetch_geom.phpt25 …if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT, label %s, PRIMARY KEY(id)) ENGINE = %s…
30 for ($id = 1; $id < 4; $id++) {
31 $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, %s)", $id, $bind_value);
33 … printf("[%04d] [%d] %s\n", $offset + 2 + $id, mysqli_errno($link), mysqli_error($link));
42 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) {
54 if (!mysqli_stmt_bind_result($stmt, $id, $bind_res)) {
69 $rows[] = array('id' => $id, 'label' => $bind_res);
86 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) {
91 $new_id = $row['id'] + 10;
103 … if (!$res_normal = mysqli_query($link, sprintf("SELECT id, label FROM test WHERE id = %d",
H A Dmysqli_stmt_free_result.phpt36 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id"))
56 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id"))
H A Dmysqli_stmt_get_result_field_count.phpt19 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3"))
H A Dmysqli_stmt_get_result_geom.phpt28 …if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT, label %s, PRIMARY KEY(id)) ENGINE = %s…
33 for ($id = 1; $id < 4; $id++) {
34 $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, %s)", $id, $bind_value);
36 … printf("[%04d] [%d] %s\n", $offset + 2 + $id, mysqli_errno($link), mysqli_error($link));
45 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) {
77 if (!mysqli_stmt_prepare($stmt2, "INSERT INTO test(id, label) VALUES (?, ?)")) {
82 $id = $row['id'] + 10;
83 if (!mysqli_stmt_bind_param($stmt2, "is", $id, $bind_res)) {
94 … if (!$res_normal = mysqli_query($link, sprintf("SELECT id, label FROM test WHERE id = %d",
95 $row['id'] + 10))) {
H A Dmysqli_stmt_get_result_metadata.phpt19 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3"))
43 …mysqli_stmt_prepare($stmt, "SELECT id, label, id + 1 as _id, concat(label, '_') _label FROM test …
45 …($stmt, "SELECT id , label, id + 1 AS _id, label AS _label, null AS _null, CONCAT(label, '_') _lab…
214 ["id"]=>
222 id
H A Dmysqli_stmt_insert_id.phpt29 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 1") ||
40 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (100, 'a')") ||
49 (!mysqli_stmt_prepare($stmt, "ALTER TABLE test MODIFY id INT NOT NULL AUTO_INCREMENT") ||
53 mysqli_query($link, "ALTER TABLE test MODIFY id INT NOT NULL AUTO_INCREMENT");
H A Dmysqli_stmt_multires.phpt22 …IN SELECT id+12, CONCAT_WS('-',label,'ahoi') FROM test ORDER BY id LIMIT 1; SELECT id + 42, CONCAT…

Completed in 48 milliseconds

12345678910>>...32