Script for Parent Child node MySQL Table with search
€8-30 EUR
Cancelado
Publicado hace casi 4 años
€8-30 EUR
Pagado a la entrega
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.
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 me for discussion
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.