Problems checking whether a table exist or not in the db

Question

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 these 2 things but it doenst work.. the first example always tells me that it doesn't exists.. even when it does exists in my db and the 2nd example tells me that it always exists... even when it doesnt exists....

$db = new PDO('mysql:host=' . $DB_SERVER . ';dbname=' . $DB_NAME, $DB_USER, $DB_PASS);

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

I've also tried this

$results = $db->query('SHOW TABLE LIKE \'page\'');
if (count($results) > 0) {
    echo 'table exists';
} else {
    echo "it doesnt";
}

This won't help you with your question, but can you please choose a consistent quotation style? You use " and ' very haphazardly. Pick one or the other and use it throughout your code. — Matt
– Matt, Commented Aug 23, 2012 at 18:38

Scott Presnell · Accepted Answer · 2012-08-23 18:48:40Z

3

How about:

$results = $db->query('SHOW TABLES LIKE \'page\'');
if (count($results->fetchAll()) > 0) {
    echo 'table exists';
} else {
    echo "it doesnt";
}

answered Aug 23, 2012 at 18:48

Scott Presnell

1,54810 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jonathan Thurft Over a year ago

It works. Thank you. I still dont know why it doesnt work the previous one tho... is pretty much the same

Mike Mackintosh · Accepted Answer · 2012-08-23 18:40:12Z

0

Make sure your user has access to the information schema database, and do:

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'database_to_search'
AND TABLE_NAME LIKE "table_here%"

Then grab and check your results. Using the above, if you needed to, allows you to also limit your response (offset, limit).

answered Aug 23, 2012 at 18:40

Mike Mackintosh

14.3k7 gold badges64 silver badges87 bronze badges

Collectives™ on Stack Overflow

Problems checking whether a table exist or not in the db

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related