Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:22924
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Message-ID: <4449B766.50109@smashlabs.com>
Date: Fri, 21 Apr 2006 23:56:06 -0500
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
To: internals@lists.php.net
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: PDO MySQL - show create table 
From: ralph@smashlabs.com (Ralph Schindler)

Is it not possible to run the "show create table __" via PDO?  I swear I 
was able to do this in the past, and for some reason this is not 
working.  Am I doing something wrong, is this a bug, or is this planned?

Pasted below is the mysql command and result expected, test code, and 
its result.

-ralph




#### PROOF THE COMMAND WORKS

ralph@localhost ~/development/code/php5.1-200604220230 $ echo "show 
create table blog_comments" | mysql -u root --password=xxxxxx test
Table   Create Table
blog_comments   CREATE TABLE `blog_comments` (\n  `id` int(11) NOT NULL 
auto_increment,\n  `blog_entry_id` int(11) NOT NULL,\n  `comment` text 
NOT NULL,\n  `comment_datetime` datetime NOT NULL,\n  PRIMARY KEY 
(`id`),\n  KEY `FK_blog_comments_1` (`blog_entry_id`),\n  CONSTRAINT 
`FK_blog_comments_1` FOREIGN KEY (`blog_entry_id`) REFERENCES 
`blog_entries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) 
ENGINE=InnoDB DEFAULT CHARSET=utf8


#### THE TEST SCRIPT

ralph@localhost ~/development/code/php5.1-200604220230 $ cat 
/home/ralph/development/vhosts/ralphschindler.com/development/test_show.php
<?

$db = new PDO("mysql:dbname=test", "root", "xxxxxx");

echo "\nTEST PREPARED-------\n";

try {
     $stmt = $db->prepare("SHOW CREATE TABLE blog_comments");
     $stmt->execute();
     print_r($stmt); echo "\n";
     $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
     print_r($result);
     echo "no exceptions\n";
} catch (Exception $e) {
     echo $e->getMessage();
     echo "exception";
}

echo "\n\nTEST QUERY--------\n";

try {
     $thing = $db->query("SHOW CREATE TABLE blog_comments");
     print_r($thing); echo "\n";
     echo "no exception\n";
} catch (Exception $e) {
     echo $e->getMessage();
     echo "exception";
}


#### TEST SCRIPT OUTPUT


ralph@localhost ~/development/code/php5.1-200604220230 $ ./sapi/cli/php 
/home/ralph/development/vhosts/ralphschindler.com/development/test_show.php

TEST PREPARED-------
PDOStatement Object
(
     [queryString] => SHOW CREATE TABLE blog_comments
)

Array
(
)
no exceptions


TEST QUERY--------

no exception