How to display errors for my MySQLi query? [duplicate]

by

Just simply add or die(mysqli_error($db)); at the end of your query, this will print the mysqli error.

 mysqli_query($db,"INSERT INTO stockdetails (`itemdescription`,`itemnumber`,`sellerid`,`purchasedate`,`otherinfo`,`numberofitems`,`isitdelivered`,`price`) VALUES ('$itemdescription','$itemnumber','$sellerid','$purchasedate','$otherinfo','$numberofitems','$numberofitemsused','$isitdelivered','$price')") or die(mysqli_error($db));

As a side note I’d say you are at risk of mysql injection, check here How can I prevent SQL injection in PHP?. You should really use prepared statements to avoid any risk.

More Related Contents:

  1. mysqli or PDO – what are the pros and cons? [closed]
  2. Commands out of sync; you can’t run this command now
  3. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  4. MySQL vs MySQLi when using PHP [closed]
  5. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  6. When should I use MySQLi instead of MySQL?
  7. Example of how to use bind_result vs get_result
  8. mysqli::query(): Couldn’t fetch mysqli
  9. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  10. PHP MySQLI Prevent SQL Injection [duplicate]
  11. What is the difference between MySQL, MySQLi and PDO? [closed]
  12. How to test if a MySQL query was successful in modifying database table data?
  13. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  14. How can I use mysqli_fetch_array() twice?
  15. PHP Commands Out of Sync error
  16. Mysql No connection could be made because the target machine actively refused it
  17. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  18. using nulls in a mysqli prepared statement
  19. How to connect to MySQL database in PHP using mysqli extension?
  20. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  21. Fatal error: Call to undefined function mysqli_result()
  22. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  23. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  24. Strange problem with the length of the field gotten from database [duplicate]
  25. PHP: mysql v mysqli v pdo [closed]
  26. How do I ensure I caught all errors from MySQLi::multi_query?
  27. Mysqli multiple row insert, simple multi insert query [duplicate]
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. How to get a list of databases?
  30. Why cannot the PHP hide the error message thrown by the MySQL connection?

Leave a Comment