Login   Register  
PHP Classes
elePHPant
Icontem

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

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of François NEUMANN-RYSTOW
Name: François NEUMANN-RYSTOW <contact>
Classes: 3 packages by
Country: France France
Age: 33
All time rank: 113638 in France France
Week rank: 291 Up16 in France France Up
Innovation award
Innovation award
Nominee: 2x

Winner: 1x


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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.

  Classes of François NEUMANN-RYSTOW  >  SQL Parse Convert to Tree Array  >  Download Download .zip .tar.gz  >  Support forum Support forum (11)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: SQL Parse Convert to Tree Array
Base name: dqml2tree
Description: Build a tree to represent an SQL query
Version: 0.12
PHP version: 4.4
License: Public Domain
All time users: 1923 users
All time rank: 1902
Week users: 3 users
Week rank: 574 Up
 
  Groups   Video Tutorials   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Text processing Manipulating and validating text data View top rated classes


  Tutorial videos and presentations  
php script sql query parser sql2tree
Title Description Duration
Video php script sql query parser sql2tree http://www.phpclasses.org/browse/package/4916.html Build a tree to represent an SQL query ! Vide... 00:09:01

  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

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Sufficient (78%) Good (85%) - Sufficient (75%) - Sufficient (70%) Sufficient (62%) 698
Month: Not yet rated by the users

  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.
  Files folder image Files  
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 !

Install with Composer Install with Composer - Download Download all files: dqml2tree.tar.gz dqml2tree.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.