Home
last modified time | relevance | path

Searched refs:label (Results 151 – 175 of 188) sorted by path

12345678

/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_prepare_native.phpt229 prepex(43, $db, 'SELECT id, label FROM test WHERE label > ?',
241 "label" => "row"
245 "label" => "row"
297 $stmt = prepex(59, $db, 'SELECT id, label AS "label" FROM test WHERE label = ?',
326 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
348 ["label"]=>
355 ["label"]=>
360 ["label"]=>
369 ["label"]=>
376 ["label"]=>
[all …]
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"]=>
H A Dpdo_mysql_prepare_native_mixed_style.phpt21 $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 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 Dpdo_mysql_prepare_native_placeholder_everywhere.phpt20 $db->exec(sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENGINE));
21 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')");
23 $stmt = $db->prepare('SELECT ?, id, label FROM test WHERE ? = ? ORDER BY id ASC');
24 $stmt->execute(array('id', 'label', 'label'));
37 $stmt = $db->prepare('SELECT ?, id, label FROM test WHERE ? = ? ORDER BY id ASC');
38 $stmt->execute(array('id', 'label', 'label'));
74 ["label"]=>
86 ["label"]=>
H A Dpdo_mysql_rollback.phpt23 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
36 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
H A Dpdo_mysql_stmt_bindcolumn.phpt23 $id = $label = null;
37 var_export($label, true), gettype($label));
38 $data[] = array('id' => $id, 'label' => $label);
49 if ($row['label'] != $data[$index]['label']) {
51 var_export($data[$index]['label'], true), gettype($data[$index]['label']),
52 var_export($row['label'], true), gettype($row['label']));
63 $id = $label = null;
77 var_export($label, true), gettype($label));
78 $data[] = array('id' => $id, 'label' => $label);
89 if ($row['label'] != $data[$index]['label']) {
[all …]
H A Dpdo_mysql_stmt_bindparam.phpt26 $id = $label = null;
32 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
40 var_export($label, true), gettype($label));
48 var_export($label, true), gettype($label));
53 $label = null;
54 if (!$stmt->bindParam(1, $label))
66 $id = $label = 'bogus';
79 var_export($label, true), gettype($label));
127 in = 0 -> id = 1 (integer) / label = 'a' (string)
128 in = 0 -> id = 2 (integer) / label = 'b' (string)
[all …]
H A Dpdo_mysql_stmt_bindparam_types.phpt24 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE…
29 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (1, ?)');
41 $stmt = $db->query('SELECT id, label FROM test');
42 $id = $label = null;
48 if (!$stmt->bindColumn(2, $label)) {
61 if ($label != $value) {
64 var_export($label, true), var_export($value, true));
76 if ($row['label'] != $value) {
79 var_export($row['label'], true), var_export($value, true));
83 if ($row['label'] != $label) {
[all …]
H A Dpdo_mysql_stmt_bindvalue.phpt30 $id = $label = null;
44 var_export($label, true), gettype($label));
66 var_export($label, true), gettype($label));
90 var_export($label, true), gettype($label));
119 var_export($label, true), gettype($label));
149 var_export($label, true), gettype($label));
184 var_export($label, true), gettype($label));
206 var_export($label, true), gettype($label));
230 var_export($label, true), gettype($label));
259 var_export($label, true), gettype($label));
[all …]
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_stmt_blobs.phpt28 …$db->exec(sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, PDO_MYSQL_TEST_ENGIN…
31 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)');
40 $stmt = $db->query('SELECT id, label FROM test');
41 $id = $label = NULL;
43 $stmt->bindColumn(2, $label, PDO::PARAM_LOB);
51 if ($label !== $value) {
53 $offset, strlen($label), strlen($value));
63 $stmt = $db->query('SELECT id, label FROM test');
66 if ($ret['label'] !== $value) {
68 $offset, strlen($ret['label']), strlen($value));
H A Dpdo_mysql_stmt_closecursor.phpt52 if (!isset($row2['label']) || ('z' !== $row2['label']))
86 $id = $label = null;
100 var_export($label, true), gettype($label));
158 in = 0 -> id = 1 (integer) / label = 'a' (string)
159 in = 0 -> id = 2 (integer) / label = 'b' (string)
163 in = 0 -> id = 1 (integer) / label = 'a' (string)
164 in = 0 -> id = 2 (integer) / label = 'b' (string)
169 in = 0 -> id = 1 (integer) / label = 'a' (string)
170 in = 0 -> id = 2 (integer) / label = 'b' (string)
174 in = 0 -> id = 1 (integer) / label = 'a' (string)
[all …]
H A Dpdo_mysql_stmt_closecursor_empty.phpt25 $stmt = $db->prepare('SELECT id, label FROM test WHERE id > ? ORDER BY id ASC LIMIT 2');
32 $id = $label = null;
38 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
43 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
46 var_export($label, true), gettype($label));
51 printf("in = %d -> id = %s (%s) / label = %s (%s)\n",
54 var_export($label, true), gettype($label));
70 in = 0 -> id = 1 (integer) / label = 'a' (string)
71 in = 0 -> id = 2 (integer) / label = 'b' (string)
72 in = 0 -> id = 1 (integer) / label = 'a' (string)
[all …]
H A Dpdo_mysql_stmt_columncount.phpt25 $stmt = $db->prepare("SELECT id, label, '?' as foo FROM test");
43 $stmt = $db->prepare("SELECT id, label, '?' as foo, 'TODO - Stored Procedure' as bar FROM test");
H A Dpdo_mysql_stmt_errorinfo.phpt28 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
49 $stmt = $db->prepare('SELECT label FROM test ORDER BY id ASC LIMIT 1');
H A Dpdo_mysql_stmt_getcolumnmeta.phpt73 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE…
79 if (!$db->exec(sprintf("INSERT INTO test(id, label) VALUES (1, '%s')", $value))) {
85 $stmt = $db->prepare('SELECT id, label FROM test');
104 if (($meta['table'] != 'test') || ($meta['name'] != 'label')) {
237 …$sql = sprintf('CREATE TABLE test(id INT, label INT UNIQUE) ENGINE = %s', MySQLPDOTest::getTableEn…
239 $db->exec('INSERT INTO test(id, label) VALUES (1, 2)');
240 $stmt = $db->query('SELECT id, label FROM test');
H A Dpdo_mysql_stmt_multiquery.phpt15 …$stmt = $db->query('SELECT label FROM test ORDER BY id ASC LIMIT 1; SELECT label FROM test ORDER B…
24 …$stmt = $db->query('SELECT label FROM test ORDER BY id ASC LIMIT 1; SELECT label FROM test ORDER B…
72 ["label"]=>
87 ["label"]=>
94 ["label"]=>
100 …onds to your %s server version for the right syntax to use near '%SSELECT label FROM test ORDER BY…
H A Dpdo_mysql_stmt_nextrowset.phpt148 ["label"]=>
155 ["label"]=>
162 ["label"]=>
197 ["label"]=>
204 ["label"]=>
211 ["label"]=>
247 ["label"]=>
254 ["label"]=>
261 ["label"]=>
296 ["label"]=>
[all …]
H A Dpdo_mysql_stmt_unbuffered_2050.phpt27 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
29 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
35 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
87 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
99 $stmt = $db->query('SELECT id, label FROM test WHERE id = 1');
126 ["label"]=>
135 ["label"]=>
153 ["label"]=>
162 ["label"]=>
171 ["label"]=>
[all …]
H A Dpdo_mysql_types.phpt23 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)');
31 $stmt = $db->query('SELECT id, label FROM test');
35 if (!isset($row['id']) || !isset($row['label'])) {
46 if (!preg_match($pattern, $row['label'])) {
48 $offset, $pattern, var_export($row['label'], true));
60 …if ($row['label'] !== $exp && !is_null($alternative_type) && gettype($row['label']) != $alternativ…
63 var_export($row['label'], true), gettype($row['label']),
71 $stmt = $db->query('SELECT id, label FROM test');
74 if (is_null($pattern) && ($row['label'] != $row_string['label'])) {
75 …= %s, NATIVE = %s\n", $sql_type, var_export($row_string['label'], true), var_export($row['label'],…
[all …]
H A Dpdo_mysql_types_zerofill.phpt16 …$sql = sprintf('CREATE TABLE test(id INT, label %s) ENGINE=%s', $sql_type, MySQLPDOTest::getTableE…
23 $stmt = $db->prepare('INSERT INTO test(id, label) VALUES (?, ?)');
38 $stmt = $db->query('SELECT id, label FROM test');
41 if (!isset($row['id']) || !isset($row['label'])) {
53 if (!preg_match($pattern, $row['label'])) {
55 $offset, $pattern, var_export($row['label'], true));
68 if ($row['label'] !== $exp) {
71 var_export($row['label'], true), gettype($row['label']));
78 $stmt = $db->query('SELECT id, label FROM test');
81 if ($row['label'] != $row_string['label']) {
[all …]
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,…
/PHP-7.4/ext/pdo_oci/tests/
H A Dpdo_oci_stmt_getcolumnmeta.phpt137 $sql = sprintf('CREATE TABLE test(id INT, label %s)', $sql_type);
141 if (!$db->exec(sprintf("INSERT INTO test(id, label) VALUES (1, '%s')", $value))) {
147 $stmt = $db->prepare('SELECT id, label FROM test');
233 $sql = sprintf('CREATE TABLE test(id INT NOT NULL, label INT NULL)');
236 $db->exec('INSERT INTO test(id, label) VALUES (1, 1)');
237 $stmt = $db->query('SELECT id, label FROM test');
/PHP-7.4/ext/phar/tests/zip/
H A Dbug48791.phpt13 …label-alignment"><style:list-level-label-alignment text:label-followed-by="listtab" text:list-tab-…

Completed in 87 milliseconds

12345678