PHP Classes

SQL Parse Convert to Tree Array: Build a tree to represent an SQL query

Recommend this page to a friend!
     
  Info   Videos   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 60%Total: 2,062 All time: 1,903 This week: 455Up
Version License PHP version Categories
dqml2tree 0.13Public Domain4.4Databases, Text processing
Description 

Author

François NEUMANN-RYSTOW

This class can be used to build a tree to represent an SQL query.

It takes a given SQL query and parse it to extract the structure or queries and sub-queries. The resulting structure is returned as an array.

Currently it supports only SELECT, INSERT, UPDATE, DELETE queries.

Innovation Award
PHP Programming Innovation award nominee
November 2008
Number 2		 Sub-queries allow the execution of complex database queries that may be hard to read and understand.

This class can parse an SQL query with eventual nested sub-queries. It returns an array structure that is easier to read and understand.

Manuel Lemos
Picture of François NEUMANN-RYSTOW
Name: François NEUMANN-RYSTOW <contact>
Classes: 3 packages by
Country: France France
Age: 44
All time rank: 119340 in France France
Week rank: 192 Up13 in France France Up
Innovation award
Innovation award
Nominee: 2x

Winner: 1x

  Files folder image Files (3)  
File Role Description
Accessible without login Plain text file dqml2tree.php Class Class File to include in your php script.
Accessible without login Plain text file example.php Example show how to use the class
Plain text file exploitation_example.php Example more precise examples !

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloaddqml2tree-2018-03-27.zip 5KB
Downloaddqml2tree-2018-03-27.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,062
This week:0
All time:1,903
This week:455Up
User Ratings User Comments (3)
 All time
Utility:77%StarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:-
Examples:69%StarStarStarStar
Tests:-
Videos:62%StarStarStarStar
Overall:60%StarStarStarStar
Rank:1169
 
This does not work.
12 years ago (Peter Mead)		22%StarStar
Great job.
14 years ago (Glauco)		75%StarStarStarStar
Bon script et bonne vision du web et de la pollution marketing .
14 years ago (comic)		80%StarStarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.