Check to see if MySQL table exists

May 23, 2008 | 0 comments | 1 Page

I found use with this little function when developing my modular content management system i call ReactorSystem (this site is using it). What it does is check the connected database for the table you send it, returning a boolean value of its result.

function table_exists($table) { $found = false; $query = mysql_query("SHOW TABLES;"); while ($row = mysql_fetch_row($query)) { if ($row[0] == $table) { $found = true; break; } } return($found); } if (table_exists("some_table_name")) echo "the table exists!";

· Keywords: function, myql, exists

No comments made