Cancelled

Script for Parent Child node MySQL Table with search

I need a php script solution to find and show tree structure of parent child nodes table.

MySQL Table has following structure:

id, Name, Parent

1, Building, 0

2, Room, 1

3, Table, 2

4, Drawer, 3

5, Building2, 0

6, Room, 5

7, Table, 6

8, Drawer, 7

Now if I search for "Table", it should give me a result like this:

1, Building, 0

2, Room, 1

3, Table, 2

5, Building2, 0

6, Room, 5

7, Table, 6

or if a search for Building, it should return

1, Building, 0

5, Building2, 0

I can't use [Recursive] Common Table Expressions, as it is not supported on older SQL version. I am on 5,6, so maybe you can provide me a php (5.x) script solution.

Skills: PHP, MySQL, Software Architecture

See more: mysql tree structure query, tree structure in php with mysql example, multi level parent-child relationship mysql, mysql select parent child records, mysql nested tables, php mysql parent-child hierarchy, query to get parent child relationship in mysql, mysql get all child nodes for parent, tree parent child node php, php script save checkbox status mysql table, parent child query mysql, parent child php node mysql url, mysql search engine display result table frame, script will display contents mysql table pages, select table search mysql php, sql tree mysql parent child recursion, search script live results querying mysql database joomla, menu child node sql table design, mysql datavase search script box, parent child php mysql tree menu

About the Employer:
( 0 reviews ) Sindelfingen, Germany

Project ID: #25670077

6 freelancers are bidding on average €36 for this job

techwelfare

yes! we could do this. plz share every [login to view URL] want to discuss with you... plz do respond. we have been working in website industry for last 10 years....

€87 EUR in 1 day
(179 Reviews)
7.2
TeamDPS

hi sir I am interested in your project. want to provide my best for your task. myself 6 year experienced developer. my aim is only to satisfied emoyer with quality. you can check my reviews for assurance. please ping m More

€30 EUR in 1 day
(52 Reviews)
4.9
gurpreet0173

I have read your requirements and i will complete your task within two days. Kindly initiate chat with me for further discussion

€30 EUR in 2 days
(18 Reviews)
4.2
sbiaiyoussef90

Hello , Today your job posting has caught my attention, and I wish to have a conversation about the project. I read your project - Dear Freelancer, As I have 4+ years of experience and I have skill sets of GRAPHIC DE More

€19 EUR in 7 days
(0 Reviews)
0.0
Ioanvizitiu1

I can implement and test the solution I have in mind in at most two hours. I can do it tomorrow. Relevant Skills and Experience The solution can be written as a PHP recursive function.

€19 EUR in 1 day
(0 Reviews)
0.0
mcaashutosh5

I have 2 year experience in php mysql. so i give your task on time to give. I am freelancer for PHP MYSQL, convert jpg document to msoffice

€33 EUR in 2 days
(0 Reviews)
0.0