/PHP-7.4/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_prepare_emulated_anonymous.phpt | 21 $db->exec(sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENGINE)); 23 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(1, '?')"); 31 $stmt = $db->prepare('SELECT id, label FROM test'); 42 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(1, '?')"); 50 $stmt = $db->prepare('SELECT id, label FROM test'); 73 ["label"]=>
|
H A D | pdo_mysql_prepare_native_mixed_style.phpt | 21 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?), (2, ?)'); 23 …$stmt = $db->prepare("SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label…
|
H A D | pdo_mysql_attr_case.phpt | 29 …if (!is_object($stmt = $db->query("SELECT id, id AS 'ID_UPPER', label FROM test ORDER BY id ASC LI… 51 …if (!is_object($stmt = $db->query("SELECT id, id AS 'ID_UPPER', label, MiXeD, MYUPPER FROM test OR… 65 …if (!is_object($stmt = $db->query("SELECT id, label, MiXeD, MYUPPER, MYUPPER AS 'lower' FROM test … 79 …if (!is_object($stmt = $db->query("SELECT id, label, MiXeD, MYUPPER, id AS 'ID' FROM test ORDER BY… 105 ["label"]=> 120 ["label"]=> 137 ["label"]=> 160 ["label"]=> 206 ["label"]=>
|
H A D | pdo_mysql_prepare_native_named_placeholder.phpt | 18 $db->exec(sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENGINE)); 25 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES (100, ':placeholder')"); 38 $stmt = $db->prepare('SELECT id, label FROM test'); 48 $stmt = $db->prepare("INSERT INTO test(id, label) VALUES(101, ':placeholder')"); 58 $stmt = $db->prepare('SELECT id, label FROM test ORDER BY id'); 88 ["label"]=>
|
H A D | table.inc | 7 $db->exec('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine); 8 $db->exec('INSERT INTO test(id, label) VALUES (1, "a"), (2, "b"), (3, "c"), (4, "d"), (5, "e"), (6,…
|
H A D | pdo_mysql_bit.phpt | 19 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE… 26 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)'); 33 $stmt = $db->query('SELECT id, label FROM test'); 60 ["label"]=>
|
H A D | pdo_mysql_errorcode.phpt | 38 $stmt = $db->query('SELECT id, label FROM test'); 50 @$stmt = $db->query('SELECT id, label FROM unknown'); 54 $stmt = $db->query('SELECT id, label FROM test'); 59 @$db->query('SELECT id, label FROM unknown');
|
H A D | pdo_mysql_stmt_blobfromsteam.phpt | 56 $sql = sprintf('CREATE TABLE test(id INT, label BLOB) ENGINE=%s', PDO_MYSQL_TEST_ENGINE); 59 if (!$stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)')) { 86 $stmt2 = $db->query('SELECT id, label FROM test WHERE id = 1'); 88 if ($row['label'] != $blob) { 98 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)'); 104 $stmt2 = $db->query('SELECT id, label FROM test WHERE id = 1'); 106 if ($row['label'] != $blob) {
|
H A D | pdo_mysql_prepare_native_clear_error.phpt | 18 $db->exec(sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENGINE)); 26 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')"); 35 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > :placeholder ORDER BY id ASC'); 55 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > :placeholder ORDER BY id ASC'); 89 ["label"]=>
|
/PHP-7.4/ext/mysqli/tests/ |
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_fetch_object.phpt | 25 … if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) { 30 if (($obj->ID !== "1") || ($obj->label !== "a") || (get_class($obj) != 'stdClass')) { 46 …if (($obj->ID !== "2") || ($obj->label !== "b") || ($obj->a !== NULL) || ($obj->b !== NULL) || (ge… 64 …if (($obj->ID !== "3") || ($obj->label !== "c") || ($obj->a !== NULL) || ($obj->b !== NULL) || (ge… 74 …if (($obj->ID !== "4") || ($obj->label !== "d") || ($obj->a !== 'a') || ($obj->b !== NULL) || (get… 83 …if (($obj->ID !== "5") || ($obj->label !== "e") || ($obj->a !== 'a') || ($obj->b !== 'b') || (get_… 93 if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST")) { 100 if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) 117 if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5"))
|
H A D | mysqli_fetch_array.phpt | 102 if (!$res = mysqli_query($link, "SELECT id, label FROM test")) { 117 … gettype($row['label']), $row['label'], mysqli_errno($link), mysqli_error($link)); 123 if (($row['label'] != $php_value) || ($row[1] != $php_value)) { 127 … gettype($row['label']), $row['label'], mysqli_errno($link), mysqli_error($link)); 130 if (gettype($row['label']) == 'unicode') { 131 var_dump(mysqli_fetch_field_direct($res, 1), $row['label']); 141 … gettype($row['label']), $row['label'], mysqli_errno($link), mysqli_error($link)); 304 ["label"]=> 322 ["label"]=> 329 ["label"]=> [all …]
|
H A D | mysqli_stmt_affected_rows.phpt | 44 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (1, 'a')") || 51 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (100, 'z')") || 61 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (100, 'z')") || 109 … if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) SELECT id + 10, label FROM test") || 119 if (!mysqli_stmt_prepare($stmt, "REPLACE INTO test(id, label) values (4, 'd')") || 129 if (!mysqli_stmt_prepare($stmt, "REPLACE INTO test(id, label) values (5, 'e')") || 139 if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'a' WHERE id = 2") || 146 if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'a' WHERE id = 2") || 156 if (!mysqli_stmt_prepare($stmt, "UPDATE test SET label = 'a' WHERE id = 100") || 163 if (!mysqli_stmt_prepare($stmt, 'SELECT label FROM test WHERE id = 100') || [all …]
|
H A D | mysqli_stmt_get_result.phpt | 39 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 64 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 87 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 102 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) { 117 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 141 $label = NULL; 142 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) 192 ["label"]=> 198 ["label"]=> 206 ["label"]=> [all …]
|
H A D | mysqli_info.phpt | 22 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, 'a')")) 29 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (101, 'a'), (102, 'b')")) 35 if (!$res = mysqli_query($link, 'INSERT INTO test(id, label) SELECT id + 200, label FROM test')) 41 if (!$res = mysqli_query($link, 'ALTER TABLE test MODIFY label CHAR(2)')) 47 if (!$res = mysqli_query($link, "UPDATE test SET label = 'b' WHERE id >= 100"))
|
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_fetch_all_oo.phpt | 108 if (!$link->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) { 126 if (!$res = $link->query("SELECT id, label FROM test")) { 145 gettype($row['label']), $row['label'], $link->errno, $link->error); 149 if (($row['label'] !== $php_value) || ($row[1] != $php_value)) { 153 gettype($row['label']), $row['label'], $link->errno, $link->error); 355 ["label"]=> 366 ["label"]=> 376 ["label"]=> 383 ["label"]=> 395 ["label"]=> [all …]
|
H A D | mysqli_fetch_array_oo.phpt | 84 if (!$mysqli->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) { 90 … if (!$mysqli->query($sql = "INSERT INTO test(id, label) VALUES (1, '" . $sql_value . "')")) { 95 … if (!$mysqli->query($sql = sprintf("INSERT INTO test(id, label) VALUES (1, '%d')", $sql_value))) { 102 if (!$res = $mysqli->query("SELECT id, label FROM test")) { 119 gettype($row['label']), $row['label'], $mysqli->errno, $mysqli->error); 123 if (($row['label'] !== $php_value) || ($row[1] != $php_value)) { 127 gettype($row['label']), $row['label'], $mysqli->errno, $mysqli->error); 292 ["label"]=> 310 ["label"]=> 317 ["label"]=> [all …]
|
H A D | bug49442.phpt | 36 …if (!mysqli_query($link, 'CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $en… 97 if (($row['id'] != $rows[$i]['id']) || ($row['label'] != $rows[$i]['label'])) { 115 ["label"]=> 121 ["label"]=> 127 ["label"]=>
|
H A D | mysqli_fetch_object_oo.phpt | 27 if (!$res = $mysqli->query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) { 50 if (($obj->ID !== "1") || ($obj->label !== "a") || (get_class($obj) != 'stdClass')) { 66 …if (($obj->ID !== "2") || ($obj->label !== "b") || ($obj->a !== NULL) || ($obj->b !== NULL) || (ge… 83 …if (($obj->ID !== "3") || ($obj->label !== "c") || ($obj->a !== NULL) || ($obj->b !== NULL) || (ge… 94 …if (($obj->ID !== "4") || ($obj->label !== "d") || ($obj->a !== 'a') || ($obj->b !== NULL) || (get… 103 …if (($obj->ID !== "5") || ($obj->label !== "e") || ($obj->a !== 'a') || ($obj->b !== 'b') || (get_… 113 if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS 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')")) { 45 if (!$res = mysqli_query($link, "INSERT INTO test(label) VALUES ('a')")) { 70 if (!mysqli_query($link, "INSERT INTO test(label) VALUES ('b')")) { 82 if (!mysqli_query($link, "INSERT INTO test(label) VALUES ('c'), ('d'), ('e')")) { 115 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (1000, 'a')")) { 121 if (!$res = mysqli_query($link, "INSERT INTO test(label) VALUES ('b'), ('c')")) {
|
H A D | mysqli_stmt_send_long_data.phpt | 33 …if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT NOT NULL AUTO_INCREMENT, label LONGBLOB… 36 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) 40 $label = null; 41 if (!mysqli_stmt_bind_param($stmt, "ib", $id, $label)) 100 if (!$res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id")) 112 if (empty($row['id']) || empty($row['label']) || ($row['id'] != 1)) 115 if ($blob != $row['label'])
|
H A D | mysqli_fetch_all.phpt | 107 … if (!mysqli_query($link, $sql = sprintf("INSERT INTO test(id, label) VALUES (1, NULL)"))) { 125 if (!$res = mysqli_query($link, "SELECT id, label FROM test")) { 145 … gettype($row['label']), $row['label'], mysqli_errno($link), mysqli_error($link)); 149 if (($row['label'] !== $php_value) || ($row[1] != $php_value)) { 153 … gettype($row['label']), $row['label'], mysqli_errno($link), mysqli_error($link)); 373 ["label"]=> 384 ["label"]=> 394 ["label"]=> 401 ["label"]=> 414 ["label"]=> [all …]
|
H A D | mysqli_fetch_fields.phpt | 32 … if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 1")) { 41 /* label column, result set charset */ 99 string(5) "label" 101 string(5) "label"
|
/PHP-7.4/ext/opcache/tests/ |
H A D | jmpz_jmp_elim.phpt | 9 if ($foo . "bar") { goto label; } 10 label:
|