Lines Matching refs:placeholder
105 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
110 prepex(10, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')",
111 array(':placeholder' => 'first row'));
116 prepex(13, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
117 array(':placeholder' => 'first row'));
118 prepex(14, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
119 array(':placeholder' => 'second row'));
124 prepex(16, $db, 'SELECT label FROM test WHERE :placeholder > 1',
125 array(':placeholder' => 'id'));
126 prepex(17, $db, 'SELECT :placeholder FROM test WHERE id > 1',
127 array(':placeholder' => 'id'));
128 prepex(18, $db, 'SELECT :placeholder FROM test WHERE :placeholder > :placeholder',
129 array(':placeholder' => 'test'));
132 $params = array(':placeholder' => 'a');
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)',
142 array(':placeholder' => 'row'));
146 $stmt = prepex(23, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
147 array(':placeholder' => 1));
151 $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
152 array(':placeholder' => 1));
159 prepex(30, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
160 array(':placeholder' => 'MySQL is the best database in the world!'));
161 prepex(31, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
162 …array(':placeholder' => 'If I have the freedom to choose, I would always go again for the MySQL Se…
163 … $stmt = prepex(32, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
164 array(':placeholder' => 'mysql'));
172 prepex(35, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
173 array(':placeholder' => 'row'));
175 … $stmt = prepex(36, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (:placeholder)',
176 array(':placeholder' => 'row'),
179 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
180 array(':placeholder' => 'row'),
183 $stmt = prepex(38, $db, 'SELECT id, label AS "label" FROM test WHERE label = :placeholder',
184 array(':placeholder' => 'row'));
186 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
188 $stmt = prepex(39, $db, $sql, array('placeholder' => -1));
193 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
195 $stmt = prepex(41, $db, $sql, array('placeholder' => 1));
199 …CT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' FROM test WHE…
200 $stmt = prepex(43, $db, $sql, array('placeholder' => 1));
287 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
288 array(':placeholder' => 'row'),
313 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
341 string(12) ":placeholder"
