PHP Classes
elePHPant
Icontem

Ses Query: Manipulate records retrieved with select queries

Recommend this page to a friend!
  Info   View files View files (16)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2013-08-25 (3 years ago) RSS 2.0 feedNot enough user ratingsTotal: 317 All time: 6,863 This week: 1,282Up
Version License PHP version Categories
ses-query 1.0GNU General Publi...5.3PHP 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
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
Innovation award
Innovation award
Nominee: 2x

  Files folder image Files  
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  /  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  /  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  /  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  /  classes  /  library  
File Role Description
  Accessible without login Plain text file util.php Class Some util methods

  Files folder image Files  /  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  /  classes  /  parser  /  exceptions  
File Role Description
  Accessible without login Plain text file parser-exception.php Class Custom Exception

 Version Control Unique User Downloads Download Rankings  
 0%
Total:317
This week:0
All time:6,863
This week:1,282Up
User Comments (2)
good
3 years ago (Rahul Shambharkar)
70%StarStarStarStar
This is a very good and useful class ;-)
3 years ago (José Filipe Lopes Santos)
70%StarStarStarStar