如何使用pdo检查表是否存在[重复]

Question

Possible Duplicate:
MySQL check if a table exists without throwing an exception

Basically I have my MySQL dbname = test and my table name = page.

I want to create a query using a php PDO to check if the table "page" exists in my db "test"

I've tried this but it doenst work.. it always tells me that it doesnt exists.. even when it does

if (array_search('pages',$db->query('show tables')->fetch()) !== false) { echo "the db exists";

    } else { echo "the db doesnt exists";
    // Create tableS
    //$IDB->execute();
    }

Answer 1

there is no predefined test for existing table in PDO, you must do :

$pdo = new PDO($dsn,$user,$pass,$options);
$results = $pdo->query('SHOW TABLE LIKE \'page\'');
if(count($results)>0){echo 'table exists';}