Class: SQL Parse Convert to Tree Array

Name:	SQL Parse Convert to Tree Array Support forum
Base name:	`dqml2tree`
Description:	Build a tree to represent an SQL query
Version:	`0.12`
Required PHP version:	`4.4`
License:	Public Domain
All time users:	437 users
All time rank:	3419
Week users:	114 users
Week rank:	11

	Videos		Supplied by		Groups		Detailed description

	User ratings		Applications		Files

Tutorial videos:

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

Supplied by:

Name:	François NEUMANN-RYSTOW `<e-mail contact>`
Published packages:	1
Country:	France - PHP jobs in France
Home page:	`http://www.iuki.com/`
Age:	28
All time rank:	1860
Week rank:	23

Browse this author's classes

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 (83.3%)`	`Good (83.3%)`	`-`	`Sufficient (66.7%)`	`-`	`-`	`Not sure (56.7%)`	813
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

Tutorial videos:

Supplied by:

Innovation Award:

Groups:

Detailed description:

User ratings:

Applications that use this class:

Files: