/PHP-8.0/ext/pdo/tests/ |
H A D | pdo_019.phpt | 17 $db->exec('CREATE TABLE test(idx int NOT NULL PRIMARY KEY, txt VARCHAR(20))'); 18 $db->exec('INSERT INTO test VALUES(0, \'String0\')'); 19 $db->exec('INSERT INTO test VALUES(1, \'String1\')'); 20 $db->exec('INSERT INTO test VALUES(2, \'String2\')'); 21 $db->exec('INSERT INTO test VALUES(3, \'String3\')');
|
H A D | pdo_008.phpt | 17 $db->exec('CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))'); 18 $db->exec("INSERT INTO test VALUES('A', 'A')"); 19 $db->exec("INSERT INTO test VALUES('B', 'A')"); 20 $db->exec("INSERT INTO test VALUES('C', 'C')");
|
H A D | pdo_001.phpt | 17 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 18 $db->exec("INSERT INTO test VALUES(1, 'A')"); 19 $db->exec("INSERT INTO test VALUES(2, 'B')"); 20 $db->exec("INSERT INTO test VALUES(3, 'C')");
|
H A D | pdo_004.phpt | 17 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 18 $db->exec("INSERT INTO test VALUES(1, 'A')"); 19 $db->exec("INSERT INTO test VALUES(2, 'B')"); 20 $db->exec("INSERT INTO test VALUES(3, 'C')");
|
H A D | pdo_003.phpt | 17 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 18 $db->exec("INSERT INTO test VALUES(1, 'A')"); 19 $db->exec("INSERT INTO test VALUES(2, 'B')"); 20 $db->exec("INSERT INTO test VALUES(3, 'C')");
|
H A D | pdo_006.phpt | 17 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))'); 18 $db->exec("INSERT INTO test VALUES(1, 'A')"); 19 $db->exec("INSERT INTO test VALUES(2, 'A')"); 20 $db->exec("INSERT INTO test VALUES(3, 'C')");
|
H A D | pdo_007.phpt | 17 $db->exec('CREATE TABLE test(id CHAR(1) NOT NULL PRIMARY KEY, val VARCHAR(10))'); 18 $db->exec("INSERT INTO test VALUES('A', 'A')"); 19 $db->exec("INSERT INTO test VALUES('B', 'A')"); 20 $db->exec("INSERT INTO test VALUES('C', 'C')");
|
H A D | bug_39656.phpt | 18 @$db->exec("DROP TABLE test"); 21 $db->exec("CREATE TABLE test (id INTEGER NOT NULL PRIMARY KEY, usr VARCHAR( 256 ) NOT NULL)"); 22 $db->exec("INSERT INTO test (id, usr) VALUES (1, 'user')"); 35 @$db->exec("DROP TABLE test");
|
H A D | pdo_020.phpt | 17 $db->exec('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))'); 18 $db->exec("INSERT INTO test VALUES(1, 'A', 'A')"); 19 $db->exec("INSERT INTO test VALUES(2, 'B', 'B')"); 20 $db->exec("INSERT INTO test VALUES(3, 'C', 'C')");
|
/PHP-8.0/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_inTransaction.phpt | 20 foreach (['exec', 'query', 'execute'] as $w) { 23 case 'exec': 24 $db->exec($command); 47 $db->exec($end); 51 $db->exec('START TRANSACTION'); 55 $db->exec('START TRANSACTION'); 64 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | bug_42499.phpt | 2 Bug #42499 (Multi-statement execution via PDO::exec() makes connection unusable) 29 $db->exec('DROP TABLE IF EXISTS test'); 30 $db->exec("CREATE TABLE test(id CHAR(1)); INSERT INTO test(id) VALUES ('a')"); 35 // You must not use exec() to run statements that create a result set! 36 $db->exec('SELECT id FROM test'); 38 $db->exec("INSERT INTO test(id) VALUES ('b')"); 55 $db->exec('DROP TABLE IF EXISTS test'); 69 Warning: PDO::exec(): SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuf… 79 Warning: PDO::exec(): SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuf…
|
H A D | bug_44454.phpt | 20 $db->exec('DROP TABLE IF EXISTS test'); 21 $db->exec('CREATE TABLE test(a INT, b INT, UNIQUE KEY idx_ab (a, b))'); 22 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)'); 29 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)'); 36 $db->exec('DROP TABLE IF EXISTS test'); 37 $db->exec('CREATE TABLE test(a INT, b INT, UNIQUE KEY idx_ab (a, b))'); 38 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)'); 49 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)'); 74 $db->exec('DROP TABLE IF EXISTS test');
|
H A D | bug77289.phpt | 17 $pdo->exec("DROP TABLE IF EXISTS bug77289"); 18 $pdo->exec("CREATE TEMPORARY TABLE bug77289 (x INT)"); 19 $pdo->exec("UPDATE bug77289 SET x = x");
|
H A D | bug53551.phpt | 21 $db->exec('drop table if exists bug53551'); 22 $db->exec($createSql); 23 $db->exec("insert into bug53551 set `count` = 1 "); 24 $db->exec("SET sql_mode = 'Traditional'"); 47 $db->exec('DROP TABLE IF EXISTS bug53551');
|
H A D | bug78152.phpt | 2 Bug #78152: PDO::exec() - Bad error handling with multiple commands 16 var_dump($db->exec("INSERT INTO test(id, label) VALUES (41, 'x'); INSERT INTO test_bad(id, label) V… 19 …var_dump($db->exec("INSERT INTO test(id, label) VALUES (42, 'x'); INSERT INTO test_bad(id, label) … 31 Warning: PDO::exec(): SQLSTATE[42S02]: Base table or view not found: 1146 Table '%s.test_bad' doesn…
|
/PHP-8.0/ext/sqlite3/tests/ |
H A D | sqlite3_18_changes.phpt | 12 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); 15 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')")); 16 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); 19 var_dump($db->exec("UPDATE test SET id = 'c'"));
|
H A D | bug45798.phpt | 10 $db->exec('CREATE TABLE test (time INTEGER, id STRING)'); 12 $db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'a')"); 13 $db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'b')");
|
H A D | gh9032.phpt | 14 $db->exec('attach database \':memory:\' AS "db1"'); 15 var_dump($db->exec('create table db1.r (id int)')); 21 var_dump($db->exec('create table db2.r (id int)'));
|
/PHP-8.0/ext/pdo_firebird/tests/ |
H A D | bug_72583.phpt | 11 @$dbh->exec('drop table atable'); 12 $dbh->exec('create table atable (aint integer, asmi smallint)'); 13 $dbh->exec('insert into atable values (1, -1)');
|
H A D | bug_53280.phpt | 13 @$dbh->exec('DROP TABLE testz'); 14 $dbh->exec('CREATE TABLE testz(A VARCHAR(30), B VARCHAR(30), C VARCHAR(30))'); 15 $dbh->exec("INSERT INTO testz VALUES ('A', 'B', 'C')"); 35 $dbh->exec('DROP TABLE testz');
|
H A D | execute.phpt | 16 @$dbh->exec('DROP TABLE ddl'); 17 $dbh->exec("CREATE TABLE ddl (id SMALLINT NOT NULL PRIMARY KEY, text VARCHAR(32), 19 $dbh->exec("INSERT INTO ddl (id,text) VALUES (1,'bla')"); 37 var_dump($dbh->exec("UPDATE ddl SET id=2 WHERE CURRENT OF c"));
|
/PHP-8.0/ext/standard/tests/general_functions/ |
H A D | bug50732.phpt | 2 Bug #50732 (exec() adds single byte twice to $output array) 5 exec("echo x", $output);
|
/PHP-8.0/ext/pdo_oci/tests/ |
H A D | pecl_bug_6364.phpt | 16 @$dbh->exec ("drop table bug_6364_t"); 18 $dbh->exec ("create table bug_6364_t (c1 varchar2(10), c2 varchar2(10), c3 varchar2(10), c4 varchar… 20 $dbh->exec ("create or replace procedure bug_6364_sp(p1 IN varchar2, p2 IN varchar2, p3 IN varchar2… 42 $dbh->exec ("drop procedure bug_6364_sp"); 43 $dbh->exec ("drop table bug_6364_t");
|
/PHP-8.0/ext/pdo_sqlite/tests/ |
H A D | gh9032.phpt | 13 $db->exec('attach database \':memory:\' AS "db1"'); 14 var_dump($db->exec('create table db1.r (id int)')); 19 var_dump($db->exec('create table db2.r (id int)'));
|
/PHP-8.0/ext/pdo_pgsql/tests/ |
H A D | getnotify.phpt | 24 $db->exec("LISTEN notifies_phpt"); 29 $db->exec("NOTIFY notifies_phpt"); 37 $db->exec("NOTIFY notifies_phpt"); 44 $db->exec("NOTIFY notifies_phpt"); 51 $db->exec("NOTIFY notifies_phpt"); 58 $db->exec("NOTIFY notifies_phpt"); 78 $db->exec("NOTIFY notifies_phpt");
|