Home
last modified time | relevance | path

Searched refs:exec (Results 1 – 25 of 343) sorted by relevance

12345678910>>...14

/PHP-8.1/ext/pdo_firebird/tests/
H A Dddl.phpt16 @$dbh->exec('DROP TABLE ddl');
17 @$dbh->exec('DROP GENERATOR gen_ddl_id');
18 @$dbh->exec('DROP TRIGGER ddl_bi');
20 $dbh->exec("CREATE TABLE ddl (id INT NOT NULL PRIMARY KEY, text BLOB SUB_TYPE 1)");
21 $dbh->exec("CREATE GENERATOR gen_ddl_id");
22 $dbh->exec("CREATE TRIGGER ddl_bi FOR ddl BEFORE INSERT AS
28 var_dump($dbh->exec("INSERT INTO ddl (text) VALUES ('bla')"));
29 var_dump($dbh->exec("UPDATE ddl SET text='blabla'"));
33 var_dump($dbh->exec("DELETE FROM ddl"));
H A Dbug_48877.phpt17 @$dbh->exec('DROP TABLE testz');
18 $dbh->exec('CREATE TABLE testz (A integer)');
19 $dbh->exec("INSERT INTO testz VALUES ('1')");
20 $dbh->exec("INSERT INTO testz VALUES ('2')");
21 $dbh->exec("INSERT INTO testz VALUES ('3')");
39 $dbh->exec('DROP TABLE testz');
H A Dbug_64037.phpt15 @$dbh->exec('DROP TABLE price');
16 $dbh->exec("CREATE TABLE PRICE (ID INTEGER NOT NULL, TEXT VARCHAR(10), COST NUMERIC(15, 2))");
17 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (1, 'test', -1.0)");
18 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (2, 'test', -0.99)");
19 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (3, 'test', -1.01)");
37 $dbh->exec('DROP TABLE price');
H A DrowCount.phpt15 @$dbh->exec('DROP TABLE testz');
16 $dbh->exec('CREATE TABLE testz (A VARCHAR(10))');
17 $dbh->exec("INSERT INTO testz VALUES ('A')");
18 $dbh->exec("INSERT INTO testz VALUES ('A')");
19 $dbh->exec("INSERT INTO testz VALUES ('B')");
42 $dbh->exec('DROP TABLE testz');
H A Dbug_74462.phpt13 $dbh->exec('recreate table atable (id integer not null, abool boolean)');
14 $dbh->exec('insert into atable (id, abool) values (1, true)');
15 $dbh->exec('insert into atable (id, abool) values (2, false)');
16 $dbh->exec('insert into atable (id, abool) values (3, null)');
/PHP-8.1/ext/pdo_mysql/tests/
H A Dpdo_mysql_subclass.phpt23 public function exec($statement): int|false {
25 return parent::exec($statement);
56 $db->exec('DROP TABLE IF EXISTS test');
57 $db->exec('CREATE TABLE test(id INT)');
58 $db->exec('INSERT INTO test(id) VALUES (1), (2)');
70 $db->exec('DROP TABLE IF EXISTS test');
77 $db->exec('DROP TABLE IF EXISTS test');
81 exec('DROP TABLE IF EXISTS test')
82 exec('CREATE TABLE test(id INT)')
83 exec('INSERT INTO test(id) VALUES (1), (2)')
[all …]
H A Dpdo_mysql_exec_ddl.phpt2 MySQL PDO->exec(), affected rows
17 $ret = @$db->exec($sql);
19 $ret = $db->exec($sql);
44 @$db->exec('DROP DATABASE IF EXISTS pdo_exec_ddl');
45 @$db->exec('DROP DATABASE IF EXISTS pdo_exec_ddl2');
46 if (1 === @$db->exec('CREATE DATABASE pdo_exec_ddl')) {
53 if (0 === $db->exec('CREATE TABLE pdo_exec_ddl(id INT, col1 CHAR(2))')) {
87 @$db->exec('DROP TABLE IF EXISTS pdo_exec_ddl');
88 @$db->exec('DROP TABLE IF EXISTS pdo_exec_ddl2');
89 @$db->exec('DROP DATABASE IF EXISTS pdo_exec_ddl');
[all …]
H A Dpecl_bug_5780.phpt17 $db->exec("CREATE TABLE test (login varchar(32) NOT NULL, data varchar(64) NOT NULL)");
18 $db->exec("CREATE TABLE test2 (login varchar(32) NOT NULL, password varchar(64) NOT NULL)");
19 $db->exec("INSERT INTO test2 (login, password) VALUES ('testing', 'testing')");
20 $db->exec("INSERT INTO test2 (login, password) VALUES ('test2', 'testpw2')");
35 $db->exec('DROP TABLE IF EXISTS test');
36 $db->exec('DROP TABLE IF EXISTS test2');
H A Dbug_42499.phpt2 Bug #42499 (Multi-statement execution via PDO::exec() makes connection unusable)
30 $db->exec('DROP TABLE IF EXISTS test');
31 $db->exec("CREATE TABLE test(id CHAR(1)); INSERT INTO test(id) VALUES ('a')");
36 // You must not use exec() to run statements that create a result set!
37 $db->exec('SELECT id FROM test');
39 $db->exec("INSERT INTO test(id) VALUES ('b')");
56 $db->exec('DROP TABLE IF EXISTS test');
70 Warning: PDO::exec(): SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuf…
80 Warning: PDO::exec(): SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuf…
H A Dbug_44454.phpt22 $db->exec('DROP TABLE IF EXISTS test');
23 $db->exec('CREATE TABLE test(a INT, b INT, UNIQUE KEY idx_ab (a, b))');
24 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
31 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
38 $db->exec('DROP TABLE IF EXISTS test');
39 $db->exec('CREATE TABLE test(a INT, b INT, UNIQUE KEY idx_ab (a, b))');
40 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
51 $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
76 $db->exec('DROP TABLE IF EXISTS test');
H A Dpdo_mysql_last_insert_id.phpt25 $db->exec('DROP TABLE IF EXISTS test');
38 $db->exec("INSERT INTO test(id, col1) VALUES (100, 'a')");
42 $db->exec('ALTER TABLE test MODIFY id INT AUTO_INCREMENT PRIMARY KEY');
47 @$db->exec("INSERT INTO test(id, col1) VALUES (100, 'a')");
51 $db->exec("INSERT INTO test(id, col1) VALUES (101, 'b')");
55 $db->exec('ALTER TABLE test MODIFY col1 CHAR(10) UNIQUE');
57 $db->exec("REPLACE INTO test(col1) VALUES ('b')");
71 $db->exec("INSERT INTO test(col1) VALUES ('c'), ('d'), ('e')");
80 $db->exec('LOCK TABLE test WRITE');
95 $db->exec("INSERT INTO test(col1) VALUES ('z')");
[all …]
H A Dbug80458.phpt46 $db->exec('DROP PROCEDURE IF EXISTS nores');
47 $db->exec('CREATE PROCEDURE nores() BEGIN DELETE FROM test WHERE first=6; END;');
51 $db->exec('DROP PROCEDURE IF EXISTS nores');
53 $db->exec('DROP PROCEDURE IF EXISTS ret');
54 $db->exec('CREATE PROCEDURE ret() BEGIN SELECT first FROM test WHERE first=7; END;');
60 $db->exec('DROP PROCEDURE IF EXISTS ret');
87 $db->exec('DROP PROCEDURE IF EXISTS nores');
88 $db->exec('CREATE PROCEDURE nores() BEGIN DELETE FROM test WHERE first=13; END;');
92 $db->exec('DROP PROCEDURE IF EXISTS nores');
94 $db->exec('DROP PROCEDURE IF EXISTS ret');
[all …]
H A Dpdo_mysql_inTransaction.phpt21 foreach (['exec', 'query', 'execute'] as $w) {
24 case 'exec':
25 $db->exec($command);
48 $db->exec($end);
52 $db->exec('START TRANSACTION');
56 $db->exec('START TRANSACTION');
65 $db->exec('DROP TABLE IF EXISTS test');
H A Dtable.inc6 // $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-8.1/ext/pdo/tests/
H A Dpdo_009.phpt18 $db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) NOT NULL UNIQUE)');
19 $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')');
20 $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')');
21 $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')');
22 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10))');
23 $db->exec('INSERT INTO test VALUES(1, 0, \'A\')');
24 $db->exec('INSERT INTO test VALUES(2, 1, \'B\')');
25 $db->exec('INSERT INTO test VALUES(3, 2, \'C\')');
26 $db->exec('INSERT INTO test VALUES(4, 3, \'D\')');
H A Dbug_64172.phpt19 @$db->exec("DROP TABLE test");
20 $db->exec("CREATE TABLE test (x int)");
21 $db->exec("INSERT INTO test VALUES (1)");
37 $db->exec("INSERT INTO bad_table VALUES(1)");
44 $db->exec("INSERT INTO test VALUES (2)");
47 $db->exec("DROP TABLE test");
69 Warning: PDO::exec(): SQLSTATE[%s]: %s
H A Dpdo_010.phpt18 $db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) NOT NULL UNIQUE)');
19 $db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')');
20 $db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')');
21 $db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')');
22 $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10), grp VARCH…
23 $db->exec('INSERT INTO test VALUES(1, 0, \'A\', \'Group1\')');
24 $db->exec('INSERT INTO test VALUES(2, 1, \'B\', \'Group1\')');
25 $db->exec('INSERT INTO test VALUES(3, 2, \'C\', \'Group2\')');
26 $db->exec('INSERT INTO test VALUES(4, 3, \'D\', \'Group2\')');
/PHP-8.1/ext/pdo_oci/tests/
H A Dbug54379.phpt19 $db->exec("DROP TABLE test");
22 $db->exec("CREATE TABLE test (col1 NVARCHAR2(20))");
23 $db->exec("INSERT INTO test VALUES('12345678901234567890')");
24 $db->exec("INSERT INTO test VALUES('あいうえおかきくけこさしすせそたちつてと')");
28 $db->exec("DROP TABLE test");
H A Dpdo_oci_attr_autocommit_2.phpt18 $dbh->exec("drop table pdo_ac_tab");
21 $dbh->exec("create table pdo_ac_tab (col1 varchar2(25))");
27 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 1')");
28 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 2')");
53 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 3')");
68 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 4')");
85 $dbh->exec("insert into pdo_ac_tab (col1) values ('not committed #2')");
86 $dbh->exec("rollback");
87 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 5')");
88 $dbh->exec("insert into pdo_ac_tab (col1) values ('data 6')");
[all …]
/PHP-8.1/ext/standard/tests/file/windows_links/
H A Dreadlink_compat.phpt10 exec('fltmc', $output, $exitCode);
21 $volume = trim(exec('mountvol C: /L'));
22 exec(sprintf('mountvol "%s" %s', $tmpDir, $volume));
24 exec(sprintf('mountvol "%s" /D', $tmpDir));
31 exec(sprintf('mklink /J "%s" %s', $link, $volume));
38 exec(sprintf('mklink /J "%s" "%s"', $link, $target));
45 exec(sprintf('mklink /D "%s" "%s"', $link, $target));
48 exec(sprintf('mklink /D "%s" directory', $link));
59 exec(sprintf('mklink "%s" "%s"', $link, $filename));
62 exec(sprintf('mklink "%s" directory\\a.php', $link));
/PHP-8.1/ext/sqlite3/tests/
H A Dsqlite3_25_create_aggregate.phpt25 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 Dbug68760.phpt13 $db->exec("CREATE TABLE test (col1 string)");
14 $db->exec("INSERT INTO test VALUES ('a1')");
15 $db->exec("INSERT INTO test VALUES ('a10')");
16 $db->exec("INSERT INTO test VALUES ('a2')");
H A Dsqlite3_02_create.phpt11 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-8.1/ext/standard/tests/file/windows_acls/
H A Dcommon.inc34 $user = exec('echo %USERNAME%');
49 $sysroot = exec('echo %SYSTEMROOT%');
77 exec($cmd);
86 exec($cmd);
88 exec($cmd);
101 exec($cmd);
109 exec($cmd);
111 exec($cmd);
126 exec($cmd);
128 exec($cmd);
[all …]
/PHP-8.1/ext/standard/tests/general_functions/
H A Dbug49847.phpt2 Bug #49847 (exec() fails on lines larger then 4095 bytes)
12 exec('type ' . $f, $output);
14 exec("printf %4098d 1", $output);

Completed in 29 milliseconds

12345678910>>...14