Looking for:

1) A object oriented PHP "log.inc.php" include file to log Javascript, PHP, and MYSQL errors and events to a MYSQL table AND a log file (and should complete even if MYQSL is down). It should capture / override standard PHP error function and be callable.

Database should capture:
error_id INT autoincrement primary key
error_datetime DATETIME
user_id INT
page_of_error varchar(255)
line_of_error tinyint
error_type char(4) #should list HTML, PHP, SQL
error_message varchar(255)
error_severity char(3) #low, med, bad
handled char(1) #default is NULL handled is "y"
...anything else you recommend

2) Database table design as a mySQL CREATE TABLE statement

3)
Log files location should be set in config file "log.ini"
Log file should be simple tab delimited text file, matching table layout.
Log file logging should have logic to create new file if it exceeds 1 Meg (please make this a constant,in config file "log.ini")
Log file name should follow "log_2009_MM_DD_HH_MM_SS.txt" where date time is date created
Each new log file should have the first line containing the table headers

If an error is BAD or error cannot be written to MYSQL or Log file send a MAIL to a mail address error at somedomain.com


4) A PHP page "log.php" that receives a GET message with the above error fields that uses the above module to save to Db and log as above -to enable javascript error logging.

5) An Admin PHP page "log_admin.php" that displays a HTML table of the errors
The "handled" text in the table should be linked to enable the user to update the error row as "handled". this reloads the page and displays the new status.
Pages should show 100 rows per page, with navigation to move back, forward, first , last


To complete job and release Escrow, please demonstrate running code on a server with
-a simple page that produces several PHP and Mysql errors, a HTML form to log a message via "log.php"
-Admin page
-URL of sample error log file



Notes:
PHP Version 5.2.6
MySQL version: 5.0.67
PEAR code style
heavily commented code expected