292296 PHP MySQL Error / Logging
N/A
Paid on delivery
Looking for:
1) A object oriented PHP "[url removed, login to view]" 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 "[url removed, login to view]"
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 "[url removed, login to view]")
Log file name should follow "[url removed, login to view]" 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 [url removed, login to view]
4) A PHP page "[url removed, login to view]" 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 "[url removed, login to view]" 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 "[url removed, login to view]"
-Admin page
-URL of sample error log file
Notes:
PHP Version 5.2.6
MySQL version: [url removed, login to view]
PEAR code style
heavily commented code expected
Project ID: #2038599