SQL Parse Convert to Tree Array (sql)

Name:	SQL Parse Convert to Tree Array Support forum
Base name:	`dqml2tree`
Description:	Build a tree to represent an SQL query
Related top rated classes:	sql
Version:	`0.12`
Required PHP version:	`4.4`
License:	Public Domain
All time users:	1027 users
All time rank:	2437
Week users:	5 users
Week rank:	1439

	Tutorials		Author		Groups		Detailed description

	User ratings		Applications		Files

Tutorial videos and presentations

Title	Description	Duration
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`

Author

Name:	François NEUMANN-RYSTOW `<e-mail contact>`
Published packages:	2 Browse this author's classes
Country:	France - PHP jobs in France
Home page:	`http://www.iuki.com/`
Age:	29
All time rank:	1364
Week rank:	979

Innovation Award

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

Groups

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

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.

User ratings

Ratings	Utility	Consistency	Documentation	Examples	Tests	Videos	Overall	Rank
All time:	`Good (91.7%)`	`Good (83.3%)`	`-`	`Sufficient (75.0%)`	`-`	`Sufficient (75.0%)`	`Sufficient (69.2%)`	198
Month:	There are not enough user ratings to display for this class.

Applications that use this class

No application links were specified for this class.

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

Files

File	Role	Description
`dqml2tree.php`	Class	Class File to include in your php script.
`example.php`	Example	show how to use the class
`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.

Copyright (c) Icontem 1999-2009	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products

Class: SQL Parse Convert to Tree Array