Home
last modified time | relevance | path

Searched refs:id (Results 101 – 125 of 800) sorted by last modified time

12345678910>>...32

/PHP-7.4/ext/mysqli/tests/
H A Dmysqli_stmt_data_seek.phpt30 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
37 $id = null;
38 if (!mysqli_stmt_bind_result($stmt, $id))
50 var_dump($id);
58 var_dump($id);
66 var_dump($id);
74 var_dump($id);
H A Dmysqli_stmt_errno.phpt31 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
38 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
H A Dmysqli_real_escape_string_gbk.phpt35 if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(3), PRIMARY
36 KEY(id)) ENGINE=' . $engine . " DEFAULT CHARSET=gbk")) {
61 var_dump(mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, '��')"));
H A Dmysqli_rollback.phpt42 if (!mysqli_query($link, 'CREATE TABLE test(id INT) ENGINE = InnoDB'))
45 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
H A Dmysqli_savepoint.phpt46 if (!mysqli_query($link, 'CREATE TABLE test(id INT) ENGINE = InnoDB'))
56 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
H A Dmysqli_select_db.phpt95 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
H A Dmysqli_stmt_error.phpt31 if (mysqli_stmt_prepare($stmt, "SELECT i_do_not_exist_believe_me FROM test ORDER BY id"))
38 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id"))
H A Dmysqli_stmt_execute.phpt44 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1"))
58 $id = 100;
60 if (!mysqli_stmt_bind_param($stmt, "is", $id, $label))
71 if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT ?"))
82 $id = null;
86 if ($id !== 1)
87 printf("[018] Expecting int/1 got %s/%s\n", gettype($id), $id);
97 $id = null;
101 if ($id !== 1)
102 printf("[022] Expecting int/1 got %s/%s\n", gettype($id), $id);
[all …]
H A Dmysqli_options_init_command.phpt21 !mysqli_query($link, sprintf("CREATE TABLE test(id INT) ENGINE = %s\n", $engine)) ||
22 !mysqli_query($link, "INSERT INTO test(id) VALUES (1)"))
25 if (!$res = mysqli_query($link, "SELECT COUNT(id) AS _num_rows FROM test"))
37 if (true !== mysqli_options($link, MYSQLI_INIT_COMMAND, "INSERT INTO test(id) VALUES (2)"))
44 if (!$res = mysqli_query($link, "SELECT COUNT(id) AS _num_rows FROM test"))
H A Dmysqli_pam_sha256.phpt68 !$link->query("CREATE TABLE test (id INT)") ||
69 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
89 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
96 if ($row['id'] != 1) {
97 printf("[004] Expecting 1 got %s/'%s'", gettype($row['id']), $row['id']);
H A Dmysqli_pam_sha256_public_key_ini.phpt81 !$link->query("CREATE TABLE test (id INT)") ||
82 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
104 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
111 if ($row['id'] != 1) {
112 printf("[004] Expecting 1 got %s/'%s'", gettype($row['id']), $row['id']);
H A Dmysqli_pam_sha256_public_key_option.phpt78 !$link->query("CREATE TABLE test (id INT)") ||
79 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
106 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
113 if ($row['id'] != 1) {
114 printf("[005] Expecting 1 got %s/'%s'", gettype($row['id']), $row['id']);
H A Dmysqli_pam_sha256_public_key_option_invalid.phpt78 !$link->query("CREATE TABLE test (id INT)") ||
79 !$link->query("INSERT INTO test(id) VALUES (1), (2), (3)"))
107 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
116 if ($row['id'] != 1) {
117 … printf("[%03d + 005] Expecting 1 got %s/'%s'", $offset, gettype($row['id']), $row['id']);
H A Dmysqli_pconn_conn_multiple.phpt24 …printf("[002] Cannot determine thread id, test will fail, [%d] %s\n", mysqli_errno($link), mysqli_…
33 …printf("[005] Expecting new connection and new thread id. Old thread id %d, new thread id %d\n", $…
49 …printf("[008] Cannot determine thread id, test will fail, [%d] %s\n", mysqli_errno($link), mysqli_…
58 …printf("[011] Expecting new connection and new thread id. Old thread id %d, new thread id %d\n", $…
86 …printf("[017] Cannot determine thread id, test will fail, [%d] %s\n", mysqli_errno($link), mysqli_…
95 …printf("[020] Expecting new connection and new thread id. Old thread id %d, new thread id %d\n", $…
111 …printf("[023] Cannot determine thread id, test will fail, [%d] %s\n", mysqli_errno($link), mysqli_…
120 …printf("[026] Expecting new connection and new thread id. Old thread id %d, new thread id %d\n", $…
H A Dmysqli_prepare.phpt27 if (!$res = mysqli_query($link, "SELECT id, label FROM test", MYSQLI_USE_RESULT))
30 if (false !== ($tmp = mysqli_prepare($link, 'SELECT id FROM test WHERE id > ?')))
51 $id = 1;
52 if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt))
59 $id = 2;
60 if (!mysqli_stmt_bind_param($stmt, 'i', $id) || !mysqli_stmt_execute($stmt))
64 if (!is_object(($stmt = mysqli_prepare($link, 'UPDATE test2 SET id = ? WHERE id = ?'))))
67 $id = 3;
96 $id = $testvar = null;
100 if (('testvar' !== $testvar) || (1 !== $id))
[all …]
H A Dmysqli_query.phpt89 … if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id", MYSQLI_USE_RESULT)))
93 …if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id", MYSQLI_STORE_RESULT)))
97 if (false !== ($res = @mysqli_query($link, "SELECT id FROM test ORDER BY id", 1234)))
105 if (false !== ($tmp = mysqli_query($link, "SELECT id FROM test")))
H A Dmysqli_insert_id.phpt27 if (!$res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id LIMIT 1")) {
35 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, 'a')")) {
41 if (!$res = mysqli_query($link, "ALTER TABLE test MODIFY id INT NOT NULL AUTO_INCREMENT")) {
115 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (1000, 'a')")) {
H A Dmysqli_insert_id_variation.phpt17 $link->query("CREATE TABLE test_insert_id_var (id INT auto_increment, PRIMARY KEY (id))");
22 printf("[001] Got no valid insert id: %s", var_export($i, true));
H A Dmysqli_kill.phpt29 … printf("[004] Cannot determine thread id, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
35 if ($res = mysqli_query($link, "SELECT id FROM test LIMIT 1"))
59 if ((!$res = mysqli_query($link, "SELECT id FROM test LIMIT 1")) ||
135 ["id"]=>
H A Dmysqli_last_insert_id.phpt80 if (!$link->query("UPDATE test SET id=LAST_INSERT_ID(id+1)"))
129 printf("id = %d, label = '%s'\n", $row['id'], $row['label']);
141 …if ($link->query("INSERT INTO test(id, label) SELECT id, CONCAT(label, id) FROM test ORDER BY id A…
171 printf("id = %d, label = '%s'\n", $row['id'], $row['label']);
184 id = %d, label = 'b'
185 id = %d, label = 'a'
186 id = %d, label = 'c'
188 id = %d, label = 'b'
189 id = %d, label = 'a'
190 id = %d, label = 'c'
[all …]
H A Dmysqli_max_links.phpt29 if ($res = mysqli_query($links[$i], 'SELECT id FROM test LIMIT 1')) {
H A Dmysqli_more_results.phpt27 …ulti_query($link, "SELECT 1 AS a; SELECT 1 AS a, 2 AS b; SELECT id FROM test ORDER BY id LIMIT 3"))
41 …ulti_query($link, "SELECT 1 AS a; SELECT 1 AS a, 2 AS b; SELECT id FROM test ORDER BY id LIMIT 3"))
H A Dmysqli_multi_query.phpt27 …ulti_query($link, "SELECT 1 AS a; SELECT 1 AS a, 2 AS b; SELECT id FROM test ORDER BY id LIMIT 3"))
41 …, "ALTER TABLE test MODIFY id INT AUTO_INCREMENT; INSERT INTO test(label) VALUES ('a'); SELECT id,…
55 if (!mysqli_multi_query($link, "SELECT id, label FROM test"))
114 var_dump(mysqli_multi_query($link, "SELECT id, label FROM test"));
H A Dmysqli_next_result.phpt61 …ext_result($link, "SELECT 1 AS a; SELECT 1 AS a, 2 AS b; SELECT id FROM test ORDER BY id LIMIT 3",…
62 …func_test_mysqli_next_result($link, "SELECT 1 AS a; INSERT INTO test(id, label) VALUES (100, 'y');…
63 func_test_mysqli_next_result($link, "DELETE FROM test WHERE id >= 100; SELECT 1 AS a; ", 11, 1);
H A Dmysqli_num_fields.phpt43 func_test_mysqli_num_fields($link, "SELECT id, label FROM test", 2, 10);
45 func_test_mysqli_num_fields($link, "SELECT id FROM test", 1, 20, true);

Completed in 41 milliseconds

12345678910>>...32