Home
last modified time | relevance | path

Searched refs:db (Results 126 – 150 of 777) sorted by relevance

12345678910>>...32

/PHP-7.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_stmt_rowcount.phpt12 $db = MySQLPDOTest::factory();
13 MySQLPDOTest::createTestTable($db);
17 if (0 !== ($tmp = $db->query('SELECT id FROM test WHERE 1 = 0')->rowCount()))
20 if (1 !== ($tmp = $db->query('SELECT id FROM test WHERE id = 1')->rowCount()))
25 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
H A Dpdo_mysql_stmt_blobfromsteam.phpt55 $db->exec('DROP TABLE IF EXISTS test');
57 $db->exec($sql);
77 var_export($db->errorInfo(), true));
97 $db->exec('DELETE FROM test');
116 $db = MySQLPDOTest::factory();
124 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
125 blob_from_stream(10, $db, $file, $blob);
129 blob_from_stream(30, $db, $file, $blob);
133 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
141 $db = MySQLPDOTest::factory();
[all …]
H A Dpecl_bug_5802.phpt13 $db = PDOTest::test_factory(__DIR__. '/common.phpt');
15 $db->exec('create table test ( bar char(3) NULL )');
16 $stmt = $db->prepare('insert into test (bar) values(:bar)') or var_dump($db->errorInfo());
30 $stmt = $db->prepare('select * from test') or var_dump($db->errorInfo());
40 $db = MySQLPDOTest::factory();
41 $db->exec('DROP TABLE IF EXISTS test');
H A Dpdo_mysql_stmt_fetch_non_select.phpt12 $db = MySQLPDOTest::factory();
13 MySQLPDOTest::createTestTable($db);
18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
39 if (!is_object($stmt = $db->query('SHOW ENGINES')))
75 $db->exec('DEALLOCATE PREPARE mystmt');
81 var_export($db->errorInfo(), true));
109 $db->exec('DEALLOCATE PREPARE mystmt');
115 var_export($db->errorInfo(), true));
142 $db->exec('DEALLOCATE PREPARE mystmt');
148 var_export($db->errorInfo(), true));
[all …]
H A Dpdo_mysql_subclass.phpt53 $db = new MyPDO(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS);
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)');
57 $stmt = $db->query('SELECT * FROM test ORDER BY id ASC');
60 $db->intercept_call();
65 $e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
68 $db->exec('DROP TABLE IF EXISTS test');
74 $db = MySQLPDOTest::factory();
75 $db->exec('DROP TABLE IF EXISTS test');
H A Dpdo_mysql_attr_client_version.phpt8 $db = MySQLPDOTest::factory();
13 $db = MySQLPDOTest::factory();
15 assert(('' == $db->errorCode()) || ('00000' == $db->errorCode()));
17 $version = $db->getAttribute(PDO::ATTR_CLIENT_VERSION);
27 if (false !== $db->setAttribute(PDO::ATTR_CLIENT_VERSION, '1.0'))
30 $new_version = $db->getAttribute(PDO::ATTR_CLIENT_VERSION);
/PHP-7.4/ext/pgsql/tests/
H A D12pg_insert_9.phpt14 $db = pg_connect($conn_str);
15 pg_query($db, "SET standard_conforming_strings = 0");
19 pg_insert($db, $table_name, $fields) or print "Error in test 1\n";
20 echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING)."\n";
21 echo pg_insert($db, $table_name, $fields, PGSQL_DML_STRING|PGSQL_DML_ESCAPE)."\n";
22 var_dump( pg_insert($db, $table_name, $fields, PGSQL_DML_EXEC) ); // Return resource
H A D06copy.phpt10 $db = pg_connect($conn_str);
12 $rows = pg_copy_to($db, $table_name);
14 pg_query($db, "DELETE FROM $table_name");
16 pg_copy_from($db, $table_name, $rows);
H A D21pg_get_notify.phpt11 $db = pg_connect($conn_str);
12 pg_query($db, 'LISTEN test_msg');
13 pg_query($db, 'NOTIFY test_msg');
15 $msg = pg_get_notify($db);
/PHP-7.4/ext/sqlite3/tests/
H A Dsqlite3_24_last_insert_rowid.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->lastInsertRowID());
17 var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')"));
18 var_dump($db->lastInsertRowID());
21 var_dump($db->close());
H A Dsqlite3_39_toggleExtended.phpt10 $db->query("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )");
13 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
14 echo "First Error Code: " . $db->lastErrorCode() . PHP_EOL;
17 $result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
18 echo "Second Error Code: " . $db->lastErrorCode() . PHP_EOL;
21 $db->enableExtendedResultCodes(true);
22 $result = $db->query("INSERT INTO DOG VALUES (1, 'Annoying Dog', 1)");
23 echo "Third (Extended) Error Code: " . $db->lastErrorCode() . PHP_EOL;
26 var_dump($db->close());
H A Dbug53463.phpt8 $db = new SQLite3(':memory:');
10 $db->exec('CREATE TABLE test (whatever INTEGER)');
11 $db->exec('INSERT INTO test (whatever) VALUES (1)');
13 $result = $db->query('SELECT * FROM test');
22 $db->close();
/PHP-7.4/ext/pdo_pgsql/tests/
H A Dbug70313.phpt13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
18 $stmt = $db->prepare(");");
25 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
27 $stmt = $db->prepare(");");
H A Dcopy_to.phpt13 $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
15 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
19 $db->beginTransaction();
34 $db->commit();
37 var_dump($db->pgsqlCopyToArray('test'));
39 var_dump($db->pgsqlCopyToArray('test',";","NULL"));
41 var_dump($db->pgsqlCopyToArray('test',";","NULL",'a,c'));
45 var_dump($db->pgsqlCopyToArray('test_error'));
53 var_dump($db->pgsqlCopyToFile('test',$filename));
[all …]
/PHP-7.4/ext/pdo_sqlite/tests/
H A Dbug70862.phpt8 $db = new PDO('sqlite::memory:');
9 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
11 $db->exec('CREATE TABLE test(field BLOB)');
13 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
14 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
26 $stmt = $db->prepare('INSERT INTO test(field) VALUES (:para)');
H A Dpdo_sqlite_extendederror_attr.phpt9 $db = new PDO('sqlite::memory:');
11 $db->exec("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )");
14 $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
15 $errorInfo = $db->errorInfo();
19 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
20 $errorInfo = $db->errorInfo();
27 $db->exec("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )");
30 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
31 $errorInfo = $db->errorInfo();
35 $result = $db->exec("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
[all …]
/PHP-7.4/ext/pdo/tests/
H A Dpdo_033.phpt16 $db = PDOTest::factory();
20 $quoted = $db->quote($unquoted);
24 @$db->exec("DROP TABLE test");
26 $db->query("CREATE TABLE test (t char($len))");
27 $db->query("INSERT INTO test (t) VALUES($quoted)");
29 $stmt = $db->prepare('SELECT * from test');
34 $db->exec("DROP TABLE test");
H A Dpdo_019.phpt15 $db = PDOTest::factory();
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\')');
24 var_dump($db->query('SELECT COUNT(*) FROM test')->fetchColumn());
26 $stmt = $db->prepare('SELECT idx, txt FROM test ORDER by idx');
H A Dbug_71885.phpt17 $db = PDOTest::factory();
18 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
20 $db->exec("CREATE TABLE test (a int)");
25 $db->exec($sql);
31 $stmt = $db->prepare($sql);
37 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
38 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
42 $stmt = $db->prepare($sql);
H A Dpdo_009.phpt15 $db = PDOTest::factory();
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\')');
[all …]
/PHP-7.4/ext/mysqli/tests/
H A Dbug38710.phpt12 $db = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
13 $qry=$db->stmt_init();
18 …at('a', ($IS_MYSQLND || mysqli_get_server_version($db) > 50110)? 100000:(mysqli_get_server_version…
H A Dmysqli_change_user_old.phpt9 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
11 $host, $user, $db, $port, $socket));
23 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
25 $host, $user, $db, $port, $socket);
42 $host, $user, $db, $port, $socket);
54 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db)))
64 if ($tmp['dbname'] != $db)
78 $host, $user, $db, $port, $socket);
88 $host, $user, $db, $port, $socket);
92 (empty db = no db send with COM_CHANGE_USER) */
[all …]
/PHP-7.4/ext/dba/
H A Dconfig.m4378 if test -f "$i/db5/db.h"; then
380 THIS_INCLUDE=$i/db5/db.h
384 THIS_INCLUDE=$i/db4/db.h
428 THIS_INCLUDE=$i/include/db.h
432 …PHP_DBA_DB_CHECK(4, db-5.3 db-5.1 db-5.0 db-4.8 db-4.7 db-4.6 db-4.5 db-4.4 db-4.3 db-4.2 db-4.1 d…
465 …PHP_DBA_DB_CHECK(3, db-3.3 db-3.2 db-3.1 db-3.0 db-3 db3 db, [(void)db_create((DB**)0, (DB_ENV*)0,…
478 THIS_INCLUDE=$i/db2/db.h
498 PHP_DBA_DB_CHECK(2, db-2 db2 db, [(void)db_appinit("", NULL, (DB_ENV*)0, 0)])
520 for i in db$THIS_VERSION/db_185.h include/db$THIS_VERSION/db_185.h include/db/db_185.h; do
531 THIS_INCLUDE=$i/db1/db.h
[all …]
/PHP-7.4/ext/pdo_oci/tests/
H A Dpdo_oci_templob_1.phpt26 $stmt= $db->prepare($clobquery1);
29 $stmt= $db->prepare($clobquery2);
32 $stmt= $db->prepare($clobquery3);
35 $stmt= $db->prepare($clobquery4);
38 $stmt= $db->prepare($clobquery5);
41 $stmt= $db->prepare($clobquery6);
44 $stmt= $db->prepare($clobquery7);
47 $stmt= $db->prepare($clobquery8);
50 $stmt= $db->prepare($clobquery9);
59 $stmt1 = $db->prepare($query1);
[all …]
/PHP-7.4/ext/dba/tests/
H A Dbug71514.phpt12 $db = dba_open($filename, 'c', 'inifile');
14 dba_insert('foo', 'value1', $db);
15 dba_replace('foo', 'value2', $db);
16 var_dump(dba_fetch('foo', $db));
18 dba_close($db);

Completed in 35 milliseconds

12345678910>>...32