Error Log

[NZ_Kiwis]

Hi,

i want to create a txt file which all my MySQL errors are recored into with the full URL.

How can this be done?

[esukf]

Try something like this. Make sure you set write permisson for the file u writing to.

<?php

function write_log() {
		$text = "\n[".date("Y-m-d H:i:s")."] ".$_SERVER['PHP_SELF']." ".mysql_error();
		$file = "C:\log.txt";

	if (@!$file_handle = fopen($file,"a")) { 
		echo "file cannot be opened";			
	}
	if (@!fwrite($file_handle, $text)) 
	{ 
		echo "file cannot be written";			
	}			
	@fclose($file_handle);		
}



$conn = @mysql_connect('localhost', 'root', 'password');
if(!$conn){
	write_log();
}

$db = @mysql_select_db('foo', $conn);
if (!$db) {
   write_log();
}
?>

[MarkR]

Or you could write an error handler (set with set_error_handler) which is executed on any warning, error or notice - and make that log everything. Be sure to have error_reporting(E_ALL) on.

To further avoid reinventing the wheel, you could use PHP's error_log() - which logs to wherever it's configured to do.

Then you have to learn to stop using the @ operator anywhere - but at least, you don't ever have to check the result of mysql_query, as if it fails it will kick your error logger in automatically.

This approach has the advantage that it will also detect any non-MySQL errors, and it requires the minimum of code (i.e. NO error checking code on a per-call basis).

It's what we use throughout.

Mark

[esukf]

Wished i came across that error_log() function before.