1--TEST--
2PDO::MYSQL_ATTR_INIT_COMMAND
3--EXTENSIONS--
4pdo_mysql
5--SKIPIF--
6<?php
7require_once __DIR__ . '/inc/mysql_pdo_test.inc';
8MySQLPDOTest::skip();
9?>
10--INI--
11error_reporting=E_ALL
12--FILE--
13<?php
14    require_once __DIR__ . '/inc/mysql_pdo_test.inc';
15
16    $dsn = MySQLPDOTest::getDSN();
17    $user = PDO_MYSQL_TEST_USER;
18    $pass = PDO_MYSQL_TEST_PASS;
19
20    $table = 'pdo_mysql_attr_init_command';
21    $db = new PDO($dsn, $user, $pass);
22
23    $create = sprintf('CREATE TABLE %s(id INT)', $table);
24    var_dump($create);
25    $db = new PDO($dsn, $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => $create));
26    $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
27
28    $info = $db->errorInfo();
29    var_dump($info[0]);
30
31    $db->exec(sprintf('INSERT INTO %s(id) VALUES (1)', $table));
32    $stmt = $db->query(sprintf('SELECT id FROM %s', $table));
33    var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
34
35    print "done!";
36?>
37--CLEAN--
38<?php
39require_once __DIR__ . '/inc/mysql_pdo_test.inc';
40$db = MySQLPDOTest::factory();
41$db->query('DROP TABLE IF EXISTS pdo_mysql_attr_init_command');
42?>
43--EXPECT--
44string(48) "CREATE TABLE pdo_mysql_attr_init_command(id INT)"
45string(5) "00000"
46array(1) {
47  [0]=>
48  array(1) {
49    ["id"]=>
50    string(1) "1"
51  }
52}
53done!
54