Lines Matching refs:placeholder
103 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
108 prepex(10, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')",
109 array(':placeholder' => 'first row'));
114 prepex(13, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
115 array(':placeholder' => 'first row'));
116 prepex(14, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
117 array(':placeholder' => 'second row'));
122 prepex(16, $db, 'SELECT label FROM test WHERE :placeholder > 1',
123 array(':placeholder' => 'id'));
124 prepex(17, $db, 'SELECT :placeholder FROM test WHERE id > 1',
125 array(':placeholder' => 'id'));
126 prepex(18, $db, 'SELECT :placeholder FROM test WHERE :placeholder > :placeholder',
127 array(':placeholder' => 'test'));
130 $params = array(':placeholder' => 'a');
134 prepex(19, $db, 'SELECT id, label FROM test WHERE label > :placeholder',
139 prepex(21, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
140 array(':placeholder' => 'row'));
144 $stmt = prepex(23, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
145 array(':placeholder' => 1));
149 $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
150 array(':placeholder' => 1));
157 prepex(30, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
158 array(':placeholder' => 'MySQL is the best database in the world!'));
159 prepex(31, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
160 …array(':placeholder' => 'If I have the freedom to choose, I would always go again for the MySQL Se…
161 … $stmt = prepex(32, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
162 array(':placeholder' => 'mysql'));
170 prepex(35, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
171 array(':placeholder' => 'row'));
173 … $stmt = prepex(36, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (:placeholder)',
174 array(':placeholder' => 'row'),
177 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
178 array(':placeholder' => 'row'),
181 $stmt = prepex(38, $db, 'SELECT id, label AS "label" FROM test WHERE label = :placeholder',
182 array(':placeholder' => 'row'));
184 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
186 $stmt = prepex(39, $db, $sql, array('placeholder' => -1));
191 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
193 $stmt = prepex(41, $db, $sql, array('placeholder' => 1));
197 …CT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' FROM test WHE…
198 $stmt = prepex(43, $db, $sql, array('placeholder' => 1));
285 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
286 array(':placeholder' => 'row'),
311 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
339 string(12) ":placeholder"
