Login   Register  
PHP Classes
elePHPant
Icontem

Class: 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
  Classes of François NEUMANN-RYSTOW  >  SQL Parse Convert to Tree Array  >  Download .tar.gz .zip  >  Support forum Support forum (11)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: SQL Parse Convert to Tree Array
Support forum Support forum
Base name: dqml2tree
Description: Build a tree to represent an SQL query
Related classes: , , , , , , ,
Version: 0.12
PHP version: 4.4
License: Public Domain
All time users: 1678 users
All time rank: 1946
Week users: 4 users
Week rank: 1006
Picture of François NEUMANN-RYSTOW
Author: François NEUMANN-RYSTOW <e-mail contact>
Packages: 2 Browse this author's classes Browse this author's classes
Country: France France - PHP jobs in France
Age: 31
All time rank: 123341 in France France
Week rank: 874 Up34 Up in France France
Innovation award
Innovation award
Nominee: 1x


  Detailed description  
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.

 

  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

  Video Tutorials   Rate classes User ratings   Applications   Files Files  

  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%)
636
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.