Home
last modified time | relevance | path

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

12345678910>>...13

/PHP-7.4/ext/pdo_firebird/tests/
H A Dddl.phpt14 @$dbh->exec('DROP TABLE ddl');
15 @$dbh->exec('DROP GENERATOR gen_ddl_id');
16 @$dbh->exec('DROP TRIGGER ddl_bi');
18 $dbh->exec("CREATE TABLE ddl (id INT NOT NULL PRIMARY KEY, text BLOB SUB_TYPE 1)");
19 $dbh->exec("CREATE GENERATOR gen_ddl_id");
20 $dbh->exec("CREATE TRIGGER ddl_bi FOR ddl BEFORE INSERT AS
26 var_dump($dbh->exec("INSERT INTO ddl (text) VALUES ('bla')"));
27 var_dump($dbh->exec("UPDATE ddl SET text='blabla'"));
31 var_dump($dbh->exec("DELETE FROM ddl"));
H A Dbug_48877.phpt14 @$dbh->exec('DROP TABLE testz');
15 $dbh->exec('CREATE TABLE testz (A integer)');
16 $dbh->exec("INSERT INTO testz VALUES ('1')");
17 $dbh->exec("INSERT INTO testz VALUES ('2')");
18 $dbh->exec("INSERT INTO testz VALUES ('3')");
36 $dbh->exec('DROP TABLE testz');
H A Dbug_64037.phpt13 @$dbh->exec('DROP TABLE price');
14 $dbh->exec("CREATE TABLE PRICE (ID INTEGER NOT NULL, TEXT VARCHAR(10), COST NUMERIC(15, 2))");
15 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (1, 'test', -1.0)");
16 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (2, 'test', -0.99)");
17 $dbh->exec("INSERT INTO PRICE (ID, TEXT, COST) VALUES (3, 'test', -1.01)");
35 $dbh->exec('DROP TABLE price');
H A DrowCount.phpt12 @$dbh->exec('DROP TABLE testz');
13 $dbh->exec('CREATE TABLE testz (A VARCHAR(10))');
14 $dbh->exec("INSERT INTO testz VALUES ('A')");
15 $dbh->exec("INSERT INTO testz VALUES ('A')");
16 $dbh->exec("INSERT INTO testz VALUES ('B')");
39 $dbh->exec('DROP TABLE testz');
H A Dbug_74462.phpt11 @$dbh->exec('drop table atable');
12 $dbh->exec('create table atable (id integer not null, abool boolean)');
13 $dbh->exec('insert into atable (id, abool) values (1, true)');
14 $dbh->exec('insert into atable (id, abool) values (2, false)');
15 $dbh->exec('insert into atable (id, abool) values (3, null)');
/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_subclass.phpt22 public function exec($statement) {
24 return parent::exec($statement);
54 $db->exec('DROP TABLE IF EXISTS test');
55 $db->exec('CREATE TABLE test(id INT)');
56 $db->exec('INSERT INTO test(id) VALUES (1), (2)');
68 $db->exec('DROP TABLE IF EXISTS test');
75 $db->exec('DROP TABLE IF EXISTS test');
79 exec('DROP TABLE IF EXISTS test')
80 exec('CREATE TABLE test(id INT)')
81 exec('INSERT INTO test(id) VALUES (1), (2)')
[all …]
H A Dpdo_mysql_exec_ddl.phpt2 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 Dpecl_bug_5780.phpt15 $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 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,…
H A Dpdo_mysql_last_insert_id.phpt24 $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 Dbug80458.phpt44 $db->exec('DROP PROCEDURE IF EXISTS nores');
45 $db->exec('CREATE PROCEDURE nores() BEGIN DELETE FROM test WHERE first=6; END;');
49 $db->exec('DROP PROCEDURE IF EXISTS nores');
51 $db->exec('DROP PROCEDURE IF EXISTS ret');
52 $db->exec('CREATE PROCEDURE ret() BEGIN SELECT first FROM test WHERE first=7; END;');
58 $db->exec('DROP PROCEDURE IF EXISTS ret');
85 $db->exec('DROP PROCEDURE IF EXISTS nores');
86 $db->exec('CREATE PROCEDURE nores() BEGIN DELETE FROM test WHERE first=13; END;');
90 $db->exec('DROP PROCEDURE IF EXISTS nores');
92 $db->exec('DROP PROCEDURE IF EXISTS ret');
[all …]
/PHP-7.4/ext/pdo/tests/
H A Dpdo_009.phpt17 $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 Dpdo_010.phpt17 $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 Dbug_64172.phpt18 @$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 Dpdo_002.phpt17 $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 Dpdo_019.phpt17 $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\')');
/PHP-7.4/ext/pdo_oci/tests/
H A Dbug54379.phpt18 $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");
H A Dpdo_oci_attr_autocommit_2.phpt16 $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 …]
/PHP-7.4/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.phpt15 $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 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-7.4/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-7.4/ext/standard/tests/file/windows_acls/
H A Dcommon.inc29 $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.4/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);
/PHP-7.4/ext/standard/tests/file/
H A Dbug26615.phpt2 Bug #26615 (exec crash on long input lines)
10exec($_ENV['TEST_PHP_EXECUTABLE'].' -n -r \'for($i=1;$i<=5000;$i++) print "$i\n";\' | tr \'\n\' \'…
12exec($_ENV['TEST_PHP_EXECUTABLE'].' -n -r "for($i=1;$i<=5000;$i++) echo $i,\' \';"', $out, $status…

Completed in 35 milliseconds

12345678910>>...13