Jump to content

To a FILE


bach

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.
Link to comment
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]
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.