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

A rank users order by points
I want to make an insert from table 'rank' , with number (rank) from the cod blow, to fild users.ran

Problems with array
This code is the last lines in an upload script that uploads 4 images at the same time and writes th

PHP page is blank
Hi Everyone,

I have a site in which I am able to open the first PHP webpage in my browser but

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

Image DPI
Hi.

I allow users to upload images, the user then is able to adjust several settings for the

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

Fetching META TAGS through
Hello everybody
I want to fetch meta tags of a domain.
It will be done from following code of

Collecting AOL Search Terms
I am attempting to collect AOL search terms. I know the code is correct (it works for google, bing,

a dificult string search
Hi I don't know a way around this. I want the user to input a password, but to make it a bit complca

Help with PHP and checkboxes
I am posting this for a friend of mine, i wrote a small script for her to process her form data to a