/PHP-7.2/ext/pdo_mysql/tests/ |
H A D | pdo_mysql_subclass.phpt | 26 public function exec() { 28 return call_user_func_array(array($this, 'parent::exec'), func_get_args()); 58 $db->exec('DROP TABLE IF EXISTS test'); 59 $db->exec('CREATE TABLE test(id INT)'); 60 $db->exec('INSERT INTO test(id) VALUES (1), (2)'); 72 $db->exec('DROP TABLE IF EXISTS test'); 79 $db->exec('DROP TABLE IF EXISTS test'); 83 exec('DROP TABLE IF EXISTS test') 84 exec('CREATE TABLE test(id INT)') 85 exec('INSERT INTO test(id) VALUES (1), (2)') [all …]
|
H A D | pdo_mysql_exec_ddl.phpt | 2 MySQL PDO->exec(), affected rows 16 $ret = @$db->exec($sql); 18 $ret = $db->exec($sql); 43 @$db->exec('DROP DATABASE IF EXISTS pdo_exec_ddl'); 44 @$db->exec('DROP DATABASE IF EXISTS pdo_exec_ddl2'); 45 if (1 === @$db->exec('CREATE DATABASE pdo_exec_ddl')) { 52 if (0 === $db->exec('CREATE TABLE pdo_exec_ddl(id INT, col1 CHAR(2))')) { 86 @$db->exec('DROP TABLE IF EXISTS pdo_exec_ddl'); 87 @$db->exec('DROP TABLE IF EXISTS pdo_exec_ddl2'); 88 @$db->exec('DROP DATABASE IF EXISTS pdo_exec_ddl'); [all …]
|
H A D | pecl_bug_5780.phpt | 15 $db->exec("CREATE TABLE test (login varchar(32) NOT NULL, data varchar(64) NOT NULL)"); 16 $db->exec("CREATE TABLE test2 (login varchar(32) NOT NULL, password varchar(64) NOT NULL)"); 17 $db->exec("INSERT INTO test2 (login, password) VALUES ('testing', 'testing')"); 18 $db->exec("INSERT INTO test2 (login, password) VALUES ('test2', 'testpw2')"); 33 $db->exec('DROP TABLE IF EXISTS test'); 34 $db->exec('DROP TABLE IF EXISTS test2');
|
H A D | pdo_mysql_last_insert_id.phpt | 24 $db->exec('DROP TABLE IF EXISTS test'); 37 $db->exec("INSERT INTO test(id, col1) VALUES (100, 'a')"); 41 $db->exec('ALTER TABLE test MODIFY id INT AUTO_INCREMENT PRIMARY KEY'); 46 @$db->exec("INSERT INTO test(id, col1) VALUES (100, 'a')"); 50 $db->exec("INSERT INTO test(id, col1) VALUES (101, 'b')"); 54 $db->exec('ALTER TABLE test MODIFY col1 CHAR(10) UNIQUE'); 56 $db->exec("REPLACE INTO test(col1) VALUES ('b')"); 70 $db->exec("INSERT INTO test(col1) VALUES ('c'), ('d'), ('e')"); 79 $db->exec('LOCK TABLE test WRITE'); 94 $db->exec("INSERT INTO test(col1) VALUES ('z')"); [all …]
|
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 | table.inc | 6 // $db->exec('DROP TABLE IF EXISTS test'); 7 $db->exec('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine); 8 $db->exec('INSERT INTO test(id, label) VALUES (1, "a"), (2, "b"), (3, "c"), (4, "d"), (5, "e"), (6,…
|
/PHP-7.2/ext/pdo_firebird/tests/ |
H A D | ddl.phpt | 14 $db->exec("CREATE TABLE ddl (id INT NOT NULL PRIMARY KEY, text BLOB SUB_TYPE 1)"); 15 $db->exec("CREATE GENERATOR gen_ddl_id"); 16 $db->exec("CREATE TRIGGER ddl_bi FOR ddl BEFORE INSERT AS 22 var_dump($db->exec("INSERT INTO ddl (text) VALUES ('bla')")); 23 var_dump($db->exec("UPDATE ddl SET text='blabla'")); 27 var_dump($db->exec("DELETE FROM ddl"));
|
H A D | bug_48877.phpt | 13 @$dbh->exec('DROP TABLE testz'); 14 $dbh->exec('CREATE TABLE testz (A integer)'); 15 $dbh->exec("INSERT INTO testz VALUES ('1')"); 16 $dbh->exec("INSERT INTO testz VALUES ('2')"); 17 $dbh->exec("INSERT INTO testz VALUES ('3')"); 35 $dbh->exec('DROP TABLE testz');
|
H A D | bug_64037.phpt | 14 @$dbh->exec('DROP TABLE price'); 15 $dbh->exec("CREATE TABLE PRICE (ID INTEGER NOT NULL, TEXT VARCHAR(10), COST NUMERIC(15, 2))"); 16 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (1, 'test', -1.0)"); 17 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (2, 'test', -0.99)"); 18 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (3, 'test', -1.01)"); 36 $dbh->exec('DROP TABLE price');
|
H A D | rowCount.phpt | 13 @$dbh->exec('DROP TABLE testz'); 14 $dbh->exec('CREATE TABLE testz (A VARCHAR(10))'); 15 $dbh->exec("INSERT INTO testz VALUES ('A')"); 16 $dbh->exec("INSERT INTO testz VALUES ('A')"); 17 $dbh->exec("INSERT INTO testz VALUES ('B')"); 40 $dbh->exec('DROP TABLE testz');
|
/PHP-7.2/ext/pdo/tests/ |
H A D | pdo_009.phpt | 17 $db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) NOT NULL UNIQUE)'); 18 $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')'); 19 $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')'); 20 $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')'); 21 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10))'); 22 $db->exec('INSERT INTO test VALUES(1, 0, \'A\')'); 23 $db->exec('INSERT INTO test VALUES(2, 1, \'B\')'); 24 $db->exec('INSERT INTO test VALUES(3, 2, \'C\')'); 25 $db->exec('INSERT INTO test VALUES(4, 3, \'D\')');
|
H A D | pdo_010.phpt | 17 $db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) NOT NULL UNIQUE)'); 18 $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')'); 19 $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')'); 20 $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')'); 21 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10), grp VARCH… 22 $db->exec('INSERT INTO test VALUES(1, 0, \'A\', \'Group1\')'); 23 $db->exec('INSERT INTO test VALUES(2, 1, \'B\', \'Group1\')'); 24 $db->exec('INSERT INTO test VALUES(3, 2, \'C\', \'Group2\')'); 25 $db->exec('INSERT INTO test VALUES(4, 3, \'D\', \'Group2\')');
|
H A D | bug_64172.phpt | 18 @$db->exec("DROP TABLE test"); 19 $db->exec("CREATE TABLE test (x int)"); 20 $db->exec("INSERT INTO test VALUES (1)"); 36 $db->exec("INSERT INTO bad_table VALUES(1)"); 43 $db->exec("INSERT INTO test VALUES (2)"); 46 $db->exec("DROP TABLE test"); 69 Warning: PDO::exec(): SQLSTATE[%s]: %s
|
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_002.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')");
|
/PHP-7.2/ext/pdo_oci/tests/ |
H A D | pdo_oci_attr_autocommit_2.phpt | 16 $dbh->exec("drop table pdo_ac_tab"); 19 $dbh->exec("create table pdo_ac_tab (col1 varchar2(25))"); 25 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 1')"); 26 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 2')"); 39 $dbh->exec("insert into pdo_ac_tab (col1) values ('not committed #1')"); 51 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 3')"); 66 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 4')"); 84 $dbh->exec("rollback"); 85 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 5')"); 86 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 6')"); [all …]
|
H A D | bug54379.phpt | 18 $db->exec("DROP TABLE test"); 21 $db->exec("CREATE TABLE test (col1 NVARCHAR2(20))"); 22 $db->exec("INSERT INTO test VALUES('12345678901234567890')"); 23 $db->exec("INSERT INTO test VALUES('あいうえおかきくけこさしすせそたちつてと')"); 27 $db->exec("DROP TABLE test");
|
/PHP-7.2/ext/sqlite3/tests/ |
H A D | sqlite3_25_create_aggregate.phpt | 25 var_dump($db->exec('CREATE TABLE test (a INTEGER, b INTEGER)')); 28 var_dump($db->exec("INSERT INTO test (a, b) VALUES (1, -1)")); 29 var_dump($db->exec("INSERT INTO test (a, b) VALUES (2, -2)")); 30 var_dump($db->exec("INSERT INTO test (a, b) VALUES (3, -3)")); 31 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)")); 32 var_dump($db->exec("INSERT INTO test (a, b) VALUES (4, -4)"));
|
H A D | sqlite3_exec_wrongparams.phpt | 2 SQLite3::exec test, testing for wrong type parameters 12 $db->exec(array ('a','b','c'), 20090509); 16 Warning: SQLite3::exec() expects exactly 1 parameter, 2 given in %s on line %d
|
H A D | bug68760.phpt | 15 $db->exec("CREATE TABLE test (col1 string)"); 16 $db->exec("INSERT INTO test VALUES ('a1')"); 17 $db->exec("INSERT INTO test VALUES ('a10')"); 18 $db->exec("INSERT INTO test VALUES ('a2')");
|
H A D | sqlite3_02_create.phpt | 11 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); 14 var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); 17 var_dump($db->exec('DROP TABLE test')); 28 Warning: SQLite3::exec(): table test already exists in %s on line %d
|
/PHP-7.2/ext/standard/tests/file/windows_acls/ |
H A D | common.inc | 29 $user = exec('echo %USERNAME%'); 44 $sysroot = exec('echo %SYSTEMROOT%'); 72 exec($cmd); 81 exec($cmd); 83 exec($cmd); 96 exec($cmd); 104 exec($cmd); 106 exec($cmd); 121 exec($cmd); 123 exec($cmd); [all …]
|
/PHP-7.2/ext/standard/tests/general_functions/ |
H A D | bug49847.phpt | 2 Bug #49847 (exec() fails on lines larger then 4095 bytes) 12 exec('type ' . $f, $output); 14 exec("printf %4098d 1", $output);
|
/PHP-7.2/ext/standard/tests/file/ |
H A D | bug26615.phpt | 2 Bug #26615 (exec crash on long input lines) 10 …exec($_ENV['TEST_PHP_EXECUTABLE'].' -n -r \'for($i=1;$i<=5000;$i++) print "$i\n";\' | tr \'\n\' \'… 12 …exec($_ENV['TEST_PHP_EXECUTABLE'].' -n -r "for($i=1;$i<=5000;$i++) echo $i,\' \';"', $out, $status…
|