Support ⇒ Explain Please :: Archives ⇒ Checking a table exists :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS

Archived ⇒ Checking a table exists

Kendle Offline Joined: Dec 16, 2004 Posts: 569 0 👍 / 0 👎	Tue Oct 02, 2007 8:36 am What's the best way of checking whether a table exists in the database? Is there a function for it in $db, or is there an SQL statement I can use to check, or do I simply use a CREATE TABLE IF NOT EXISTS statement to create the table if it's not there? This is for something I want to release for free by the way, not a commercial module. Gaming League / Cup - www.leaguecms.co.uk :: Other DragonFly modules - www.cmsdreams.co.uk Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
NanoCaiordo Offline Joined: Jun 29, 2004 Posts: 4297 Location: Italy 0 👍 / 0 👎	Tue Oct 02, 2007 8:57 am `echo '<pre>'; print_r($db->list_tables()); echo '</pre>';` .:: I met php the 03 December 2003 :: Unforgettable day! ::. Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS): CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS
layingback Offline Joined: Apr 19, 2004 Posts: 1415 Location: Andalucia 0 👍 / 0 👎	Tue Oct 02, 2007 3:00 pm Had to solve this one myself recently. There is very little info online (beyond Nano's suggestion - which seems sledgehammer-to-crack-a-walnut for just 1 table). Settled on: `$result = $db->sql_query("SHOW TABLES LIKE '".$prefix."\_%\_forums'");` Obviously put whatever you need in the like string, but I left mine in as an example. Pro_News CM™ - Content Management for Dragonfly CMS™ Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS): Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4
Phoenix Offline Joined: Apr 19, 2004 Posts: 8841 Location: Netizen 0 👍 / 0 👎	Tue Oct 02, 2007 3:11 pm I've used elsewhere,`$tableexists = $db->sql_query("DESCRIBE ".$prefix."_sometable");` Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
All times are UTC Post new topic Forum Index ⇒ Explain Please Page 1 of 1