Thread: PHP / MYSQL Side Menu
Results 1 to 7 of 7
Related
-
Side by side html tables Forum: HTML Forum
Replies: 7 -
I'm trying to find a menu that can be two or three side by side Forum: HTML Forum
Replies: 2 -
Click right side of image for next image, left side back? Forum: Javascript Forum
Replies: 3 -
tables appear side by side? Forum: HTML Forum
Replies: 1 -
side menu item only shows when DB has item in field Forum: PHP Forum
Replies: 25
-
04-04-2006, 07:13 AM #1
PHP / MYSQL Side Menu
Hello to all -excellent forum!
Hope to get an answer and/or suggestion or two. I want to give you the whole picture so you know exactly what we are trying to do.
Our website uses two "MyGosu" menus:
http://gosu.pl/dhtml/mygosumenu.html
We are using both DropDownMenuX versions and for our vertical menu:
http://www.attotech.com/expraid.html
we are going to change our menu values for each product page. We want to incorporate a MySQL DB so all product information (press releases, tech PDF's, drivers, software updates, certs) can be stored for easy updates for all the perspective pages.
Can someone please offer a step by step on how to do this and/or point me to a completed system or tutorial?
Thank you in advance. I appreciate any help and suggestions.
-
04-06-2006, 12:14 PM #2
Re: PHP/MYSQL Side Menu
anyone? Or is this question to vague?
-
04-07-2006, 05:54 AM #3
Re: PHP?MYSQL Side Menu
You have to use a mysql query. Which will read from your database for the data that you want ipresent in this Dropdown list.
-
04-10-2006, 06:38 AM #4
Re: PHP?MYSQL Side Menu
It's very difficult to reply to this without knowing what data you have, how it's stored, and what criteria you're going to use to build the menu from.
-
04-10-2006, 07:08 AM #5
Re: PHP?MYSQL Side Menu
Hi thanks for the replies.
To show some of the data, I supplied the link above. This information is now stored both as local web files and on a server. We want to keep the menu we have now but if you notice, when you click on any of the menu items, you are taken to a "generic" page with all the information for many products.
Our goal is to have the menu retrive items from a mysql db that is only for the product and page a user is on. For instance, when visiting the page for the link above, when you click tech sheets, you would go directly to the tech sheet for EXPRESS RAID. etc, etc.
I assume this can be accomplished with a one table db, the columns would be "tech sheets", drivers, certs, etc.Please let me know if I am on the right tarck or please provide any feedback or ideas...Your time and input is greatly appreciated!
Thanks all..
-
04-10-2006, 07:57 AM #6
Re: PHP?MYSQL Side Menu
You may need to restructure the products section of the site, but the basic plan, off the top of my head, would be to firstly have the links stored in a separate table using the product ID as the key, then pass the product id to the webpage (either with a session variable, eg. $_SESSION['prod_id']) or in the URL (eg. http://www.attotech.com/info.php?pid=123456) then query the database as you build the page, so you'd build the page header/menu bar etc., then query the database for the links: (not real code!)
Code:$result=mysql_query("SELECT * FROM links WHERE pid = $pid"); $links = mysql_fetch_array($result); <a href="$links['techsheet']>Technical Data</a> <a href="$links['Drivers']>Drivers</a> if ($links['updates'] != "") { <a href="$links['updates']>Software Updates</a> } .... etc.
It is expandable to include multiple products, if you improve the structure and build the html before outputting it.
I hope that's about right, I'm sure someone will correct me if not!
-
04-10-2006, 02:47 PM #7
Re: PHP?MYSQL Side Menu
Thanks DeadMeat and all.
Cloudjiffy- PaaS for Developers
10-05-2020, 12:30 AM in Web Hosting Forum