Lines Matching refs:placeholder
101 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
106 prepex(10, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')",
107 array(':placeholder' => 'first row'));
112 prepex(13, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
113 array(':placeholder' => 'first row'));
114 prepex(14, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
115 array(':placeholder' => 'second row'));
120 prepex(16, $db, 'SELECT label FROM test WHERE :placeholder > 1',
121 array(':placeholder' => 'id'));
122 prepex(17, $db, 'SELECT :placeholder FROM test WHERE id > 1',
123 array(':placeholder' => 'id'));
124 prepex(18, $db, 'SELECT :placeholder FROM test WHERE :placeholder > :placeholder',
125 array(':placeholder' => 'test'));
128 $params = array(':placeholder' => 'a');
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)',
138 array(':placeholder' => 'row'));
142 $stmt = prepex(23, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
143 array(':placeholder' => 1));
147 $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
148 array(':placeholder' => 1));
155 prepex(30, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
156 array(':placeholder' => 'MySQL is the best database in the world!'));
157 prepex(31, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
158 …array(':placeholder' => 'If I have the freedom to choose, I would always go again for the MySQL Se…
159 $stmt = prepex(32, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
160 array(':placeholder' => 'mysql'));
168 prepex(35, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
169 array(':placeholder' => 'row'));
171 $stmt = prepex(36, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (:placeholder)',
172 array(':placeholder' => 'row'),
175 $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
176 array(':placeholder' => 'row'),
179 $stmt = prepex(38, $db, 'SELECT id, label AS "label" FROM test WHERE label = :placeholder',
180 array(':placeholder' => 'row'));
182 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
184 $stmt = prepex(39, $db, $sql, array('placeholder' => -1));
189 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
191 $stmt = prepex(41, $db, $sql, array('placeholder' => 1));
195 …CT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' FROM test WHE…
196 $stmt = prepex(43, $db, $sql, array('placeholder' => 1));
283 $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
284 array(':placeholder' => 'row'),
309 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
339 string(12) ":placeholder"
346 string(12) ":placeholder"
