inserting php errors into mysql 1

[pushyr]

just a quickie...

i get this php error and would like to know if it's possible to insert such an error into mysql?

Warning: fopen([URL unfurl="true"]http://www.mysite.com)[/URL] [function.fopen]: failed to open stream: HTTP request failed! HTTP/1.1 400 Bad Request in /file/script/index.php on line 739
cannot open file

 

[jpadie]

yes.
create a table for the following fields and then use this script

create table errorTable (
errorID int(10) auto_increment primary key,
errno int(5),
errstr varchar (255),
errfile varchar (255),
errline int (6)
)

<?php
set_error_handler('myErrorHandler', E_WARNING | E_NOTICE );

function myErrorHandler ($errno, $errstr, $errfile, $errline, $errcontext) {
	//assume database connection string and suitable table
	
	//insert into database
	$query = "Insert into errorTable (eventID, errorno, errstr,errfile, errline) values (null, '%s', '%s', '%s', '%s')";
	$result = @mysql_query (sprintf(	$query, 
								$errno, 
								mysql_real_escape_string($errorstr), 
								mysql_real_escape_string($errfile), 
								$errline));
	if (!$result) {echo 'db write went wrong. ' . mysql_error();}
	//say whatever you want about the error
	//and exit if you want to
	return false; //to populate php_error_msg
}
?>

 

[pushyr]

cheers jpadie! sorted!!!