Lines Matching refs:id
121 …prepex(6, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENGI…
122 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
123 $stmt = prepex(8, $db, 'SELECT label FROM test ORDER BY id ASC');
127 prepex(10, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
129 prepex(11, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
131 $stmt = prepex(12, $db, 'SELECT label FROM test ORDER BY id ASC');
136 array(':placeholder' => 'id'));
144 prepex(16, $db, 'SELECT id, label FROM test WHERE label > :placeholder',
148 $stmt = prepex(16, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
153 $stmt = prepex(18, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
159 prepex(21, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
162 prepex(23, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
164 prepex(24, $db, 'INSERT INTO test(id, label) VALUES (2, :placeholder)',
166 $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
174 $stmt = prepex(26, $db, 'SELECT id, label FROM test ORDER BY id ASC');
186 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')");
187 $db->exec("INSERT INTO test(id, label) VALUES (2, 'row2')");
189 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
195 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
203 …prepex(34, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENG…
204 prepex(35, $db, "INSERT INTO test(id, label) VALUES(1, '?')");
209 prepex(38, $db, 'INSERT INTO test(id, label) VALUES(1, ?)',
211 prepex(39, $db, 'INSERT INTO test(id, label) VALUES(2, ?)',
218 array('id'));
219 prepex(41, $db, 'SELECT ? FROM test WHERE id > 1',
220 array('id'));
222 array('id', 'label', 'value'));
229 prepex(43, $db, 'SELECT id, label FROM test WHERE label > ?',
234 prepex(45, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
236 $stmt = prepex(46, $db, 'SELECT id, label FROM test');
240 "id" => "1",
244 "id" => "2",
251 $exp[0]['id'] = 1;
252 $exp[1]['id'] = 2;
260 $stmt = prepex(47, $db, 'SELECT id, label FROM test WHERE ? IS NOT NULL',
265 $stmt = prepex(49, $db, 'SELECT id, label FROM test WHERE ? IS NULL',
271 prepex(52, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
273 prepex(54, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
275 prepex(55, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
277 $stmt = prepex(56, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (?)',
287 prepex(58, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
292 $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
297 $stmt = prepex(59, $db, 'SELECT id, label AS "label" FROM test WHERE label = ?',
301 0 => array("id" => "1", "label" => "row1")
306 $exp[0]['id'] = 1;
314 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
320 $sql = sprintf("SELECT id, label FROM test WHERE (id = ?) OR (label LIKE %s)",
326 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
