Get line number

pmcnally

I am creating an error function for my MySQL queries that e-mails me and returns an error message on the page.

Using PHP4, how can I return the line number of the query? Note, not the line number that mysql_error returns, but the line number in the actual .php file?

Thx -Pat

Installer

A stab in the dark: you could build an array of the line numbers for the queries, then have your mailing function parse the message for the line number it gives and add the appropiate one from the array (e.g. closest lower l.n.).

Roger_Ramjet

Embed it in your code.

$result =  mysql_query($sql);
if (!$result) {
   error_function('pass what ever you need including line number');
   echo 'whatever you want in the way of a message';
   exit; // ?? or die or whatever
   }

Have a look at the manual for mysql query, there are some good code snippets for this sort of thing.

Weedpacket

Originally posted by Roger Ramjet
error_function('pass what ever you need including line number');
[/B]

And before you ask how you get the line number, that's one of these magic constants.

Roger_Ramjet

Since you are writing the code, you write it in the code in plain text. This is exactly the same as I do with my VB and Access error routines.


error_function($sql, "main.php, query 2, line 43", mysql_error(), "user message");

All my Access applications store the errors in a table for me so I can fault-find user reported errors easily, and tell what they were doing when it happened. I assume that you are trying to do the same thing. Write your general error reporting function so that it accepts what you need and pass the info every time you call it. Written properly, it will be resuable for the next 10 years in every project you write. In your case it will email you instead of saving in a db, so you should probably get it to also log the data on the server.

Roger_Ramjet

And I did not know about the magic constants Weedpacket, thanks. I should have read your post before replying again.

See. You can learn something every day here. Great isn't it.

Weedpacket

Originally posted by Roger Ramjet
See. You can learn something every day here. Great isn't it.

What I learned here about MySQL's error messages is that if the query spans more than one line, the error message will indicate which line of the query threw the error. Especially useful if there are a lot of conditionals &c.