/PHP-5.5/ext/mysql/tests/ |
H A D | mysql_info.phpt | 19 if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (100, 'a')", $link)) 25 if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (101, 'a'), (102, 'b')", $link)) 31 if (!$res = mysql_query('INSERT INTO test(id, label) SELECT id + 200, label FROM test', $link)) 37 if (!$res = mysql_query('ALTER TABLE test MODIFY label CHAR(2)', $link)) 43 if (!$res = mysql_query("UPDATE test SET label = 'b' WHERE id >= 100", $link))
|
H A D | mysql_fetch_object.phpt | 22 if (!$res = mysql_query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5", $link)) { 66 if (!$res = mysql_query("SELECT id AS ID, label FROM test AS TEST", $link)) { 89 [%u|b%"label"]=> 99 [%u|b%"label"]=> 117 [%u|b%"label"]=> 131 [%u|b%"label"]=> 141 [%u|b%"label"]=>
|
H A D | mysql_fetch_array.phpt | 98 if (!$res = mysql_query("SELECT id, label FROM test", $link)) { 113 gettype($row['label']), $row['label'], mysql_errno($link), mysql_error($link)); 119 if (($row['label'] != $php_value) || ($row[1] != $php_value)) { 123 gettype($row['label']), $row['label'], mysql_errno($link), mysql_error($link)); 126 if (gettype($row['label']) == 'unicode') { 132 if (($row['label'] !== $php_value) || ($row[1] != $php_value)) { 136 gettype($row['label']), $row['label'], mysql_errno($link), mysql_error($link)); 293 [%u|b%"label"]=> 311 [%u|b%"label"]=> 318 [%u|b%"label"]=> [all …]
|
H A D | mysql_result.phpt | 24 if (!$res = mysql_query("SELECT id, label, id AS _id, CONCAT(label, 'a') _label, NULL as _foo FROM … 40 var_dump(mysql_result($res, 0, 'label')); 41 var_dump(mysql_result($res, 0, '_test.label')); 54 var_dump(mysql_result($res, 0, 'test.label')); 111 Warning: mysql_result(): test.label not found in MySQL result index %d in %s on line %d
|
H A D | mysql_fetch_assoc.phpt | 24 if (!$res = mysql_query("SELECT id, label FROM test ORDER BY id LIMIT 1", $link)) { 50 if (!$res = mysql_query("SELECT id, label, id AS _id, CONCAT(label, 'a') _label, NULL as _foo FROM … 71 [%u|b%"label"]=> 97 [%u|b%"label"]=>
|
/PHP-5.5/ext/mysqli/tests/ |
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_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 [%u|b%"label"]=> 322 [%u|b%"label"]=> 329 [%u|b%"label"]=> [all …]
|
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… 70 …if (($obj->ID !== "4") || ($obj->label !== "d") || ($obj->a !== 'a') || ($obj->b !== NULL) || (get… 76 …if (($obj->ID !== "5") || ($obj->label !== "e") || ($obj->a !== 'a') || ($obj->b !== 'b') || (get_… 86 if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST")) { 93 if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) 110 if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5"))
|
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_info.phpt | 20 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (100, 'a')")) 27 if (!$res = mysqli_query($link, "INSERT INTO test(id, label) VALUES (101, 'a'), (102, 'b')")) 36 if (!$res = mysqli_query($link, 'INSERT INTO test(id, label) SELECT id + 200, label FROM test')) 42 if (!$res = mysqli_query($link, 'ALTER TABLE test MODIFY label CHAR(2)')) 48 if (!$res = mysqli_query($link, "UPDATE test SET label = 'b' WHERE id >= 100"))
|
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)); 353 [%u|b%"label"]=> 364 [%u|b%"label"]=> 374 [%u|b%"label"]=> 381 [%u|b%"label"]=> 394 [%u|b%"label"]=> [all …]
|
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 [%u|b%"label"]=> 366 [%u|b%"label"]=> 376 [%u|b%"label"]=> 383 [%u|b%"label"]=> 395 [%u|b%"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 [%u|b%"label"]=> 121 [%u|b%"label"]=> 127 [%u|b%"label"]=>
|
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_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))) { 116 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 2")) 123 $label = NULL; 124 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) 176 [%u|b%"label"]=> 182 [%u|b%"label"]=>
|
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 [%u|b%"label"]=> 310 [%u|b%"label"]=> 317 [%u|b%"label"]=> [all …]
|
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")) { 41 if (($obj->ID !== "1") || ($obj->label !== "a") || (get_class($obj) != 'stdClass')) { 57 …if (($obj->ID !== "2") || ($obj->label !== "b") || ($obj->a !== NULL) || ($obj->b !== NULL) || (ge… 73 …if (($obj->ID !== "3") || ($obj->label !== "c") || ($obj->a !== NULL) || ($obj->b !== NULL) || (ge… 79 …if (($obj->ID !== "4") || ($obj->label !== "d") || ($obj->a !== 'a') || ($obj->b !== NULL) || (get… 85 …if (($obj->ID !== "5") || ($obj->label !== "e") || ($obj->a !== 'a') || ($obj->b !== 'b') || (get_… 95 if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST")) {
|
/PHP-5.5/ext/pdo_mysql/tests/ |
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_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 [%u|b%"label"]=> 120 [%u|b%"label"]=> 137 [%u|b%"label"]=> 160 [%u|b%"label"]=> 206 [%u|b%"label"]=>
|
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 [%u|b%"label"]=>
|
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_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_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"]=>
|