need mysql_table_exists() function

[triix]

Hi,

i have to check if a certain mysql table exists or not...
did anybody of you this before and has a function to do it?

regards

triix

[triix]

doh.. just found one in the php doku.. (with the user contributed functions)... for all who need it:

[e-mail]
31-May-2002 06:13

Here's a little function that will tell you if a table exists. (this function assumes an active db connection as well as a selected database)

function mysql_table_exist($tableName)
{
$query = "SELECT COUNT(*) FROM $tableName";
$result = mysql_query($query);
$num_rows = @mysql_num_rows($result);
if($num_rows)
{
return TRUE;
}
else
{

return FALSE;
}

}

Can't believe there isn't a function like this as part of the core MySQL support. (To be honest, there probebly is a function like this, I just over looked it. It would be like me to do things the hard way 😉

regards,

triix

[dannys]

That's probably not the best way to do that - Try this instead:

<?php

function mysql_table_exists($table,$dbName,$dbLink="")
{
	empty($dbLink) ? $result = mysql_list_tables($dbName) : $result = mysql_list_tables($dbName, $dbLink);

foreach(range(0,mysql_num_rows($result)-1) as $i)
	$tableArray[] = mysql_tablename($result,$i);

return(in_array($table,$tableArray));
}

?>

[the_Igel]

sure you can submit any query to that table and then check for mysql_error() value.

[techrat]

This code works even more simply.

 $database = Database table is in.
 $tablename = Table being searched for.

The above variables have to be pre-defined, and it helps if all tablenames are in lower case. Some Unix boxes have problems with case.

$tablelist = mysql_list_tables($database);
$result=mysql_fetch_array($tablelist);

if (in_array($tablename,$result)) {
// table exitst
} else {
// table doesnt exist
}

[the_Igel]

But be aware that in_array() (along with many others array functions) appeared only in php4.

Some people still have to deal with older versions 🙁
Still, it's easy to write in_array() functin by yourself.