En cours

SQL Query in PHP for use nested navigation menu

Menu Needs

SQL Need.

I need the most efficient SQL query I can find that returns a dataset being used to build a website navigation menu.

This is a typical navigation menu in most respect however it must allow for unlimited nesting.

So there are two main fields. The item_id and item_parent. Every item has an id and every item has a parent - except the root heading which is assigned an item_parent of 0.

A php sql query must be written in such a way that it recurses through every item, notes its parent item and builds a hierarchal tree structure from hierarchal structure noted.

For instance

Heading 0

......Item 0

......Item 1

............Item 0

..................Item 0

..................Item 1

............Item 1

............Item 2

......Item 2

Heading 1

......Item 0

......Item 1

......Item 2

Heading 3

......Item 0

......Item 1

......Item 2

............Item 0

......Item 3

I have attached a mysql sql file which you can import for use. Please incorporate the item_title which would serve as the Item Text and also href the item_link.

Compétences : PHP, Architecture Logicielle, SQL

Voir plus : php sql nested menu, query nested menu, nested navigation sql, php sql query navigation, sql nested navigation, sql navigation query, tree structure, tree query, find php website, build mysql query, sql navigation menu, nested php sql, website navigation, use, sql query, php sql, find root, build sql, structure php, nested sql, sql nested query, structure tree, nested, php nested, nested tree

Concernant l'employeur :
( 56 commentaires ) Anacortes, United States

N° du projet : #1015821

Décerné à :

alphamaster

Hi, Already done. Please check your PMB for result files. Deliverable exactly after assigning the project.

30 $ USD en 0 jours
(5 Commentaires)
3.4
AlexandruIfrim

Already done, check PM.

30 $ USD en 1 jour
(3 Commentaires)
1.8

14 freelance ont fait une offre moyenne de 34 $ pour ce travail

neoconcepts

we are done.

30 $ USD en 0 jours
(104 Commentaires)
7.2
nrifriends

Please check your PM.

30 $ USD en 1 jour
(46 Commentaires)
6.8
LeaderTeam

Hello. Please check PM:)

35 $ USD en 0 jours
(56 Commentaires)
6.3
phpplay

I can do that.

35 $ USD en 0 jours
(17 Commentaires)
5.5
duyvnpro

Hi sir, i can work immediate, now, please check your inbox for more detail

40 $ USD en 1 jour
(13 Commentaires)
4.4
rajivjindal08

it can be done. Provide details

40 $ USD en 2 jours
(1 Commentaire)
2.6
AntonSayapin

Simple job. Let's start.

30 $ USD en 0 jours
(0 Commentaires)
0.0
sally2010

i have done it before and will pleasure to do it

40 $ USD en 0 jours
(0 Commentaires)
0.0
gabrinnescu

Hello! I've done that already. I can customize one for you. Thank you!

100 $ USD en 3 jours
(0 Commentaires)
0.0
rohanmeegada

I'm ready to work for u

45 $ USD en 2 jours
(0 Commentaires)
0.0
nanamedia

I can provide php code to render the menu

30 $ USD en 0 jours
(0 Commentaires)
0.0
shlokjodha

lets do it.

31 $ USD en 0 jours
(1 Commentaire)
0.0
ericgarcia

Hi, I'm ready to start. please see PM. thanks

30 $ USD en 0 jours
(0 Commentaires)
0.0