Recent Questions Php Tree Menu Database Driven
Q: I have built a new drop down css menu.
I have a named frame body but when I use the menu creater it works and changes the frame but when loaded to the site it says error on page.
what have I done wrong ?
Try the home which calls home_body.htm and about us which calls About Us.html in the body frame top the right of the menu.
A: You cannot use local paths on the Internet sites. They won't work.
["Home","", "", "", "", "", "", "", "", ],
["|Back to main page","D:/Web Design/CCA/home_body.htm", "", "", "", "", "body", "", "", ],
["About Us","", "", "", "", "", "", "", "", ],
["|History","D:/Web Design/CCA/About Us.html", "", "", "", "", "body", "", "", ],
You should write, for example:
["Home","", "", "", "", "", "", "", "", ],
["|Back to main page","home_body.htm", "", "", "", "", "body", "", "", ],
["About Us","", "", "", "", "", "", "", "", ],
["|History","About Us.html", "", "", "", "", "body", "", "", ],
Q: I bought today and followed the procedure to download and install the same. It seems, Calender option is not available in the downloaded javascript menu generator package. Do I have download anything separate for that? Would you please let me know as soon as possible.
A: We haven't added Calendar in Deluxe Tuner.You can find it in the installed package:
C:\Program Files\JavaScript Tree Menus\сalendar\
Q: Can I use data from a SQL server using ASP for the dhtml xml menu?
A: You may generate a menu from a database or XML using any server-side script, e.g., PHP, ASP, VB, etc.However, these scripts don't work inside of Javascript .js files, so, you should move parameters of a menu from a .js file into an html-page, e.g.:
<!-- JavaScript Tree Menu -->
<noscript><a href="http://deluxe-menu.com">Javascript Menu by Deluxe-Menu.com</a></noscript>
<script type="text/javascript"> var dmWorkPath = "menudir/";</script>
<script type="text/javascript" src="menudir/dmenu.js"></script>
<!-- (c) 2006, http://deluxe-menu.com -->
<script type="text/javascript" language="JavaScript1.2">
// and describe parameters of a menu
var parameter1=value1;
var parameter2=value2;
etc.
var menuItems = [
// here you generate items using server-side scripts (php, asp, vb, etc.)
];
</script>
Unfortunately we don't have examples with ASP and SQL.
The example of the menu working with PHP/MYSQL you can find here:
http://deluxe-menu.com/rq-loading-bar-MySQL-support.html
Q: I need to work it with PHP/MySQL. I have found some information on it in your Support section, but have problems to understand and wonder if you have more information or a working sample of the loading bar with PHP/ MySQL.
A: Info about generating menu (menu items )from a database, please, see:
http://deluxe-menu.com/generate-menu-from-database-xml-php-asp-vb-support.html
Please, see the example of .php file.
The content of .php file depends on your database structure.
<?php
// The example for PHP/MySQL.
// MySQL database has the table "menuTable" that contains data for menu items.
// The table has the following fields:
// 1. "text" - item text
// 2. "link" - item link
// 3. "icon1" - item icon (normal state)
// 4. "icon2" - item icon (mouseover state)
function getMenuItems()
{
$jsItems = '';
// Select all records from table "menuTable"
$allItems = mysql_query('SELECT * FROM menuTable;');
// Extract items data from database and build Javascript code for menuItems
while ($itemData=mysql_fetch_array($allItems))
{
$jsItems .= '["'.$itemData['text'].'", "'.$itemData['link'].'", "'.$itemData['icon1'].'", "'.$itemData['icon2'].'"],';
}
// Return Javascript code
return $jsItems;
}
?>
<script>
var menuParam1 = value1;
var menuParam2 = value2;
var menuParam2 = value2;
...
var menuItems = [
<?php
// Write Javascript code for menu items
echo getMenuItems();
?>
];
</script>
