Line numbers

[piersk]

When you use the

...or die(mysql_error());

code and then you get an error, you will get a message telling you what is going wrong. This is all well and good, but it doesn't show you the line number where this error is occuring.

Is it possible to get PHP to report the line number where the mySQL error is happening?

[The_Chancer]

Might work using:

or trigger_error ("MySQL error nr ".mysql_errno().": ".mysql_error(), E_USER_ERROR);

instead of using the

or die

function..

Possibly ?

[tomhath]

Or the LINE constant (note the double underscores)

[ednark]

if you want this detailed error checking (which you should)

you might be better wrapping this up into a function or even an object...

now you would of course want more than just printing the line out, like email yourself the error, or log it specially... or something....by wrapping this up in a function... and using this for all the errors you expect... you can even throw in a feature that prints out to the screen during debug... and then in production just flip it off in one place...

function myError( $message, $file, $line )
{
    die("Error in $file on line $line: $message");
}

do_this or myError('basic error',__FILE__,__LINE__);

you may even want to wrap this up in a class and call it statically...

class MyError
{

  function throw( $message, $file, $line )
  {
       echo "Error in $file on line $line: $message";
  }

  function fatal( $message, $file, $line  ) 
  {
        MyError::throw($message, $file, $line);
        die();
  }

}