Home
last modified time | relevance | path

Searched refs:label (Results 51 – 75 of 206) sorted by relevance

123456789

/PHP-5.5/ext/mysql/tests/
H A Dmysql_info.phpt19 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 Dmysql_fetch_object.phpt22 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 Dmysql_fetch_array.phpt98 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 Dmysql_result.phpt24 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 Dmysql_fetch_assoc.phpt24 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 Dmysqli_stmt_affected_rows.phpt44 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 Dmysqli_fetch_array.phpt102 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 Dmysqli_fetch_object.phpt25 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 Dmysqli_stmt_get_result_geom.phpt28 …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 Dmysqli_info.phpt20 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 Dmysqli_fetch_all.phpt107 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 Dmysqli_fetch_all_oo.phpt108 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 Dbug49442.phpt36 …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 Dmysqli_insert_id.phpt27 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 Dmysqli_stmt_send_long_data.phpt33 …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 Dmysqli_stmt_get_result.phpt39 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 Dmysqli_fetch_array_oo.phpt84 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 Dmysqli_fetch_object_oo.phpt27 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 Dpdo_mysql_prepare_native_named_placeholder.phpt18 $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 Dtable.inc7 $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 Dpdo_mysql_attr_case.phpt29 …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 Dpdo_mysql_bit.phpt19 …$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 Dpdo_mysql_stmt_blobfromsteam.phpt56 $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 Dpdo_mysql_errorcode.phpt38 $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 Dpdo_mysql_prepare_native_clear_error.phpt18 $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"]=>

Completed in 36 milliseconds

123456789