/PHP-7.4/ext/mysqli/tests/ |
H A D | mysqli_warning_count.phpt | 27 if (!$res = mysqli_query($link, "SELECT id, label FROM test"))
|
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)) 56 …SQL reports odd values, id = %s, _label0 = %s, label = %s.\n", $bits, $value, $bits, $id, $_label0… 58 if ($value != $label) { 59 …f("[008 - %d] Wrong values, (original) value = %s, id = %s, label + 0 AS label0 = %s, label = %s\… 60 $bits, $value, $id, $_label0, $label);
|
H A D | mysqli_stmt_fetch_fields_win32_unicode.phpt | 16 !mysqli_stmt_prepare($stmt, "SELECT id, label FROM test") || 30 !mysqli_stmt_prepare($stmt, "SELECT id, label FROM test") ||
|
H A D | mysqli_stmt_field_count.phpt | 44 if (!mysqli_stmt_prepare($stmt, 'SELECT id, label FROM test')) 49 if (!mysqli_stmt_prepare($stmt, 'SELECT label FROM test') || 55 $label = null; 56 if (mysqli_stmt_bind_param($stmt, "s", $label)) 67 if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'z' WHERE id = 1") ||
|
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; 75 if (!mysqli_stmt_bind_result($stmt, $id, $label)) 98 $id = $label = null; 99 if (!mysqli_stmt_bind_result($stmt, $id, $label)) 117 $id = $label = null; 118 if (!mysqli_stmt_bind_result($stmt, $id, $label)) 122 if (NULL !== $id || NULL !== $label) 162 ["label"]=> [all …]
|
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")) 51 if ($row[1] !== $row['label']) { 56 unset($row['label']);
|
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 (?, ?)")) { 58 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) { 81 $bind_res = &$row['label'];
|
H A D | mysqli_stmt_get_warnings.phpt | 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")) 60 $label = 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… 31 $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, %s)", $id, $bind_value); 42 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) { 69 $rows[] = array('id' => $id, 'label' => $bind_res); 86 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) { 92 if (!mysqli_stmt_bind_param($stmt, "is", $new_id, $row['label'])) { 103 … if (!$res_normal = mysqli_query($link, sprintf("SELECT id, label FROM test WHERE id = %d", 114 if ($row_normal['label'] != $row['label']) {
|
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… 34 $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, %s)", $id, $bind_value); 45 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) { 70 $bind_res = &$row['label']; 77 if (!mysqli_stmt_prepare($stmt2, "INSERT INTO test(id, label) VALUES (?, ?)")) { 94 … if (!$res_normal = mysqli_query($link, sprintf("SELECT id, label FROM test WHERE id = %d", 105 if ($row_normal['label'] != $bind_res) {
|
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 t… 45 …!mysqli_stmt_prepare($stmt, "SELECT id , label, id + 1 AS _id, label AS _label, null AS _null, CON… 216 ["label"]=> 223 label
|
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')") || 56 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(label) VALUES ('a')") ||
|
H A D | mysqli_stmt_multires.phpt | 22 …GIN SELECT id+12, CONCAT_WS('-',label,'ahoi') FROM test ORDER BY id LIMIT 1; SELECT id + 42, CONCA…
|
H A D | mysqli_stmt_num_rows.phpt | 61 func_test_mysqli_stmt_num_rows($stmt, "INSERT INTO test(id, label) VALUES (100, 'z')", 0, 30); 66 func_test_mysqli_stmt_num_rows($stmt, "SELECT id, label FROM test", (int)$row['num'], 40);
|
H A D | mysqli_stmt_param_count.phpt | 46 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id, label) VALUES (?, ?)", 2, 30); 47 func_test_mysqli_stmt_param_count($stmt, "INSERT INTO test(id, label) VALUES (?, '?')", 1, 40);
|
H A D | mysqli_real_escape_string_big5.phpt | 35 if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY 67 var_dump(mysqli_query($link, "INSERT INTO test(id, label) VALUES (100,
|
H A D | mysqli_real_escape_string_eucjpms.phpt | 35 if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY 61 var_dump(mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, '��')"));
|
H A D | mysqli_real_escape_string_euckr.phpt | 34 if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY 60 var_dump(mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, '��')"));
|
H A D | mysqli_real_escape_string_gb2312.phpt | 35 if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY 61 var_dump(mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, '��')"));
|
H A D | mysqli_real_escape_string_nobackslash.phpt | 36 if (!mysqli_query($link, sprintf('INSERT INTO test(id, label) VALUES (100, "%s")', 40 if (!($res = mysqli_query($link, 'SELECT label FROM test WHERE id = 100')) || 62 ["label"]=>
|