/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_stmt_data_seek.phpt | 30 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 D | mysqli_stmt_errno.phpt | 31 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 D | mysqli_real_escape_string_gbk.phpt | 35 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 D | mysqli_rollback.phpt | 42 if (!mysqli_query($link, 'CREATE TABLE test(id INT) ENGINE = InnoDB')) 45 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
|
H A D | mysqli_savepoint.phpt | 46 if (!mysqli_query($link, 'CREATE TABLE test(id INT) ENGINE = InnoDB')) 56 if (!mysqli_query($link, 'INSERT INTO test(id) VALUES (1)'))
|
H A D | mysqli_select_db.phpt | 95 if (!$res = $link->query("SELECT id FROM test WHERE id = 1"))
|
H A D | mysqli_stmt_error.phpt | 31 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 D | mysqli_stmt_execute.phpt | 44 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 D | mysqli_options_init_command.phpt | 21 !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 D | mysqli_pam_sha256.phpt | 68 !$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 D | mysqli_pam_sha256_public_key_ini.phpt | 81 !$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 D | mysqli_pam_sha256_public_key_option.phpt | 78 !$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 D | mysqli_pam_sha256_public_key_option_invalid.phpt | 78 !$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 D | mysqli_pconn_conn_multiple.phpt | 24 …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 D | mysqli_prepare.phpt | 27 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 D | mysqli_query.phpt | 89 … 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 D | mysqli_insert_id.phpt | 27 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 D | mysqli_insert_id_variation.phpt | 17 $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 D | mysqli_kill.phpt | 29 … 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 D | mysqli_last_insert_id.phpt | 80 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 D | mysqli_max_links.phpt | 29 if ($res = mysqli_query($links[$i], 'SELECT id FROM test LIMIT 1')) {
|
H A D | mysqli_more_results.phpt | 27 …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 D | mysqli_multi_query.phpt | 27 …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 D | mysqli_next_result.phpt | 61 …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 D | mysqli_num_fields.phpt | 43 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);
|