Slashdot Menu Database Integration Problems

googlit · September 24, 2012

Hi all,

Heres my problem....

i have created a script that will run a category tree on my webpage and am wanting to integrate it into an existing java menu call slashdot (sdmenu).

I have no idea where to start so was looking for some assistance...

DB Setup:

Column----- Type------------- NULL Default

id------------- int(11)------------ No ----------------------auto Increment - Primary Key

name ------ Varchar(255)--- No

parent_id --- int(11)------------ No ------0

catDescrip-- varchar(255)-- YES -----NULL

catOrder --- varchar(255) - YES ---- NULL

isActive ------int(11) ----------- NO ------1

My Code for the category tree is as follows:

<?php
function hasChild($parent_id)
{
$sql = "SELECT COUNT(*) as count FROM categories WHERE parent_id = '" . $parent_id . "'";
$qry = mysql_query($sql);
$rs = mysql_fetch_array($qry);
return $rs['count'];
}
function CategoryTree($list,$parent,$append)
{
$list = '<li>'.$parent['name'].'</li>';
if (hasChild($parent['id'])) // check if the id has a child
{
	 $append++;
	 $list .= "<ul class='child child".$append."'>";
	 $sql = "SELECT * FROM categories WHERE parent_id = '" . $parent['id'] . "'";
	 $qry = mysql_query($sql);
	 $child = mysql_fetch_array($qry);
	 do{
	 $list .= CategoryTree($list,$child,$append);
	 }while($child = mysql_fetch_array($qry));
	 $list .= "</ul>";
}
return $list;
}
function CategoryList()
{
$list = "";
$sql = "SELECT * FROM categories WHERE (parent_id = 0 OR parent_id IS NULL)";
$qry = mysql_query($sql);
$parent = mysql_fetch_array($qry);
$mainlist = "<ul class='parent'>";
do{
	 $mainlist .= CategoryTree($list,$parent,$append = 0);
}while($parent = mysql_fetch_array($qry));
$list .= "</ul>";
return $mainlist;
}
?>

and the code i am wanting to place it into is as follows:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link rel="stylesheet" type="text/css" href="sdmenu/sdmenu.css" />
    <script type="text/javascript" src="sdmenu/sdmenu.js">

    </script>
    <script type="text/javascript">
    // <![CDATA[
    var myMenu;
    window.onload = function() {
		    myMenu = new SDMenu("my_menu");
		    myMenu.init();
    };
    // ]]>
    </script>
</head>
<body>
<!--Navbar test--------------------->

<div style="float: left" id="my_menu" class="sdmenu">
	  <div>
		    <span>one</span>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
	  </div>
	  <div>


		    <span>two</span>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
	  </div>
	  <div class="collapsed">


		    <span>three</span>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
	  </div>
	  <div>


		    <span>four</span>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
		    <a href="link1.php">link1</a>
	  </div>
    </div>

</body>
</html>

a preview of the menu can be seen here:

http://www.iwdmachines.co.uk/sd/

attached are the files for SDMENU

sdmenu.zip

Sign In

Slashdot Menu Database Integration Problems

Recommended Posts

googlit

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information