Home
last modified time | relevance | path

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

1234567891011

/PHP-5.5/ext/sybase_ct/tests/
H A Dbug22403.phpt38 var_dump(sybase_select_ex($db, 'exec '.$sp_name));
39 var_dump(sybase_select_ex($db, 'exec '.$sp_name.' "foo"'));
40 var_dump(sybase_select_ex($db, 'exec does_not_exist'));
43 var_dump(sybase_select_ex($db, 'exec '.$sp_name.' NULL'));
44 var_dump(sybase_select_ex($db, 'exec '.$sp_name.' 1'));
55 >>> Query: exec %s
60 >>> Query: exec %s "foo"
65 >>> Query: exec does_not_exist
70 >>> Query: exec %s NULL
79 >>> Query: exec %s 1
/PHP-5.5/ext/pdo_mysql/tests/
H A Dpdo_mysql_subclass.phpt28 public function exec() {
30 return call_user_func_array(array($this, 'parent::exec'), func_get_args());
60 $db->exec('DROP TABLE IF EXISTS test');
61 $db->exec('CREATE TABLE test(id INT)');
62 $db->exec('INSERT INTO test(id) VALUES (1), (2)');
74 $db->exec('DROP TABLE IF EXISTS test');
81 $db->exec('DROP TABLE IF EXISTS test');
85 exec('DROP TABLE IF EXISTS test')
86 exec('CREATE TABLE test(id INT)')
87 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 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 Dbug_42499.phpt2 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 Dbug_44454.phpt20 $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 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-5.5/ext/pdo_firebird/tests/
H A Dddl.phpt14 $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 Dbug_48877.phpt13 @$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 Dbug_64037.phpt14 @$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 DrowCount.phpt13 @$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-5.5/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 Dpdo_001.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_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')");
/PHP-5.5/ext/pdo_oci/tests/
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-5.5/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 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
H A Dsqlite3_exec_wrongparams.phpt2 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 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_18_changes.phpt12 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'"));
/PHP-5.5/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-5.5/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-5.5/ext/standard/tests/file/
H A Dbug26615.phpt2 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…

Completed in 32 milliseconds

1234567891011