Lines Matching refs:placeholder
124 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
129 prepex(10, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
130 array(':placeholder' => 'first row'));
131 prepex(11, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
132 array(':placeholder' => 'second row'));
137 $stmt = prepex(13, $db, 'SELECT label FROM test WHERE :placeholder > 1',
138 array(':placeholder' => 'id'));
142 $params = array(':placeholder' => 'a');
146 prepex(16, $db, 'SELECT id, label FROM test WHERE label > :placeholder',
150 $stmt = prepex(16, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
151 array(':placeholder' => 1));
155 $stmt = prepex(18, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
156 array(':placeholder' => 1));
164 prepex(23, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
165 array(':placeholder' => 'MySQL is the best database in the world!'));
166 prepex(24, $db, 'INSERT INTO test(id, label) VALUES (2, :placeholder)',
167 …array(':placeholder' => 'If I have the freedom to choose, I would always go again for the MySQL Se…
168 … $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
169 array(':placeholder' => 'mysql'), null, true);
191 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
193 $stmt = prepex(29, $db, $sql, array('placeholder' => -1));
197 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
199 $stmt = prepex(31, $db, $sql, array('placeholder' => 1));
294 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
295 array(':placeholder' => 'row'),
352 string(12) ":placeholder"