pdo_mysql_prepare_emulated.phpt - OpenGrok cross reference for /PHP-8.3/ext/pdo_mysql/tests/pdo_mysql_prepare

Lines Matching refs:SELECT
99         // lets be fair and do the most simple SELECT first
100         $stmt = prepex(4, $db, 'SELECT 1 as "one"');
106         $stmt = prepex(8, $db, 'SELECT label FROM test');
112         $stmt = prepex(11, $db, 'SELECT label FROM test');
120         $stmt = prepex(15, $db, 'SELECT label FROM test');
124         prepex(16, $db, 'SELECT label FROM test WHERE :placeholder > 1',
126         prepex(17, $db, 'SELECT :placeholder FROM test WHERE id > 1',
128         prepex(18, $db, 'SELECT :placeholder FROM test WHERE :placeholder > :placeholder',
136             prepex(19, $db, 'SELECT id, label FROM test WHERE label > :placeholder',
143         $stmt = prepex(22, $db, 'SELECT id, label FROM test');
146         $stmt = prepex(23, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
151         $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
163 …     $stmt = prepex(32, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
175 …    $stmt = prepex(36, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (:placeholder)',
179 …   $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
183         $stmt = prepex(38, $db, 'SELECT id, label AS "label" FROM test WHERE label = :placeholder',
186         $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
193         $sql = sprintf("SELECT id, label FROM test WHERE  (id = :placeholder) OR (label LIKE %s)",
199 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
208         $stmt = prepex(48, $db, 'SELECT label FROM test');
214         $stmt = prepex(51, $db, 'SELECT label FROM test');
222         $stmt = prepex(55, $db, 'SELECT label FROM test');
226         prepex(56, $db, 'SELECT label FROM test WHERE ? > 1',
228         prepex(57, $db, 'SELECT ? FROM test WHERE id > 1',
230         prepex(58, $db, 'SELECT ? FROM test WHERE ? > ?',
233         prepex(59, $db, 'SELECT ? FROM test WHERE ? > ?',
241             prepex(60, $db, 'SELECT id, label FROM test WHERE label > ?',
248         $stmt = prepex(63, $db, 'SELECT id, label FROM test');
251         $stmt = prepex(64, $db, 'SELECT id, label FROM test WHERE ? IS NOT NULL',
256         $stmt = prepex(66, $db, 'SELECT id, label FROM test WHERE ? IS NULL',
268             $stmt = prepex(73, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (?)',
281         $stmt = prepex(76, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (?)',
287 …   $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
292         $stmt = prepex(78, $db, 'SELECT id, label AS "label" FROM test WHERE label = ?',
295         $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
302         $sql = sprintf("SELECT id, label FROM test WHERE  (id = ?) OR (label LIKE %s)",
308 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
313 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…