collapsing menu

killaklown · 06-21-2006, 11:54 AM

Im working on the menu at my site http://tutorialhit.com/index.php

i want to be able to click the main category (in this case, only one is there, and called PHP coding) and it would display all of the sub-categories in only that category (there will be more main categories added). Then if you click the PHP coding category again, the sub-categories go away again.

The categories are all in the mysql database

This is the code for the subcategories

PHP Code:

          if(count($children)>"0"&&$foetus!="") {

            foreach($children as $child) {

                $k++;

                $title = mysql_result(mysql_query("SELECT * FROM tdb_categories WHERE id='$child' LIMIT 1"), "0", "title");

                $stati = mysql_result(mysql_query("SELECT * FROM tdb_categories WHERE id='$child' LIMIT 1"), "0", "status");

????: NamePros.com http://www.namepros.com/programming/209454-collapsing-menu.html
                if($stati=="open") {

????: NamePros.com http://www.namepros.com/showthread.php?t=209454
                    $colspan = "1";

                    $link = '<a href="list.php?cat='.$child.'">'.$title.'</a></td><td class="info">'.mysql_numrows(mysql_query("SELECT * FROM tdb_tutorials WHERE cat='$child' AND status='accepted'")).' &times;';

                } else {

                    $link = ''.$title.'';

                    $colspan = "2";

                }

                echo '<tr class="menu'.$k.'subcat"><td class="link" colspan="'.$colspan.'">'.$link.'</td></tr>';

                if($k=="2") {

                    $k = "0";

                }

            }

        }

If you dont know what i mean, i found an example: http://www.chipchapin.com/WebTools/M...6/demo_win.php

If i know the code on how to make you click on a link and gives text to a certain variable but the page doesnt reload or something, then i can probably do it.

Ie

PHP Code:

  $activelink="";

 
//code to click the text below and add $title (category title) to the variable

Category name

 
// Then display sub-categories whos parent is $title (category title that was clicked)

hairyfreak · 06-21-2006, 12:30 PM

These three links should help, I think they are what you are after:

http://www.dynamicdrive.com/dynamici...switchmenu.htm
http://www.dynamicdrive.com/dynamici...witchmenu2.htm
http://www.dynamicdrive.com/dynamicindex1/navigate2.htm

The first is almost the same as the demo you posted. The second is similar, but has a smoother effect. The third is like the first, but allows more information.

killaklown · 06-21-2006, 12:36 PM

I dont think that would work for me, because there would be no way to tell what category was clicked and what subcategories to display.

Kadenz · 06-21-2006, 04:28 PM

I'm trying to figure out how to implement it into the PHP, but here's the Javascript:

Code:

<script type="text/javascript">
function showList(element) {
if (document.getElementById(element).style.visibility == "collapse") {
document.getElementById(element).style.visibility = "visible";
} else {
document.getElementById(element).style.visibility = "collapse";
}
}
</script>

This worked for me:

PHP Code:

  <?

$sql = mysql_query("SELECT * FROM db WHERE status='0'");

while ($row = mysql_fetch_object($sql, MYSQL_BOTH)) {

    echo '<strong><a href="javascript:showList(\''.$row->TITLE.'\');">'.$row->TITLE.'</a></strong><br />

    <table width="100%" border="0" cellspacing="0" cellpadding="0" style="visibility:collapse;" id="'.$row->TITLE.'">';

     $sql2 = mysql_query("SELECT * FROM db WHERE PARENT = '".$row->TITLE."' AND STATUS = '1'");

????: NamePros.com http://www.namepros.com/showthread.php?t=209454
     while ($row2 = mysql_fetch_object($sql2, MYSQL_BOTH)) {

     echo '<tr><td><a href="'.$row2->LINK.'" target="_blank">'.$row2->TITLE.'</a></td></tr>';

     }

????: NamePros.com http://www.namepros.com/showthread.php?t=209454
     echo '</table>';

}

?>

06-21-2006, 11:54 AM	THREAD STARTER #1 (permalink)
killaklown Senior Member Join Date: Oct 2003 Posts: 3,472	collapsing menu Im working on the menu at my site http://tutorialhit.com/index.php i want to be able to click the main category (in this case, only one is there, and called PHP coding) and it would display all of the sub-categories in only that category (there will be more main categories added). Then if you click the PHP coding category again, the sub-categories go away again. The categories are all in the mysql database This is the code for the subcategories PHP Code: if(count($children)>"0"&&$foetus!="") { foreach($children as $child) { $k++; $title = mysql_result(mysql_query("SELECT * FROM tdb_categories WHERE id='$child' LIMIT 1"), "0", "title"); $stati = mysql_result(mysql_query("SELECT * FROM tdb_categories WHERE id='$child' LIMIT 1"), "0", "status"); ????: NamePros.com http://www.namepros.com/programming/209454-collapsing-menu.html if($stati=="open") { ????: NamePros.com http://www.namepros.com/showthread.php?t=209454 $colspan = "1"; $link = '<a href="list.php?cat='.$child.'">'.$title.'</a></td><td class="info">'.mysql_numrows(mysql_query("SELECT * FROM tdb_tutorials WHERE cat='$child' AND status='accepted'")).' ×'; } else { $link = ''.$title.''; $colspan = "2"; } echo '<tr class="menu'.$k.'subcat"><td class="link" colspan="'.$colspan.'">'.$link.'</td></tr>'; if($k=="2") { $k = "0"; } } } If you dont know what i mean, i found an example: http://www.chipchapin.com/WebTools/M...6/demo_win.php If i know the code on how to make you click on a link and gives text to a certain variable but the page doesnt reload or something, then i can probably do it. Ie PHP Code: `$activelink=""; //code to click the text below and add $title (category title) to the variable Category name // Then display sub-categories whos parent is $title (category title that was clicked)` __________________ hostvouchers - Coupons and Reviews for the top web hosts! (shared, reseller, vps, servers, adult, offshore, proxy) Last edited by killaklown; 06-21-2006 at 12:20 PM.

06-21-2006, 12:36 PM	THREAD STARTER #3 (permalink)
killaklown Senior Member Join Date: Oct 2003 Posts: 3,472	I dont think that would work for me, because there would be no way to tell what category was clicked and what subcategories to display. __________________ hostvouchers - Coupons and Reviews for the top web hosts! (shared, reseller, vps, servers, adult, offshore, proxy)

06-21-2006, 04:28 PM	#4 (permalink)
Kadenz Resistance is Futile Join Date: Apr 2006 Location: Montreal, Canada Posts: 1,094 Follow @MitchKadenz	I'm trying to figure out how to implement it into the PHP, but here's the Javascript: Code: <script type="text/javascript"> function showList(element) { if (document.getElementById(element).style.visibility == "collapse") { document.getElementById(element).style.visibility = "visible"; } else { document.getElementById(element).style.visibility = "collapse"; } } </script> This worked for me: PHP Code: <? $sql = mysql_query("SELECT * FROM db WHERE status='0'"); while ($row = mysql_fetch_object($sql, MYSQL_BOTH)) { echo '<strong><a href="javascript:showList(\''.$row->TITLE.'\');">'.$row->TITLE.'</a></strong><br /> <table width="100%" border="0" cellspacing="0" cellpadding="0" style="visibility:collapse;" id="'.$row->TITLE.'">'; $sql2 = mysql_query("SELECT * FROM db WHERE PARENT = '".$row->TITLE."' AND STATUS = '1'"); ????: NamePros.com http://www.namepros.com/showthread.php?t=209454 while ($row2 = mysql_fetch_object($sql2, MYSQL_BOTH)) { echo '<tr><td><a href="'.$row2->LINK.'" target="_blank">'.$row2->TITLE.'</a></td></tr>'; } ????: NamePros.com http://www.namepros.com/showthread.php?t=209454 echo '</table>'; } ?> __________________ Freelance Web Developer PHP, MySQL, XHTML, CSS, Javascript, jQuery, Wordpress Portfolio: www.bundy.ca

06-21-2006, 12:30 PM	#2 (permalink)
hairyfreak NamePros Regular Join Date: Dec 2005 Location: Derbyshire, UK Posts: 887	These three links should help, I think they are what you are after: http://www.dynamicdrive.com/dynamici...switchmenu.htm http://www.dynamicdrive.com/dynamici...witchmenu2.htm http://www.dynamicdrive.com/dynamicindex1/navigate2.htm The first is almost the same as the demo you posted. The second is similar, but has a smoother effect. The third is like the first, but allows more information.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)