PHP Classes

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    
Ratings Unique User Downloads Download Rankings
StarStarStar 58%Total: 318 This week: 1All time: 7,237 This week: 89Up
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
Age: 49
All time rank: 135129 in Spain Spain
Week rank: 91 Up4 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)
  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:318
This week:1
All time:7,237
This week:89Up
User Ratings User Comments (2)
 All time
Utility:83%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:-
Examples:83%StarStarStarStarStar
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1489
 
good
10 years ago (Rahul Shambharkar)
70%StarStarStarStar
This is a very good and useful class ;-)
10 years ago (José Filipe Lopes Santos)
70%StarStarStarStar