Packages of Indrek Altpere
| Recommend this page to a friend! |
| All class groups | > | All authors | > | Packages of Indrek Altpere (3) | > | Mission progress status | > | Reputation |
|
||||||||||||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
| ||||
| This class provides something similar of Hibernate in java world by letting you map table rows into entity objects and making all the fields escaping work for you automatically when saving object to mysql. This class can be used as a base class to store and retrieve objects in MySQL databases. It is a base class that should be extended by other classes that define the MySQL database table and the fields to store and retrieve the object variables. It can execute SQL queries to retrieve objects and save them back to the database if any variable was changed. The class provides getter and setter functions to retrieve or change the object variable values. Objects remain cached in memory to avoid fetching the same objects from the database again. It also provides an iterator class (BaseObjectIterator) to iterate over large result sets without hogging up the memory. |
| ||||
| This class can be use to intercept and log PHP execution errors. It can enable PHP execution error logging setting the file that logs error messages. The class provides an error handler function that outputs a stack back-trace with the functions, arguments, file and lines of where an error occurs, as well the values of super-global variables $_GET, $_POST and $_FILES, and also the IP address of the current user accessing the site. The class may also enable of disable the output of error messages to Web pages and change the error reporting level. When used together with my Mysql class (or any other mysql class that calls trigger_error when there was mysql_error) it can effectively log all mysql errors with the complete stacktrace what you can inspect from the logfile later on. Plus you can identify sql injections when someone's queries keep failing with error messages. You can also specify error codes that exit the script execution plus your own callback function that will be called before exiting (good to display some nice error page to users before exiting script execution). |
| ||||
| This package implements a MySQL database access wrapper. There are two classes that provide the same functionality to access MySQL databases. One as a regular class and another that provide static functions so it is not necessary to create an object of the class to call it. It can: - Connect to MySQL database host delayed connections until the first query is run - Execute queries - Escape text literal values to use in SQL queries - Support transactions - Retrieve query results as a MySQL resource object, regular arrays and associative arrays - Collapse multiple rows into single level array - Retrieve the time spent on the last or all queries - Retrieve the count of rows that were selected or affected by the last or all queries - Retrieve the identifier of the last inserted row - Retrieve the count of row found total when SQL_CALC_FOUND_ROWS is used - Retrieve the names and explanation of tables and fields of a database - Retrieve the statistics about of all executed queries using the class - Retrieve large results with iterator class When used together with and error handler class/function that also logs stacktrace (like my ErrorManager class) you can get full stacktrace for mysql errors since it calls trigger_error on mysql error. |
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |
