Login   Register  
PHP Classes
elePHPant
Icontem

Ses Query: Manipulate records retrieved with select queries

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 (1 year ago) RSS 2.0 feedNot enough user ratingsTotal: 314 All time: 6,449 This week: 1,837Up
Version License PHP version Categories  
ses-query 1.0GNU General Public Lice...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: 6 packages by
Country: Spain Spain
Age: 40
All time rank: 155033 in Spain Spain
Week rank: 479 Up19 in Spain Spain Up
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)
  Plain text file database.php Class Database class
  Plain text file db-column.php Class DBColumn class
  Plain text file db-parser.php Class DBParser class
  Plain text file db-query.php Class DBQuery class
  Plain text file db-table.php Class DBTable class

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

  Files folder image Files  /  classes  /  library  
File Role Description
  Plain text file util.php Class Some util methods

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

  Files folder image Files  /  classes  /  parser  /  exceptions  
File Role Description
  Plain text file parser-exception.php Class Custom Exception

 Version Control Unique User Downloads Download Rankings  
 0%Total:314All time:6,449
 This week:0This week:1,837Up
 User Comments (2)  
 
good
11 months ago (Rahul Shambharkar)
70%StarStarStarStar
This is a very good and useful class ;-)
11 months ago (Josť Filipe Lopes Santos)
70%StarStarStarStar