Ses Query: Manipulate records retrieved with select queries

Recommend this page to a friend!

Download .zip

Info

View files (16)

Download .zip

Reputation

Support forum (2)

Blog

Links

Last Updated		Ratings				Unique User Downloads		Download Rankings
2013-08-25 (3 years ago)		Not enough user ratings				Total: 317		All time: 6,863 This week: 1,282

Version		License		PHP version		Categories
`ses-query` 1.0		GNU General Publi...		5.3		PHP 5, Databases

Description Author

This package can manipulate records retrieved with select queries.

It can execute SELECT queries to MySQL databases and return the query result rows.

It can also parse the query SQL, so it can determine involved tables and fields, so it can update the respective table records with new values or delete those table records.

Innovation Award

September 2013
Number 2

Very often applications use SQL SELECT queries to retrieve data from databases to be edited and updated using UPDATE queries,

This class can update data stored in database table records retrieved with SELECT queries.

The class parses the SELECT queries to determine what tables and fields are involved, so it can build the UPDATE or DELETE queries.

Manuel Lemos

Gonzalo Chumillas

Name:	Gonzalo Chumillas `<contact>`
Classes:	8 packages by Gonzalo Chumillas
Country:	Spain

Innovation award

Nominee: 2x

Files

File	Role	Description
`classes` (3 directories)
`create-database.php`	Example	Create a database to illustrate the examples
`test.php`	Example	Several examples

File	Role	Description
`database` (5 files, 1 directory)
`library` (1 file)
`parser` (2 files, 1 directory)

File	Role	Description
`exceptions` (5 files)
`database.php`	Class	Database class
`db-column.php`	Class	DBColumn class
`db-parser.php`	Class	DBParser class
`db-query.php`	Class	DBQuery class
`db-table.php`	Class	DBTable class

File	Role	Description
`ambiguous-column-db-exception.php`	Class	Custom Exception
`column-not-editable-db-exception.php`	Class	Custom Exception
`column-not-found-db-exception.php`	Class	Custom Exception
`db-exception.php`	Class	Custom Exception
`query-not-editable-db-exception.php`	Class	Custom Exception

File	Role	Description
`util.php`	Class	Some util methods

File	Role	Description
`exceptions` (1 file)
`parser.php`	Class	Parser class
`tokenizer.php`	Class	Tokenizer class

File	Role	Description
`parser-exception.php`	Class	Custom Exception

	ses-query-2013-08-25.zip 22KB
	ses-query-2013-08-25.tar.gz 15KB
	Install with Composer

Version Control

Unique User Downloads

Download Rankings

Total:	317
This week:	0

All time:	6,863
This week:	1,282

User Comments (2)

good 3 years ago (Rahul Shambharkar)	70%
This is a very good and useful class ;-) 3 years ago (José Filipe Lopes Santos)	70%

Applications that use this package

No pages of applications that use this class were specified.

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

Advertise on this site

For more information send a message to info at phpclasses dot org.