Lines Matching refs:db
14 $db = MySQLPDOTest::factory();
15 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
17 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
19 $db->query('CREATE TABLE test_80458 (first INT) ENGINE = InnoDB');
20 $res = $db->query('INSERT INTO test_80458(first) VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(1…
23 $stmt = $db->prepare('DELETE FROM test_80458 WHERE first=1');
27 $res = $db->query('DELETE FROM test_80458 WHERE first=2');
30 $stmt2 = $db->prepare('DELETE FROM test_80458 WHERE first=3');
36 $stmt3 = $db->prepare('DELETE FROM test_80458 WHERE first=4');
40 $stmt = $db->prepare('SELECT first FROM test_80458 WHERE first=5');
46 $db->exec("CREATE PROCEDURE {$procedure_nores}() BEGIN DELETE FROM test_80458 WHERE first=6; END;");
47 $stmt4 = $db->prepare("CALL {$procedure_nores}()");
50 $db->exec("DROP PROCEDURE IF EXISTS {$procedure_nores}");
54 $db->exec("CREATE PROCEDURE {$procedure_ret}() BEGIN SELECT first FROM test_80458 WHERE first=7; EN…
55 $stmt5 = $db->prepare("CALL {$procedure_ret}()");
60 $db->exec("DROP PROCEDURE IF EXISTS {$procedure_ret}");
64 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
66 $stmt = $db->prepare('DELETE FROM test_80458 WHERE first=8');
70 $res = $db->query('DELETE FROM test_80458 WHERE first=9');
73 $stmt2 = $db->prepare('DELETE FROM test_80458 WHERE first=10');
79 $stmt3 = $db->prepare('DELETE FROM test_80458 WHERE first=11');
83 $stmt = $db->prepare('SELECT first FROM test_80458 WHERE first=12');
87 $db->exec("CREATE PROCEDURE {$procedure_nores}() BEGIN DELETE FROM test_80458 WHERE first=13; END;"…
88 $stmt4 = $db->prepare("CALL {$procedure_nores}()");
91 $db->exec("CREATE PROCEDURE {$procedure_ret}() BEGIN SELECT first FROM test_80458 WHERE first=14; E…
92 $stmt5 = $db->prepare("CALL {$procedure_ret}()");
97 $db->exec("DROP PROCEDURE IF EXISTS {$procedure_ret}");
99 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
100 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
102 $stmt = $db->prepare('DELETE FROM test_80458 WHERE first=15');
106 $stmt = $db->prepare('SELECT first FROM test_80458 WHERE first=16');
113 $db = MySQLPDOTest::factory();
114 $db->exec('DROP TABLE IF EXISTS test_80458');
115 $db->exec('DROP PROCEDURE IF EXISTS nores_bug80458_pdo_mysql_p');
116 $db->exec('DROP PROCEDURE IF EXISTS ret_bug80458_pdo_mysql_p');
