How?

Tanax · 09-29-2007, 07:59 PM

How can I check with PHP if a table in the database exists? :confused: :confused:

Haris · 09-29-2007, 09:03 PM

Quote:

Originally Posted by Haris

PHP Code:


			
        public function __construct(){
            $szSQL = "CREATE TABLE IF NOT EXISTS ...";
        }

"CREATE TABLE IF NOT EXISTS" is the key phrase!

Tanax · 09-29-2007, 10:39 PM

But I don't want to create a table if it doesn't exists, I just want to check if it exists :(

Wildhoney · 09-29-2007, 11:24 PM

PHP Code:


			
$pTables = mysql_list_tables('myDatabase');

while($aTable = mysql_fetch_row($pTables))
{
    if($aTable[0] == 'myTable')
    {
        echo 'Found!';
        break;
    }
}

Salathe · 09-29-2007, 11:50 PM

The mysql_fetch_row function was depreciated a long time ago. It's better to do a normal query and check the result:

PHP Code:


			
if(!mysql_num_rows(mysql_query("SHOW TABLES LIKE 'myTable';")))
{
    echo 'Table myTable does not exist.';
}

Tanax · 09-30-2007, 09:52 AM

Yea, it worked :D Thanks guys!