/php-src/ext/mysqli/tests/ |
H A D | mysqli_stmt_bind_param.phpt | 27 $label = null; 56 $param = array($id, $label, $id); 114 $label = "z"; 123 if (($row['id'] != $id) || ($row['label'] != $label)) 124 printf("[012] Expecting '%s'/%s', got '%s'/%s'!\n", $id, $label, $row['id'], $row['label']); 341 $label = null; 359 $id = $label = null; 365 $id = 100; $label = 'z'; 381 $value_list = array(array('id' => 101, 'label' => 'a'), array('id' => 102, 'label' => 'b')); 399 else if (isset($row['label']) && ($values['label'] != $row['label'])) [all …]
|
H A D | mysqli_stmt_bind_param_call_user_func.phpt | 25 $id = $label = null; 32 var_dump($label); 54 $id = $label = null; 61 var_dump($label); 89 var_dump($label); 117 var_dump($label); 144 var_dump($label); 173 var_dump($label); 202 var_dump($label); 231 var_dump($label); [all …]
|
H A D | mysqli_stmt_bind_param_references.phpt | 37 if ($row['label'] != $label) { 39 $offset, gettype($label), $label, 40 gettype($row['label']), $row['label'] 63 $label = 'v'; 74 $label = 'w'; 84 $label = 'x'; 94 $label = $id; 112 $label = 9; 113 $id = &$label; 157 $label->label = 'y'; [all …]
|
H A D | mysqli_stmt_bind_result.phpt | 14 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 1")) 21 $label = null; 30 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 1")) 39 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) 43 mysqli_stmt_bind_result($stmt, $id, $label, $foo); 53 var_dump($label); 65 …if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT, label %s, PRIMARY KEY(id)) ENGINE = %s… 75 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) { 98 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) { 290 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (1000, 'z')"))
|
H A D | mysqli_stmt_bind_result_references.phpt | 23 $id = $label = null; 31 var_dump($label); 38 $label = null; 49 var_dump($label); 57 $label = null; 71 var_dump($label); 77 $label = null; 92 $label = &$id; 125 $label = &$obj->label; 142 $label = &$obj->label; [all …]
|
H A D | mysqli_stmt_close.phpt | 23 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) 38 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) 41 $id = $label = null; 42 if (!mysqli_stmt_bind_param($stmt, "is", $id, $label)) 45 $id = 100; $label = 'z'; 60 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) 63 $id = $label = null; 64 if (!mysqli_stmt_bind_result($stmt, $id, $label))
|
H A D | mysqli_stmt_execute.phpt | 40 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) 48 $label = "z"; 49 if (!mysqli_stmt_bind_param($stmt, "is", $id, $label))
|
H A D | mysqli_stmt_execute_bind.phpt | 18 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?'); 25 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?'); 31 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?'); 40 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?'); 49 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?'); 58 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?'); 67 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?'); 76 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?'); 85 $stmt = $link->prepare('SELECT label, ? AS anon, ? AS num FROM test WHERE id=?'); 93 $stmt = $link->prepare('SELECT label FROM test WHERE id=1'); [all …]
|
H A D | mysqli_stmt_fetch.phpt | 28 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 45 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 52 $label = NULL; 53 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label)))
|
H A D | mysqli_stmt_fetch_bit.phpt | 29 …!mysqli_query($link, $sql = sprintf('CREATE TABLE test(id INT, label BIT(%d)) ENGINE="%s"', $bits,… 38 … $sql = sprintf("INSERT INTO test(id, label) VALUES (%d, b'%s')", $value, decbin($value)); 44 $id = $_label0 = $label = null; 45 … $sql = sprintf("SELECT id, label + 0 AS _label0, label FROM test WHERE id = %d", $value); 48 !mysqli_stmt_bind_result($stmt, $id, $_label0, $label)) 55 …SQL reports odd values, id = %s, _label0 = %s, label = %s.\n", $bits, $value, $bits, $id, $_label0… 57 if ($value != $label) { 58 …f("[008 - %d] Wrong values, (original) value = %s, id = %s, label + 0 AS label0 = %s, label = %s\… 59 $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_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_field_count.phpt | 40 if (!mysqli_stmt_prepare($stmt, 'SELECT id, label FROM test')) 45 if (!mysqli_stmt_prepare($stmt, 'SELECT label FROM test') || 51 $label = null; 53 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_free_result.phpt | 28 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id")) 48 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id"))
|
H A D | mysqli_stmt_get_result.phpt | 28 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 56 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 82 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 97 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) { 112 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 136 $label = NULL; 137 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) 185 ["label"]=> 191 ["label"]=> 199 ["label"]=> [all …]
|
H A D | mysqli_stmt_get_result2.phpt | 21 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 1")) 54 !mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 2") || 58 $id = $label = null; 59 if (!mysqli_stmt_bind_result($stmt, $id, $label)) 82 $id = $label = null; 83 if (!mysqli_stmt_bind_result($stmt, $id, $label)) 101 $id = $label = null; 102 if (!mysqli_stmt_bind_result($stmt, $id, $label)) 106 if (NULL !== $id || NULL !== $label) 147 ["label"]=> [all …]
|
H A D | mysqli_stmt_get_result_field_count.phpt | 16 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 | 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")) { 67 $bind_res = &$row['label']; 74 if (!mysqli_stmt_prepare($stmt2, "INSERT INTO test(id, label) VALUES (?, ?)")) { 91 … if (!$res_normal = mysqli_query($link, sprintf("SELECT id, label FROM test WHERE id = %d", 102 if ($row_normal['label'] != $bind_res) {
|
H A D | mysqli_stmt_get_result_metadata.phpt | 16 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3")) 40 …// !mysqli_stmt_prepare($stmt, "SELECT id, label, id + 1 as _id, concat(label, '_') _label FROM t… 42 …!mysqli_stmt_prepare($stmt, "SELECT id , label, id + 1 AS _id, label AS _label, null AS _null, CON… 233 ["label"]=> 240 label
|
H A D | mysqli_stmt_get_result_metadata_fetch_field.phpt | 21 …!mysqli_stmt_prepare($stmt, "SELECT id, label, id + 1 as _id, concat(label, '_') ___label FROM te… 96 string(5) "label" 98 string(5) "label"
|
H A D | mysqli_stmt_get_result_seek.phpt | 16 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id ASC LIMIT 3")) 48 if ($row[1] !== $row['label']) { 53 unset($row['label']);
|
H A D | mysqli_stmt_get_result_types.phpt | 22 …if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT, label %s, PRIMARY KEY(id)) ENGINE = %s… 32 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) { 55 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) { 78 $bind_res = &$row['label'];
|
H A D | mysqli_stmt_get_warnings.phpt | 45 …if (!mysqli_stmt_prepare($stmt, "CREATE TABLE test(id SMALLINT, label CHAR(1))") || !mysqli_stmt_e… 51 …if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (100000, 'a'), (100001, 'b')")…
|
H A D | mysqli_stmt_insert_id.phpt | 21 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 1") || 32 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (100, 'a')") || 48 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(label) VALUES ('a')") ||
|
H A D | mysqli_stmt_multires.phpt | 18 …GIN SELECT id+12, CONCAT_WS('-',label,'ahoi') FROM test ORDER BY id LIMIT 1; SELECT id + 42, CONCA…
|