Jump to content

Archived

This topic is now archived and is closed to further replies.

bach

To a FILE

Recommended Posts

Hello,

I would like to create a function/class (not sure which one appropriate) to log errors to a file.

To start with I would like to create a 'errorlog.txt' file where every mysql error message will be writen so I would be able to check the error log to see if anyone has been having issues login into database, etc.

Now I have the mysql error being displayed as part of my connection but I do not want the user to see this message.

So I would need to store that into a file instead I have no idea on this anyone able to help ?

Bach.

Share this post


Link to post
Share on other sites
wrap your sql query in a function and use this in all your queries
inside the function, perform the query, then test if there were any errors then log them

[code]

function db_query($qry)
{
    $result = @mysql_query($qry);
    if (mysql_errno() > 0)
    {
        // log error to file here
        // and/or perform some error handling
        // you can be creative on this part but be wary of some overheads
    }
    
        return $result;    
    
}
[/code]

Share this post


Link to post
Share on other sites


Thanks for yor reply,

How would I go about writing the log to the file?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.