xref: /PHP-8.1/ext/pdo/tests/pdo_039.phpt (revision 2db2cab6)
1--TEST--
2PDO Common: errorCode()
3--EXTENSIONS--
4pdo
5--SKIPIF--
6<?php
7$dir = getenv('REDIR_TEST_DIR');
8if (false == $dir) die('skip no driver');
9require_once $dir . 'pdo_test.inc';
10PDOTest::skip();
11?>
12--FILE--
13<?php
14if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.__DIR__ . '/../../pdo/tests/');
15
16$dsn = getenv('PDOTEST_DSN');
17$user = getenv('PDOTEST_USER');
18$pass = getenv('PDOTEST_PASS');
19$attr = getenv('PDOTEST_ATTR');
20if (is_string($attr) && strlen($attr)) {
21    $attr = unserialize($attr);
22} else {
23    $attr = null;
24}
25
26if ($user === false) $user = NULL;
27if ($pass === false) $pass = NULL;
28
29$conn = new PDO($dsn, $user, $pass, $attr);
30
31var_dump($conn->errorCode());
32
33$query = 'SELECT 1';
34if ($conn->getAttribute(PDO::ATTR_DRIVER_NAME) === 'oci') {
35    $query .= ' FROM DUAL';
36}
37var_dump($conn->errorCode());
38var_dump($conn->errorCode());
39
40$stmt = $conn->prepare($query);
41var_dump($conn->errorCode());
42var_dump($stmt->errorCode());
43
44$stmt->execute();
45var_dump($stmt->errorCode());
46var_dump($stmt->errorCode());
47
48?>
49--EXPECT--
50NULL
51string(5) "00000"
52string(5) "00000"
53string(5) "00000"
54NULL
55string(5) "00000"
56string(5) "00000"
57