Home
last modified time | relevance | path

Searched refs:PDO (Results 51 – 75 of 269) sorted by relevance

1234567891011

/PHP-5.4/ext/pdo_mysql/tests/
H A Dpdo_mysql_attr_prefetch.phpt2 PDO::ATTR_PREFETCH
14 var_dump($db->getAttribute(PDO::ATTR_PREFETCH));
15 var_dump($db->setAttribute(PDO::ATTR_PREFETCH, true));
18 Warning: PDO::getAttribute(): SQLSTATE[IM001]: Driver does not support this function: driver does n…
H A Dbug_44454.phpt32 printf("... PDO - %s\n", var_export($db->errorInfo(), true));
52 printf("... PDO - %s\n", var_export($db->errorInfo(), true));
58 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
61 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
65 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
83 ... PDO - array (
91 ... PDO - array (
101 ... PDO - array (
109 ... PDO - array (
H A Dbug63176.phpt2 Bug #63176 (Segmentation fault when instantiate 2 persistent PDO to the same db server)
12 class PDO2 extends PDO {
16 class PDO3 extends PDO {
25 …$this->db = new PDO2(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS, array(PDO::ATTR…
27 …$this->db = new PDO3(PDO_MYSQL_TEST_DSN, PDO_MYSQL_TEST_USER, PDO_MYSQL_TEST_PASS, array(PDO::ATTR…
H A Dpdo_mysql_stmt_bindvalue.phpt32 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
40 while ($stmt->fetch(PDO::FETCH_BOUND))
62 while ($stmt->fetch(PDO::FETCH_BOUND))
86 while ($stmt->fetch(PDO::FETCH_BOUND))
115 while ($stmt->fetch(PDO::FETCH_BOUND))
145 while ($stmt->fetch(PDO::FETCH_BOUND))
180 while ($stmt->fetch(PDO::FETCH_BOUND))
202 while ($stmt->fetch(PDO::FETCH_BOUND))
226 while ($stmt->fetch(PDO::FETCH_BOUND))
255 while ($stmt->fetch(PDO::FETCH_BOUND))
[all …]
H A Dpdo_mysql_stmt_nextrowset.phpt26 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
41 $tmp = $stmt->fetch(PDO::FETCH_ASSOC);
49 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
60 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
70 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
77 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
78 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
86 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
88 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
93 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
[all …]
H A Dpdo_mysql_phpinfo.phpt2 MySQL PDO phpinfo() output
20 /* PDO Driver for MySQL, client library version => 6.0.3-alpha */
21 $reg = 'Client API version.*' . preg_quote($db->getAttribute(PDO::ATTR_CLIENT_VERSION), '/');
24 printf("[001] Cannot find MySQL PDO driver line in phpinfo() output\n");
H A Dpdo_mysql_prepare_native_mixed_style.phpt2 MySQL PDO->prepare(), native PS, mixed, wired style
16 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
17 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
25 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
35 Warning: PDO::prepare(): SQLSTATE[HY093]: Invalid parameter number: mixed named and positional para…
37 Warning: PDO::prepare(): SQLSTATE[HY093]: Invalid parameter number in %s on line %d
H A Dpdo_mysql_stmt_bindcolumn.phpt17 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
18 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
25 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
29 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
34 while ($stmt->fetch(PDO::FETCH_BOUND)) {
43 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
57 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
65 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
69 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
74 while ($stmt->fetch(PDO::FETCH_BOUND)) {
[all …]
H A Dbug_44707.phpt2 Bug #44707 (The MySQL PDO driver resets variable content after bindParam on tinyint field)
13 $row = $stmt->fetch(PDO::FETCH_ASSOC);
42 $stmt->bindParam(2, $mybool, PDO::PARAM_BOOL);
49 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
54 $stmt->bindParam(2, $mybool, PDO::PARAM_INT);
58 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
66 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
71 $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
H A Dpdo_mysql_attr_init_command.phpt2 PDO::MYSQL_ATTR_INIT_COMMAND
21 $db = new PDO($dsn, $user, $pass);
26 $db = new PDO($dsn, $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => $create));
33 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dpdo_mysql_prepare_native_column.phpt2 MySQL PDO->prepare(), native PS, named placeholder
16 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
17 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
22 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
27 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
H A Dpdo_mysql_prepare_native_dup_named_placeholder.phpt2 MySQL PDO->prepare(), native PS, named placeholder II
20 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
21 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
37 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
40 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 1);
41 if (1 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
56 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
73 var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
76 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
77 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
[all …]
H A Dpdo_mysql_stmt_closecursor_empty.phpt18 $db->setAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY, 0);
19 if (0 != $db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
22 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
34 if (!$stmt->bindColumn(1, $id, PDO::PARAM_INT))
38 if (!$stmt->bindColumn(2, $label, PDO::PARAM_STR))
42 while ($stmt->fetch(PDO::FETCH_BOUND))
50 while ($stmt->fetch(PDO::FETCH_BOUND))
/PHP-5.4/ext/pdo_oci/tests/
H A Dbug57702.phpt2 PDO OCI Bug #57702 (Multi-row BLOB fetches)
15 // Note the PDO test setup sets PDO::ATTR_STRINGIFY_FETCHES to true
16 // (and sets PDO::ATTR_CASE to PDO::CASE_LOWER)
31 $stmt->bindParam(':blob1', $blob1, PDO::PARAM_LOB);
32 $stmt->bindParam(':blob2', $blob2, PDO::PARAM_LOB);
54 $row = $stmt->fetch(PDO::FETCH_ASSOC);
57 $row = $stmt->fetch(PDO::FETCH_ASSOC);
77 $stmt->bindColumn('d3_1' , $clob1, PDO::PARAM_LOB);
78 $stmt->bindColumn('d3_2' , $clob2, PDO::PARAM_LOB);
80 while ($stmt->fetch(PDO::FETCH_BOUND)) {
[all …]
H A Dbug46274.phpt2 Bug #46274 (pdo_pgsql - Segfault when using PDO::ATTR_STRINGIFY_FETCHES and blob)
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
36 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
46 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
H A Dbug44301.phpt2 PDO OCI Bug #44301 (Segfault when an exception is thrown on persistent connections)
11 putenv("PDO_OCI_TEST_ATTR=" . serialize(array(PDO::ATTR_PERSISTENT => true)));
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
H A Dbug46274_2.phpt2 Bug #46274 (pdo_pgsql - Segfault when using PDO::ATTR_STRINGIFY_FETCHES and blob)
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
16 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
36 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
46 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
/PHP-5.4/ext/pdo/tests/
H A Dpdo_016.phpt2 PDO Common: PDO::FETCH_BOUND
18 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
19 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
35 $cont = $stmt2->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE);
44 while($stmt2->fetch(PDO::FETCH_BOUND)) {
66 var_dump($stmt3->fetch(PDO::FETCH_BOUND));
75 var_dump($stmt4->fetch(PDO::FETCH_BOUND));
88 var_dump($stmt3->fetch(PDO::FETCH_BOUND));
92 var_dump($stmt4->fetch(PDO::FETCH_BOUND));
103 while($stmt2->fetch(PDO::FETCH_BOUND))
H A Dpdo_016a.phpt2 PDO Common: PDO::FETCH_BOUND w/o :
18 if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
19 $db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
35 $cont = $stmt2->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE);
44 while($stmt2->fetch(PDO::FETCH_BOUND)) {
66 var_dump($stmt3->fetch(PDO::FETCH_BOUND));
75 var_dump($stmt4->fetch(PDO::FETCH_BOUND));
88 var_dump($stmt3->fetch(PDO::FETCH_BOUND));
92 var_dump($stmt4->fetch(PDO::FETCH_BOUND));
103 while($stmt2->fetch(PDO::FETCH_BOUND))
H A Dpdo_010.phpt2 PDO Common: PDO::FETCH_CLASSTYPE and GROUP/UNIQUE
55 var_dump($stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_CLASSTYPE|PDO::FETCH_GROUP, 'Test3'));
58 var_dump($stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_CLASSTYPE|PDO::FETCH_UNIQUE, 'Test3'));
H A Dbug_39656.phpt2 PDO Common: Bug #39656 (Crash when calling fetch() on a PDO statment object after closeCursor())
19 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
25 $stmt->bindValue(1, 1, PDO::PARAM_INT );
H A Dpdo_030.phpt2 PDO Common: extending PDO (4)
29 $this->setFetchMode(PDO::FETCH_ASSOC);
45 class PDODatabase extends PDO
74 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS));
75 $db->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('PDOStatementx', array($db)));
76 var_dump($db->getAttribute(PDO::ATTR_STATEMENT_CLASS));
/PHP-5.4/ext/pdo_pgsql/tests/
H A Dbug62479.phpt2 PDO PgSQL Bug #62479 (PDO-psql cannot connect if password contains spaces)
14 $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
30 $testConn = new PDO($dsn, $user, $pass);
42 $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
52 $testConn = new PDO($conf['ENV']['PDOTEST_DSN'], $user, "my password");
64 $testConn = new PDO($conf['ENV']['PDOTEST_DSN'], $user, "my pass'word");
H A Dbug46274.phpt2 Bug #46274 (pdo_pgsql - Segfault when using PDO::ATTR_STRINGIFY_FETCHES and blob)
15 $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
31 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
35 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
43 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
47 $stmt->bindparam(':foo', $blob, PDO::PARAM_LOB);
/PHP-5.4/ext/pdo_sqlite/tests/
H A Dpdo_sqlite_get_attribute.phpt8 $pdo = new PDO('sqlite::memory:');
9 var_dump($pdo->getAttribute(PDO::ATTR_SERVER_VERSION));
10 var_dump($pdo->getAttribute(PDO::ATTR_CLIENT_VERSION));

Completed in 44 milliseconds

1234567891011