How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]

by

Use this: 

mysqli_query($this->db_link, $query) or die(mysqli_error($this->db_link)); 
# mysqli_query($link,$query) returns 0 if there's an error.
# mysqli_error($link) returns a string with the last error message

You can also use this to print the error code.

echo mysqli_errno($this->db_link);

Take a look here and here

More Related Contents:

  1. inserting information and image in php and mysql
  2. mysqli or die, does it have to die?
  3. How to display errors for my MySQLi query? [duplicate]
  4. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  5. MySQL vs MySQLi when using PHP [closed]
  6. When should I use MySQLi instead of MySQL?
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. Example of how to use bind_result vs get_result
  9. mysqli::query(): Couldn’t fetch mysqli
  10. PHP MySQLI Prevent SQL Injection [duplicate]
  11. How to test if a MySQL query was successful in modifying database table data?
  12. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  13. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  14. How can I use mysqli_fetch_array() twice?
  15. PHP Commands Out of Sync error
  16. Advantages Of MySQLi over MySQL [closed]
  17. check if the query results empty row mysqli [duplicate]
  18. PHP PDO and MySQLi [duplicate]
  19. using nulls in a mysqli prepared statement
  20. Is mysql_real_escape_string() necessary when using prepared statements?
  21. Updating from MYSQL to MYSQLI [duplicate]
  22. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  23. How to prepare statement for update query? [duplicate]
  24. php password_verify() hash and pass won’t match
  25. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  26. PHP to MySQL SSL Connections
  27. Using Prepared Statement, how I return the id of the inserted row?
  28. Strange problem with the length of the field gotten from database [duplicate]
  29. PHP prepared statements and transactions in a loop [duplicate]
  30. Mysqli multiple row insert, simple multi insert query [duplicate]

Leave a Comment