Login   Register  
PHP Classes
elePHPant
Icontem

SQL Parse Convert to Tree Array

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

  Author  
Picture of François NEUMANN-RYSTOW
Name: François NEUMANN-RYSTOW <e-mail contact>
Packages: 2 Browse all classes by François NEUMANN-RYSTOW Browse all classes by
Country: France France - PHP jobs in France
Age: 32
All time rank: 123540 in France France
Week rank: 1064 Up28 in France France Up
Innovation award
Innovation award
Nominee: 1x


  Detailed description   Download .zip .tar.gz  
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 .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: 1835 users
All time rank: 1911
Week users: 2 users
Week rank: 1296 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  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Sufficient (78.6%)
Good (85.7%)
-
Sufficient (75.0%)
-
Sufficient (70.8%)
Sufficient (62.4%)
676
Month:
Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
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 !

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.