arrays - PHP create a hierarchy menu structure -



arrays - PHP create a hierarchy menu structure -

basically have table in mysql

name id parent bob 321 root sue 32 root boo 393 32 geek 72 393 sam 312 393 tovoc 341 321 reese 322 393 sheep 811 341

i want create menu outputs menu construction submenus based on parent id

so should output

bob tovoc sheep sue boo sam geek reese

the kid entries linked parent id , if have parent become child. build multidimentual array. clues?

heres got far. works, can't figure out how increment or reset margin style nice construction view. have margin-left increment 10px in every kid elements found, reset 1 if parent user

isparent(user,1); function isparent($parent,$if=1){ $stdr = 'select * cravebins userid = '.$_session[craveuserid].' , parent=\''.$parent.'\' order name asc'; $resultmainmenu = mysql_query($stdr) or die('421 '.$stdr.mysql_error()); if(mysql_num_rows($resultmainmenu)){ while($row = mysql_fetch_array($resultmainmenu)){ $if++; echo '<div class="bindir" onclick="setbin(this)" id="binlistuser" style="margin-left:'.(5+($if * 10)).'px" driid="'.$row[id].'">'.$row['name'].'</div>'; // echo main menu $n = isparent($row['id'],$if); }//end while }else{ $if=1; } // if rows }//end function

php arrays menu

Comments

Post a Comment

Popular posts from this blog

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

html - Submenu setup with jquery and effect 'fold' -

html - Submenu setup with jquery and effect 'fold' - i want open submenu jquery effect fold, problem if user "hover effect" fast menu remain open, how can avoid this, jquery code is: $('ul.mainmenu li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $(this).children('ul').hide('fold', 500); } ); my jsfiddle link is: http://jsfiddle.net/9wkbf/ updated fiddle the reason behind problem is, first event $(this).children('ul').show('fold', 570); queued , until completes, sec animation not start. the next snippet can workaround $('ul.mainmenu > li').hover( function() { $(this).children('ul').show('fold', 570); }, function() { $('ul:not(.mainmenu)').hide('fold', 500); } ); *important note : work current scenario. jquery html css
Read more