How to create a static html menu from a database

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

I have built a small cms which allows me to create simple html pages and then upload them to an ftp.

Everything is working apart from the menu, I cant get my head round how to create the menu system. The outputted file is a static html file that wont be connected to a database, so I need to retrieve the information from the database then write this information in standard html to a page before it is sent to the ftp.

I have looked through the forum and the net and can't find a solution, can anyone help?

CODE//// (which I know is incorrect, but kind of works and should hopefully show what I mean)

$page_name = mysql_query("SELECT * FROM pages WHERE page_display = 'yes' ORDER BY page_order ASC")
or die(mysql_error());


while($info = mysql_fetch_array( $page_name ))
{
$page[] = $info[page_name];
}

$navigation = <<<EOD


<li>$page[0]</li>
<li>$page[1]</li>
<li>$page[2]</li>
<li>$page[3]</li>


EOD;

Your Answer:

Login to answer

Other forums

Help with email validation please...
Hi,
Please could you help.
I have a register.php login page where users register, the detail

Need some ideas as to how to go about sorting this array...
Here's how the array's are created..

Code: <?php
while ($x = readdir($dp)) {

Anti Spam Code
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I

socket makes browser hang...
I have a socket server, and I am having a problem at the moment...

A browser sends a http hea

Revoking alter any table from a schema
Hi All,

i am working in Oracle 10g.
my requirement is to revoke all kind of DDL oper

SAP Logon Failed
I tried to login to SAP through MMC.

When i click start and give password.

it

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

How to write on database when a link is clicked?
Hi, I have a list of products in a gridview. When the link is clicked currently it takes to an ext

bit of help needed
Im about to sort out my registration page for my website by customising a "registration" s

php form help
Hey,

I use a control file to set my meta tags and titles

Here's an example
Code: &a