Lines Matching refs:label
100 …prepex(6, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENGI…
101 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
102 $stmt = prepex(8, $db, 'SELECT label FROM test');
106 prepex(10, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')",
108 $stmt = prepex(11, $db, 'SELECT label FROM test');
112 prepex(13, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
114 prepex(14, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
116 $stmt = prepex(15, $db, 'SELECT label FROM test');
120 prepex(16, $db, 'SELECT label FROM test WHERE :placeholder > 1',
132 prepex(19, $db, 'SELECT id, label FROM test WHERE label > :placeholder',
137 prepex(21, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
139 $stmt = prepex(22, $db, 'SELECT id, label FROM test');
142 $stmt = prepex(23, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
147 $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
153 prepex(28, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
154 if (is_object(prepex(29, $db, 'CREATE FULLTEXT INDEX idx1 ON test(label)'))) {
155 prepex(30, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
157 prepex(31, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
159 $stmt = prepex(32, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
168 prepex(35, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
171 $stmt = prepex(36, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (:placeholder)',
175 $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
179 $stmt = prepex(38, $db, 'SELECT id, label AS "label" FROM test WHERE label = :placeholder',
182 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
189 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
195 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
202 …prepex(46, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENG…
203 prepex(47, $db, "INSERT INTO test(id, label) VALUES(1, '?')");
204 $stmt = prepex(48, $db, 'SELECT label FROM test');
208 prepex(50, $db, "INSERT INTO test(id, label) VALUES(1, '?')",
210 $stmt = prepex(51, $db, 'SELECT label FROM test');
214 prepex(53, $db, 'INSERT INTO test(id, label) VALUES(1, ?)',
216 prepex(54, $db, 'INSERT INTO test(id, label) VALUES(2, ?)',
218 $stmt = prepex(55, $db, 'SELECT label FROM test');
222 prepex(56, $db, 'SELECT label FROM test WHERE ? > 1',
230 array('id', 'label', 'value'));
237 prepex(60, $db, 'SELECT id, label FROM test WHERE label > ?',
242 prepex(62, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
244 $stmt = prepex(63, $db, 'SELECT id, label FROM test');
247 $stmt = prepex(64, $db, 'SELECT id, label FROM test WHERE ? IS NOT NULL',
252 $stmt = prepex(66, $db, 'SELECT id, label FROM test WHERE ? IS NULL',
258 prepex(69, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
259 if (is_object(prepex(70, $db, 'CREATE FULLTEXT INDEX idx1 ON test(label)'))) {
260 prepex(71, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
262 prepex(72, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
264 $stmt = prepex(73, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (?)',
274 prepex(75, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
277 $stmt = prepex(76, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (?)',
283 $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
288 $stmt = prepex(78, $db, 'SELECT id, label AS "label" FROM test WHERE label = ?',
291 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
298 $sql = sprintf("SELECT id, label FROM test WHERE (id = ?) OR (label LIKE %s)",
304 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
309 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
338 ["label"]=>
345 ["label"]=>
352 ["label"]=>
357 ["label"]=>
366 ["label"]=>
373 ["label"]=>
380 ["label"]=>
387 ["label"]=>
394 ["label"]=>
399 ["label"]=>
408 ["label"]=>
415 ["label"]=>
