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.
Did you know?Explore Trending and Topic pages for more stories like this.
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;
No comments posted yet
Your Answer:
Login to answer
170
51
Other forums
help, header() is not working!
Hello, I have this code:
<?php
/**
* @author samoi
* @copyright 200
Character increment
Hi,
I am facing a scenario like above,but in my case i want to show up like Col A,Col B etc..
Unable to customise toolbar in FCK
is this the proper use of mysql_real_escape_string() to prevent sql injections?
i was wondering is this the proper use of mysql_real_escape_string() to prevent sql injections? any
Error with Font and imagettfbbox
I keep getting an error that says "Warning: imagettfbbox() [function.imagettfbbox]: Could not f
article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on
Storing user data help?
Hey Guys,
I'm not use if this question is to broad but I can always give you more informatio
How to generate a text file using php...?
Hi,
Can anyone give me code to generate a text file using php
Thanks in advance
Escaped characters
I have a script that allows you to post news to the home page of my site. Along with the news is the
Inserting Data into a MS Access DB using PHP.
As part of my uni course I am doing a placement at a company whom want me to create a client zone fo