How to check if a MySQL query using the legacy API was successful

Question

How do I check if a MySQL query is successful other than using die    I m trying to achieve     mysql query  query    if success     move file   else if fail     display error

User · Answer

If your query failed  you ll receive a FALSE return value  Otherwise you ll receive a resource TRUE    result   mysql query  query    if   result          check for error  die  etc        Basically as long as it s not false  you re fine  Afterwards  you can continue your code   if   result    This part of the code actually runs your query

User · Answer

This is the first example in the manual page for mysql query    result   mysql query  SELECT   WHERE 1 1    if    result        die  Invalid query      mysql error         If you wish to use something other than die  then I d suggest trigger error

User · Answer

if using MySQLi bind param try to put this line above the query   mysqli report MYSQLI REPORT ERROR   MYSQLI REPORT STRICT

User · Answer

mysql query function is used for executing mysql query in php  mysql query returns false if query execution fails Alternatively you can try using mysql error   function For e g   result mysql query  sql    or  die mysql error       In above code snippet if query execution fails then it will terminate the execution and display mysql error while execution of sql query

User · Answer

put only    or die mysqli error      after your query  and it will retern the error as echo   example      Your Query  means you can put  Select Update Delete Set  queries here  qfetch   mysqli fetch assoc mysqli query  your query    or die mysqli error             if  mysqli errno              echo  error    mysqli error            die

User · Answer

You can use mysql errno   for this too     result   mysql query  query    if mysql errno         echo  MySQL error   mysql errno                  mysql error     n lt br gt When executing  lt br gt  n query n lt br gt

[php] How to check if a MySQL query using the legacy API was successful?

Examples related to php

Examples related to mysql