SQL Parse Convert to Tree Array

Recommend this page to a friend!

Stumble It!

Bookmark in del.icio.us

Classes of François NEUMANN-RYSTOW

SQL Parse Convert to Tree Array

Download .tar.gz .zip

Support forum (11)

Blog

Latest changes

Name:	SQL Parse Convert to Tree Array Support forum
Base name:	`dqml2tree`
Description:	Build a tree to represent an SQL query
Related classes:	sql, sql query, sql class, SQL parse, file tree, tree structure, parse sql, sql file
Version:	`0.12`
PHP version:	`4.4`
License:	Public Domain
All time users:	1731 users
All time rank:	1918
Week users:	2 users
Week rank:	1632

	Author

Name:	François NEUMANN-RYSTOW `<e-mail contact>`
Packages:	2 Browse all classes by François NEUMANN-RYSTOW
Country:	France - PHP jobs in France
Age:	31
All time rank:	1231	41 in France
Week rank:	1226	35 in France

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		Tutorials		User ratings		Applications		Files

	Groups

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

	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`

	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%)`	648
Month:	Not yet rated by the users

	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.