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

What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c

Display search result
Hi!

I have a SQL database with information about albums and track (music).

This is wh

getting rid of quotes in strings
sick of trying to deal with them in multiple ways (entering in and taking from database, echoing, ec

Form errors in an array
I'm processing a form and putting the errors in an array. empty($errors) doesn't seem to do the tric

php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum

Memory Allocation
Hi folks,
see this ex:

int v=5;
v=v+10;

then what will do the compiler before th

regex for quoted text within a string
I am still getting the hang of regex expressions, but I cant seem to figure out how I would escape q

passing an array of objects after submit
How do I do this? This is what I have tried and it is not working.

<form method="

XML Grouping
I'm using xml_parse_into_struct to get all my elements, but now I need to group them. For example, h

Linked Keywords
I am trying to get a script that makes my predefined keyword converted to links and / or converted t