Posted By

jiggyhat on 05/16/09

Tagged

Versions (?)

Last Edited at 05/16/09 03:27pm

Statistics

Viewed 853 times

Favorited by 3 user(s)

Related snippets

Dynamic Navigation From Database Table Names

/ Published in: PHP

This will create a Navigation from a MySQL database table names. It removes the table name "includes" by default so you can see how to remove any certain tables you wish to not use as a site section. Just plug in your MySQL database details and connection info into data.php and you should be great to go.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

echo '<div class="dynamic_nav_head">Navigation</div><div class="dynamic_nav">';  // on less echo
        include('data.php');
        $tables = mysql_list_tables($database);
          while (list($table) = mysql_fetch_row($tables)) {     
                    if($table!='includes'){
                          $ucTable= ucwords($table); // just one function call
                           //  just one echo;
                           // you where also using quotes and double quotes backwards
 
                           echo '<div class="cat">'.$ucTable.'</div><div class="cat_item"><a href="?page=read&section='.$table.'">View ' .$ucTable.'</a></div><div class="cat_item"><a href="?page=add&section='.$table.'">Add New '. $ucTable .'</a></div>';
                    }  // End If not in Includes.
          } // End While
      echo '</div>';