PHP Classes

Ses Query: Manipulate records retrieved with select queries

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 58%Total: 319 All time: 7,239 This week: 455Up
Version License PHP version Categories
ses-query 1.0GNU General Publi...5.3PHP 5, Databases
Description 

Author

Gonzalo Chumillas

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
PHP Programming Innovation award nominee
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
Picture of Gonzalo Chumillas
Name: Gonzalo Chumillas <contact>
Classes: 8 packages by
Country: Spain Spain
Age: 50
All time rank: 135129 in Spain Spain
Week rank: 227 Up8 in Spain Spain Up
Innovation award
Innovation award
Nominee: 2x

  Files folder image Files (16)  
File Role Description
Files folder imageclasses (3 directories)
Accessible without login Plain text file create-database.php Example Create a database to illustrate the examples
Accessible without login Plain text file test.php Example Several examples

  Files folder image Files (16)  /  classes  
File Role Description
Files folder imagedatabase (5 files, 1 directory)
Files folder imagelibrary (1 file)
Files folder imageparser (2 files, 1 directory)

  Files folder image Files (16)  /  classes  /  database  
File Role Description
Files folder imageexceptions (5 files)
  Accessible without login Plain text file database.php Class Database class
  Accessible without login Plain text file db-column.php Class DBColumn class
  Accessible without login Plain text file db-parser.php Class DBParser class
  Accessible without login Plain text file db-query.php Class DBQuery class
  Accessible without login Plain text file db-table.php Class DBTable class

  Files folder image Files (16)  /  classes  /  database  /  exceptions  
File Role Description
  Accessible without login Plain text file ambiguous-column-db-exception.php Class Custom Exception
  Accessible without login Plain text file column-not-editable-db-exception.php Class Custom Exception
  Accessible without login Plain text file column-not-found-db-exception.php Class Custom Exception
  Accessible without login Plain text file db-exception.php Class Custom Exception
  Accessible without login Plain text file query-not-editable-db-exception.php Class Custom Exception

  Files folder image Files (16)  /  classes  /  library  
File Role Description
  Accessible without login Plain text file util.php Class Some util methods

  Files folder image Files (16)  /  classes  /  parser  
File Role Description
Files folder imageexceptions (1 file)
  Accessible without login Plain text file parser.php Class Parser class
  Accessible without login Plain text file tokenizer.php Class Tokenizer class

  Files folder image Files (16)  /  classes  /  parser  /  exceptions  
File Role Description
  Accessible without login Plain text file parser-exception.php Class Custom Exception

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadses-query-2013-08-25.zip 22KB
Downloadses-query-2013-08-25.tar.gz 16KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:319
This week:0
All time:7,239
This week:455Up
User Ratings User Comments (2)
 All time
Utility:83%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:-
Examples:83%StarStarStarStarStar
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1502
 
good
11 years ago (Rahul Shambharkar)		70%StarStarStarStar
This is a very good and useful class ;-)
11 years ago (José Filipe Lopes Santos)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

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