Lines Matching refs:placeholder
122 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
127 prepex(10, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
128 array(':placeholder' => 'first row'));
129 prepex(11, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
130 array(':placeholder' => 'second row'));
135 $stmt = prepex(13, $db, 'SELECT label FROM test WHERE :placeholder > 1',
136 array(':placeholder' => 'id'));
140 $params = array(':placeholder' => 'a');
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',
149 array(':placeholder' => 1));
153 $stmt = prepex(18, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
154 array(':placeholder' => 1));
162 prepex(23, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
163 array(':placeholder' => 'MySQL is the best database in the world!'));
164 prepex(24, $db, 'INSERT INTO test(id, label) VALUES (2, :placeholder)',
165 …array(':placeholder' => 'If I have the freedom to choose, I would always go again for the MySQL Se…
166 $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
167 array(':placeholder' => 'mysql'), null, true);
189 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
191 $stmt = prepex(29, $db, $sql, array('placeholder' => -1));
195 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
197 $stmt = prepex(31, $db, $sql, array('placeholder' => 1));
292 $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
293 array(':placeholder' => 'row'),
349 string(12) ":placeholder"