Lines Matching refs:label
102 …prepex(6, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENGI…
103 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
104 $stmt = prepex(8, $db, 'SELECT label FROM test');
108 prepex(10, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')",
110 $stmt = prepex(11, $db, 'SELECT label FROM test');
114 prepex(13, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
116 prepex(14, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
118 $stmt = prepex(15, $db, 'SELECT label FROM test');
122 prepex(16, $db, 'SELECT label FROM test WHERE :placeholder > 1',
134 prepex(19, $db, 'SELECT id, label FROM test WHERE label > :placeholder',
139 prepex(21, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
141 $stmt = prepex(22, $db, 'SELECT id, label FROM test');
144 $stmt = prepex(23, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
149 $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
155 prepex(28, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
156 if (is_object(prepex(29, $db, 'CREATE FULLTEXT INDEX idx1 ON test(label)'))) {
157 prepex(30, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
159 prepex(31, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
161 … $stmt = prepex(32, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
170 prepex(35, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
173 … $stmt = prepex(36, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (:placeholder)',
177 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
181 $stmt = prepex(38, $db, 'SELECT id, label AS "label" FROM test WHERE label = :placeholder',
184 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
191 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
197 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
204 …prepex(46, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENG…
205 prepex(47, $db, "INSERT INTO test(id, label) VALUES(1, '?')");
206 $stmt = prepex(48, $db, 'SELECT label FROM test');
210 prepex(50, $db, "INSERT INTO test(id, label) VALUES(1, '?')",
212 $stmt = prepex(51, $db, 'SELECT label FROM test');
216 prepex(53, $db, 'INSERT INTO test(id, label) VALUES(1, ?)',
218 prepex(54, $db, 'INSERT INTO test(id, label) VALUES(2, ?)',
220 $stmt = prepex(55, $db, 'SELECT label FROM test');
224 prepex(56, $db, 'SELECT label FROM test WHERE ? > 1',
232 array('id', 'label', 'value'));
239 prepex(60, $db, 'SELECT id, label FROM test WHERE label > ?',
244 prepex(62, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
246 $stmt = prepex(63, $db, 'SELECT id, label FROM test');
249 $stmt = prepex(64, $db, 'SELECT id, label FROM test WHERE ? IS NOT NULL',
254 $stmt = prepex(66, $db, 'SELECT id, label FROM test WHERE ? IS NULL',
260 prepex(69, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
261 if (is_object(prepex(70, $db, 'CREATE FULLTEXT INDEX idx1 ON test(label)'))) {
262 prepex(71, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
264 prepex(72, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
266 $stmt = prepex(73, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (?)',
276 prepex(75, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
279 $stmt = prepex(76, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (?)',
285 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
290 $stmt = prepex(78, $db, 'SELECT id, label AS "label" FROM test WHERE label = ?',
293 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
300 $sql = sprintf("SELECT id, label FROM test WHERE (id = ?) OR (label LIKE %s)",
306 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
311 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
338 ["label"]=>
349 ["label"]=>
354 ["label"]=>
363 ["label"]=>
370 ["label"]=>
377 ["label"]=>
388 ["label"]=>
393 ["label"]=>
402 ["label"]=>
409 ["label"]=>
