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