Home
last modified time | relevance | path

Searched refs:label (Results 26 – 50 of 206) sorted by last modified time

123456789

/PHP-5.5/ext/pdo_mysql/tests/
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_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_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_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 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_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 [%u|b%"label"]=>
87 [%u|b%"label"]=>
94 [%u|b%"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 [%u|b%"label"]=>
155 [%u|b%"label"]=>
162 [%u|b%"label"]=>
197 [%u|b%"label"]=>
204 [%u|b%"label"]=>
211 [%u|b%"label"]=>
247 [%u|b%"label"]=>
254 [%u|b%"label"]=>
261 [%u|b%"label"]=>
296 [%u|b%"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 [%u|b%"label"]=>
135 [%u|b%"label"]=>
153 [%u|b%"label"]=>
162 [%u|b%"label"]=>
171 [%u|b%"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 Dpdo_mysql_multi_stmt_nextrowset.phpt115 ["label"]=>
122 ["label"]=>
129 ["label"]=>
156 ["label"]=>
163 ["label"]=>
170 ["label"]=>
200 ["label"]=>
207 ["label"]=>
214 ["label"]=>
241 ["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_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 Dmysql_pdo_test.inc40 $db->exec('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine);
41 …$db->exec("INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e'), (6…
H A Dpdo_mysql_attr_autocommit.phpt60 $db->query("INSERT INTO test(id, label) VALUES (100, 'z')");
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_attr_fetch_table_names.phpt16 $stmt = $db->query('SELECT label FROM test LIMIT 1');
21 $stmt = $db->query('SELECT label FROM test LIMIT 1');
31 [%u|b%"test.label"]=>
38 [%u|b%"label"]=>
H A Dpdo_mysql_attr_statement_class.phpt82 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 2');
92 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 2');
98 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 1');
106 $stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC LIMIT 1');
148 [%u|b%"label"]=>
H A Dpdo_mysql_begintransaction.phpt36 if (!($stmt = $db->query('SELECT id, label FROM test ORDER BY id ASC')))
54 if (!($stmt = $db->query(sprintf('SELECT id, label FROM test WHERE id = %d', $row['id']))))
62 $db->exec(sprintf("INSERT INTO test(id, label) VALUES (%d, 'z')", $row['id']));
64 if (!($stmt = $db->query(sprintf('SELECT id, label FROM test WHERE id = %d', $row['id']))))
73 if (!($stmt = $db->query(sprintf('SELECT id, label FROM test WHERE id = %d', $row['id']))))
95 if (!($stmt = $db->query(sprintf('SELECT id, label FROM test WHERE id = %d', $row['id']))))
169 if (0 == $db->exec("INSERT INTO test(id, label) VALUES (1, 'a')"))
193 [%u|b%"label"]=>
200 [%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_commit.phpt40 $db->exec("INSERT INTO test(id, label) VALUES (100, 'z')");
47 $stmt = $db->query('SELECT id, label FROM test WHERE id = 100');
49 if (!isset($rows[0]['label']) || ($rows[0]['label'] != 'z')) {
62 $db->exec("INSERT INTO test(id, label) VALUES (100, 'z')");
68 $stmt = $db->query('SELECT id, label FROM test WHERE id = 100');
70 if (!isset($rows[0]['label']) || ($rows[0]['label'] != 'z')) {
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');

Completed in 43 milliseconds

123456789