Annotation of embedaddon/php/ext/pdo_mysql/tests/pdo_mysql_attr_init_command.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: PDO::MYSQL_ATTR_INIT_COMMAND
3: --SKIPIF--
4: <?php
5: require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'skipif.inc');
6: require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
7: MySQLPDOTest::skip();
8: $db = MySQLPDOTest::factory();
9: ?>
10: --INI--
11: error_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--
39: %unicode|string%(58) "CREATE TABLE test_%s(id INT)"
40: %unicode|string%(5) "00000"
41: array(1) {
42: [0]=>
43: array(1) {
44: [%u|b%"id"]=>
45: %unicode|string%(1) "1"
46: }
47: }
48: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>