How do I check for the existence of a particular MySQL table using PHP? (Using an IF statement.)

I don’t know of a preexisting function, so here’s one I wrote real quick (untested):

function checkTable ($table_name, $database_name) {
$my_tables = mysql_list_tables($database_name);
while (list($foo) = mysql_fetch_array($my_tables)) {
if ($foo == $table_name) return true;
}
return false;
}

if (checkTable(“content”, “your_database”)) {

// Table exists

} else {

// Table does not exist

}

There’s no facility in SQL (MySQL’s implementation anyway) to check for the existence of a table so lefteh’s method should do the trick.

Thanks! Reworked it into a switch and I’m ready to go.

From the phpMyAdmin sources:

/**
* Ensures the database exists (else move to the “parent” script) and displays
* headers
*/
if (!isset($is_db) || !$is_db) {
// Not a valid db name -> back to the welcome page
if (strlen($db)) {
$is_db = PMA_DBI_select_db($db);
}
if (! strlen($db) || !$is_db) {
PMA_sendHeaderLocation($cfg[‘PmaAbsoluteUri’] . ‘main.php?’ . PMA_generate_common_url(’’, ’’, ’&’) . (isset($message) ? ’&message=’ . urlencode($message) : ’’) . ’&reload=1’);
exit;
}
} // end if (ensures db exists)