Lines Matching refs:label
104 …prepex(6, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENGI…
105 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
106 $stmt = prepex(8, $db, 'SELECT label FROM test');
110 prepex(10, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')",
112 $stmt = prepex(11, $db, 'SELECT label FROM test');
116 prepex(13, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
118 prepex(14, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
120 $stmt = prepex(15, $db, 'SELECT label FROM test');
124 prepex(16, $db, 'SELECT label FROM test WHERE :placeholder > 1',
136 prepex(19, $db, 'SELECT id, label FROM test WHERE label > :placeholder',
141 prepex(21, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
143 $stmt = prepex(22, $db, 'SELECT id, label FROM test');
146 $stmt = prepex(23, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
151 $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
157 prepex(28, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
158 if (is_object(prepex(29, $db, 'CREATE FULLTEXT INDEX idx1 ON test(label)'))) {
159 prepex(30, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
161 prepex(31, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
163 … $stmt = prepex(32, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
172 prepex(35, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
175 … $stmt = prepex(36, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (:placeholder)',
179 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
183 $stmt = prepex(38, $db, 'SELECT id, label AS "label" FROM test WHERE label = :placeholder',
186 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
193 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
199 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
206 …prepex(46, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENG…
207 prepex(47, $db, "INSERT INTO test(id, label) VALUES(1, '?')");
208 $stmt = prepex(48, $db, 'SELECT label FROM test');
212 prepex(50, $db, "INSERT INTO test(id, label) VALUES(1, '?')",
214 $stmt = prepex(51, $db, 'SELECT label FROM test');
218 prepex(53, $db, 'INSERT INTO test(id, label) VALUES(1, ?)',
220 prepex(54, $db, 'INSERT INTO test(id, label) VALUES(2, ?)',
222 $stmt = prepex(55, $db, 'SELECT label FROM test');
226 prepex(56, $db, 'SELECT label FROM test WHERE ? > 1',
234 array('id', 'label', 'value'));
241 prepex(60, $db, 'SELECT id, label FROM test WHERE label > ?',
246 prepex(62, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
248 $stmt = prepex(63, $db, 'SELECT id, label FROM test');
251 $stmt = prepex(64, $db, 'SELECT id, label FROM test WHERE ? IS NOT NULL',
256 $stmt = prepex(66, $db, 'SELECT id, label FROM test WHERE ? IS NULL',
262 prepex(69, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
263 if (is_object(prepex(70, $db, 'CREATE FULLTEXT INDEX idx1 ON test(label)'))) {
264 prepex(71, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
266 prepex(72, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
268 $stmt = prepex(73, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (?)',
278 prepex(75, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
281 $stmt = prepex(76, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (?)',
287 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
292 $stmt = prepex(78, $db, 'SELECT id, label AS "label" FROM test WHERE label = ?',
295 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
302 $sql = sprintf("SELECT id, label FROM test WHERE (id = ?) OR (label LIKE %s)",
308 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
313 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
340 ["label"]=>
351 ["label"]=>
356 ["label"]=>
365 ["label"]=>
372 ["label"]=>
379 ["label"]=>
390 ["label"]=>
395 ["label"]=>
404 ["label"]=>
411 ["label"]=>
