1--TEST--
2PDO::MYSQL_ATTR_INIT_COMMAND
3--SKIPIF--
4<?php
5require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'skipif.inc');
6require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
7MySQLPDOTest::skip();
8$db = MySQLPDOTest::factory();
9?>
10--INI--
11error_reporting=E_ALL
12--FILE--
13<?php
14	require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
15
16	$dsn = MySQLPDOTest::getDSN();
17	$user = PDO_MYSQL_TEST_USER;
18	$pass = PDO_MYSQL_TEST_PASS;
19
20	$table = sprintf("test_%s", md5(mt_rand(0, PHP_INT_MAX)));
21	$db = new PDO($dsn, $user, $pass);
22	$db->exec(sprintf('DROP TABLE IF EXISTS %s', $table));
23
24	$create = sprintf('CREATE TABLE %s(id INT)', $table);
25	var_dump($create);
26	$db = new PDO($dsn, $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => $create));
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	$db->exec(sprintf('DROP TABLE IF EXISTS %s', $table));
36	print "done!";
37?>
38--EXPECTF--
39string(58) "CREATE TABLE test_%s(id INT)"
40string(5) "00000"
41array(1) {
42  [0]=>
43  array(1) {
44    ["id"]=>
45    string(1) "1"
46  }
47}
48done!
49