SQL Recursive Query with PHP

Server Environment

- Linux

- MySQL (MariaDB) 10.1x

- PHP 5.6


In our app we have a translation context string. This string is build out of an tree.


[url removed, login to view]

The context parts are variable. And are possible one part up to 8 parts (dots).

Each item of the context is stored with its own ID and its parent inside the database.


ID, parent, name

1, 0, parameter

3, 1, names

4, 3, FrontSpalt

In a second table, I have a text to the last part of the context (right part) that is not isHelp=0


ID, parent, text

2,4,”Maß von Kor…..”

I want to build now a SQL query that shows me as a result the whole context with its text from the second table.

This result have to be written as html page with php 5.6

Attached you will find a dump of the two tables. This only contain some sample data.

The database do not contain “WITH” statement so it have to be solved another way.

I expect SQL scripts to run in phpymyadmin frontend.

As Sample:

[url removed, login to view] = “Maß von Korpusvorderkante bis zur Innenkante der F.”

Re-Upload Dump files

Beceriler: Grafik Tasarımı, HTML, PHP, Web Sitesi Tasarımı

Daha fazlasını gör: mysql hierarchical query, storing hierarchical data in a database, mysql hierarchical query self join, mysql tree structure query, php mysql hierarchical data, mysql parent child query, mysql category tree, mysql recursive query parent child tree, php convert html pdf server linux, 2008 sql server 2000 sample, query php server css players, years experience aspnet sql server html javascript, parse html tables text using php, sql server html javascript, aspnet sql server html java script

İşveren Hakkında:
( 557 değerlendirme ) Berln, Germany

Proje NO: #14866108

26 freelancers are bidding on average $146 for this job


To write sql query for retrieving the data from the second table and display the result as follows: Relevant Skills and Experience [url removed, login to view] = “Maß von Korpusvorderkante bis zur Innenkante der F.” Pr Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(627 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(80 Değerlendirme)

Looking forward to discuss further details about the project Relevant Skills and Experience proven track record on this site Proposed Milestones $222 USD - milestone

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(135 Değerlendirme)

Hi, its pretty simple for me but I have few questions to ask, knock me for further discussion, PLEASE DON'T AWARD PROJECT BEFORE DISCUSSION. Thank You! Relevant Skills and Experience graphic, html, php, web Proposed Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(134 Değerlendirme)

interested for this project please discuss

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(233 Değerlendirme)

Hey there, If you're looking for excellent development quality and great English communication skills, you've come to the right place. Relevant Skills and Experience I am a highly experienced web developer, with 13+ y Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(36 Değerlendirme)

Hello, Honorable Hiring Manager, Relevant Skills and Experience I am Expert Web Developer & I have 7+ years of experience. Web Development and Graphics designer Proposed Milestones $155 USD - Project Milestone

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)
in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)

Hi! I can perform this task efficiently and i can start work right now. Contact me for quick and quality work. Thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(27 Değerlendirme)

Hi, can you send me the dump of the tables? I can create it. Regards, Rocky Stay tuned, I'm still working on this proposal.

in %bids___i_period_sub_35% gün içinde85%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(46 Değerlendirme)

HI, I would like to work on your sql task. I think that using WHILE and SELECT TOP 1 we can build a solution Relevant Skills and Experience I am .net/php/sql developer I work from Italy Proposed Milestones $111 USD Daha Fazla

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)

Hi, I can Create a PHP script that can be retrieved with .html extension which outputs the result from mysql tables. If you prefer me to do the job then kindly share your sample sql dumps on chat. Relevant Skills and Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(40 Değerlendirme)

I am an expert. Relevant Skills and Experience Please contact me. Proposed Milestones $155 USD - complete Thanks for ur reply

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

Hi,dear. We understand your requirements and I am very interested in this job - 'SQL Recursive Query with PHP'. We are senior software developers and I am able to perform this task with my developers team. Relevant Sk Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(21 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

Hi.I have a look into your requirements, I assure to do it perfectly.. I provide demo database along with sql query as per [url removed, login to view] by 1 day after [url removed, login to view] now to start job. Relevant Skills and E Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
in %bids___i_period_sub_35% gün içinde174%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

Hello, I looked at the data you sent if I am right the output for parameter.names.Fuge_Oben would be "Maß von Oberkante...". Let me know if I am right, then I am sure I can give you a solution. Relevant Skills and Exp Daha Fazla

in %bids___i_period_sub_35% gün içinde88%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

Hello! , my name is Jose, I have plenty of experience with website design, as well as HTML, PHP and WordPress. I would be happy to do this for you. Relevant Skills and Experience experience with website design, as wel Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)