/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_store_result.phpt | 24 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 D | mysqli_store_result_copy.phpt | 44 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 D | mysqli_thread_id.phpt | 28 // should work if the thread id is correct
|
H A D | mysqli_use_result.phpt | 24 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 D | mysqli_warning_count.phpt | 27 if (!$res = mysqli_query($link, "SELECT id, label FROM test"))
|
H A D | mysqli_warning_unclonable.phpt | 23 if (!mysqli_query($link, "CREATE TABLE test (id SMALLINT)")) 26 if (!mysqli_query($link, "INSERT INTO test (id) VALUES (1000000)"))
|
H A D | table.inc | 20 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 D | mysqli_stmt_fetch_bit.phpt | 30 …!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 D | mysqli_stmt_fetch_fields_win32_unicode.phpt | 14 $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 D | mysqli_stmt_field_count.phpt | 44 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 D | mysqli_stmt_get_result2.phpt | 37 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 D | mysqli_stmt_get_result_bit.phpt | 51 …!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 D | mysqli_stmt_get_result_non_select.phpt | 51 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 D | mysqli_stmt_get_result_seek.phpt | 19 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 D | mysqli_stmt_get_result_types.phpt | 25 …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 D | mysqli_stmt_get_warnings.phpt | 17 !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 D | mysqli_store_result_buffered_c.phpt | 21 if (!$res = mysqli_real_query($link, "SELECT id, label FROM test ORDER BY id"))
|
H A D | mysqli_stmt_fetch.phpt | 36 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 D | mysqli_stmt_fetch_geom.phpt | 25 …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 D | mysqli_stmt_free_result.phpt | 36 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 D | mysqli_stmt_get_result_field_count.phpt | 19 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3"))
|
H A D | mysqli_stmt_get_result_geom.phpt | 28 …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 D | mysqli_stmt_get_result_metadata.phpt | 19 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 D | mysqli_stmt_insert_id.phpt | 29 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 D | mysqli_stmt_multires.phpt | 22 …IN SELECT id+12, CONCAT_WS('-',label,'ahoi') FROM test ORDER BY id LIMIT 1; SELECT id + 42, CONCAT…
|