how to get a detailed error report when a php-mysql script fails?

Question

How do i get a detailed error description during a php-mysql script run?

I have the following statements where the script fails and displays the custom error message - the contents of the "or die".

I want to get the actual error from MySQL (instead of the custom error i have mentioned), which would give better idea about the scenario - whether its a database issue or server connectivity issue etc..

this is the code i have where i need to enhance the error reporting

$query = "SELECT * FROM table_name";
$result = mysqli_query($db_conn, $query) 
  or die('Connected to database, but querying failed');

thanks!

Babiker · Accepted Answer · 2011-05-22 20:16:53Z

4

Check out mysql_error function.

answered May 22, 2011 at 20:16

Babiker

18.9k28 gold badges83 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

onteria_ Over a year ago

mysqli_error error actually: mysqli_query($db_conn, $query)

arun nair Over a year ago

@onteria_ : I was trying mysqli_error in the procedural format for the above connection and query, but it is always returning error saying mysqli_error needs exactly one "xxxxx", but zero supplied... (where xxxx varies, sometimes object, sometimes string etc..).. Could you please help me out with the query here.. I would want it to give the php error message (and not my custome die message) when the querying fails. thanks a lot!

Community · Accepted Answer · 2023-11-17 19:32:19Z

1

Have a look at the manual page for mysqli_error. In the section "Procedural style" you'll find a complete example that shows how to set up the database connection and querying the database, both steps with error handling.

If you want detailed error information from your scripts you can put the lines

error_reporting( E_ALL );
ini_set('log_errors', true);
ini_set('error_log', '/tmp/php-errors.log');

at the start of your code. That way all errors coming from PHP will be written into the log file. Make sure that the path to the log file exists (/tmp is only an example) and is writable by the web server, otherwise the errors will be silently discarded.

As a side note: While the "or die()" pattern is good for small examples, you should not use it in production code.

edited Nov 17, 2023 at 19:32

CommunityBot

11 silver badge

answered May 23, 2011 at 8:22

chiborg

28.4k15 gold badges102 silver badges120 bronze badges

Comments

Daniel · Accepted Answer · 2011-05-22 20:31:03Z

0

I prefer using PDO, and having PDO throw an exception.

answered May 22, 2011 at 20:31

Daniel

7,2027 gold badges46 silver badges51 bronze badges

Comments

Harry Martland · Accepted Answer · 2011-05-22 20:41:10Z

0

you could insert the query into the query page on phpmyadmin that is if you are using it. But this wont tell you if the errors are with the variables

answered May 22, 2011 at 20:41

Harry Martland

6242 gold badges14 silver badges27 bronze badges

Collectives™ on Stack Overflow

how to get a detailed error report when a php-mysql script fails?

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related