Or you can use the error_log functions within your function, instead of
fopen/fwrite/fclose.
---John Holmes...
> The easiest way to do this would be to write a wrapper function to
> mysql_query() that does the writing to the log file and also executes the
> query and returns the result set.
>
> function my_mysql_query($query)
> {
> //assuming file would already be open...
> global $fp;
>
> $return = mysql_query($query);
> $error = mysql_error();
>
> fwrite($fp,"info you want to save");
>
> return $return;
> }
>
> Can be improved upon many many ways I'm sure...just an idea.
>
> ---John Holmes...
>
> ----- Original Message -----
> From: "PHPCoder" <[EMAIL PROTECTED]>
> To: "php-general" <[EMAIL PROTECTED]>
> Sent: Monday, July 22, 2002 2:30 PM
> Subject: [PHP] MySQL - PHP combined log
>
>
> > Hi, tried this on mysql list, no luck:
> >
> > I want to be able to view a single log that contains the following:
> >
> > IP of user : page_name (PHP only): time/date: MySQL query ( 'select *
> > from xxx' etc.) : error msg from mysql/php if any
> >
> > So it's almost a hybrid between apache and mysql with some extra's
> >
> > I'm sure you all should see the benifit of this in troubleshooting and
> > specially keeping track of who does what when it comes to PHP coding on
> > ones server, specially with crappy code that kills the server.
> >
> > Is something like this possible, already there?
> >
> > PS, Running RedHat 7.0 with PHP4 and mysql 3.23.x
> >
> > Ta
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
