PHP Try and Catch for SQL Insert

Question

I have a page on my website  high traffic  that does an insert on every page load   I am curious of the fastest and safest way to  catch an error  and continue if the system is not able to do the insert into MySQL   Should I use try catch or die or something else   I want to make sure the insert happens but if for some reason it can t I want the page to continue to load anyway        db   mysql select db  mobile    conn   mysql query  INSERT INTO redirects SET ua string     ua string    or die  Error  10    mysql close  conn

User · Answer

sql    INSERT INTO   customer FIELDS VALUES VALUES        mysql query  sql       if  mysql errno                      echo   lt script gt alert  License already registered   location replace  customerform html    lt  script gt

User · Answer

You can implement throwing exceptions on mysql query fail on your own  What you need is to write a wrapper for mysql query function  e g       user defined  corresponding MySQL errno for duplicate key entry const MYSQL DUPLICATE KEY ENTRY   1022      user defined MySQL exceptions class MySQLException extends Exception    class MySQLDuplicateKeyException extends MySQLException     function my mysql query  query   conn false         res   mysql query  query   conn       if    res             errno   mysql errno  conn            error   mysql error  conn           switch   errno            case MYSQL DUPLICATE KEY ENTRY              throw new MySQLDuplicateKeyException  error   errno               break          default              throw MySQLException  error   errno               break                                    doing something                if   something is wrong            throw new Exception  Logic exception while performing query result processing              try       mysql query  INSERT INTO redirects SET ua string     ua string      catch  MySQLDuplicateKeyException  e           duplicate entry exception      e- gt getMessage      catch  MySQLException  e           other mysql exception  not duplicate key entry       e- gt getMessage      catch  Exception  e           not a MySQL exception      e- gt getMessage

User · Answer

Use any method described in the previous post to somehow catch the mysql error  Most common is    res   mysql query  bla    if   res   false        error   die        normal page   This would also work   function error         error   die      res   mysql query  bla   or error      normal page   try         catch  Exception  e           will not work   Note  Not directly related to you question but I think it would much more better if you display something usefull to the user  I would never revisit a website that just displays a blank screen or any mysterious error message

User · Answer

This can do the trick   function createLog  data         file    Your path incompletejobs txt        fh   fopen  file   a   or die  can t open file        fwrite  fh  data       fclose  fh      qry  INSERT INTO redirects SET ua string     ua string       result mysql query  qry   if   result       createLog mysql error

User · Answer

Elaborating on yasaluyari s answer I would stick with something like this   We can just modify our mysql query as follows   function mysql catchquery  query  emsg  Error submitting the query        if   result mysql query  query   return  result      else throw new Exception  emsg       Now we can simply use it like this  some good example   try       mysql catchquery  CREATE TEMPORARY TABLE a  ID int 6          mysql catchquery  insert into a values 666   418   93         mysql catchquery  insert into b ID  name  select a ID  c name from a join c on a ID c ID         result mysql catchquery  select   from d where ID 7777777        while   tmp mysql fetch assoc  result             catch  Exception  e        echo  e- gt getMessage        Note how beautiful it is  Whenever any of the qq fails we gtfo with our errors  And you can also note that we don t need now to store the state of the writing queries into a  result variable for verification  because our function now handles it by itself  And the same way it handles the selects  it just assigns the result to a variable as does the normal function  yet handles the errors within itself   Also note  we don t need to show the actual errors since they bear huge security risk  especially so with this outdated extension  That is why our default will be just fine most of the time  Yet  if we do want to notify the user for some particular query error  we can always pass the second parameter to display our custom error message

User · Answer

if you want to log the error etc you should use try catch  if you dont  just put   before mysql query  edit    you can use try catch like this  so you can log the error and let the page continue to load   function throw ex  er       throw new Exception  er         try     mysql connect localhost  user   pass     mysql select db  test      q   mysql query  select   from asdasda   or throw ex mysql error           catch exception  e      echo  ex     e

User · Answer

Checking the documentation shows that its returns false on an error  So use the return status rather than or die    It will return false if it fails  which you can log  or whatever you want to do  and then continue    rv   mysql query  INSERT INTO redirects SET ua string     ua string     if    rv     false           handle the error here     page continues loading

User · Answer

mysqli report MYSQLI REPORT ERROR   MYSQLI REPORT STRICT     I am not sure if there is a mysql version of this but adding this line of code allows throwing mysqli sql exception  I know  passed a lot of time and the question is already checked answered but I got a different answer and it may be helpful

User · Answer

new user   new User  user    mapper    this- gt spot- gt mapper  App User     try       id    mapper- gt save  new user         catch Exception  exception         data  error     true       data  message      Error while insertion  Erron in the query        data  data      exception- gt getMessage         return  response- gt withStatus 409      - gt withHeader  Content-Type    application json       - gt write json encode  data  JSON UNESCAPED SLASHES   JSON PRETTY PRINT                if error occurs  you will get something like this-          error   true       message    Error while insertion  Erron in the query        data    An exception occurred while executing  INSERT INTO   user         VALUES        with params        n nSQLSTATE 22P02   Invalid text representation  7 ERROR   invalid input syntax for integer    default        with status code 409

[php] PHP Try and Catch for SQL Insert

Examples related to php

Examples related to mysql

Examples related to performance

Examples related to error-handling