need to test if sql query was successful

Question

I have this query and if it returns successful  I want another function to process  if not  do not process that function   Here is the code for running the query  global  DB   DB- gt query  UPDATE exp members SET group id     group id  WHERE member id     member id       I imagine it is something like     if  DB           success    else          failure

User · Answer

if   DB- gt query         success   else   failure     query should return false on failure  if you re using mysql query or  mysqli- query   If you want to test if the UPDATE query actually did anything  which is a totally different thing than  successful   then use mysql affected rows or  mysqli- affected rows

User · Answer

global  DB   status    DB- gt query  UPDATE exp members SET group id     group id  WHERE member id     member id      if  status    false         die  Didn t Update         If you are using mysql query in the backend  whatever  DB- gt query   uses to query the database   it will return a TRUE or FALSE for INSERT  UPDATE  and DELETE   and a few others   commands  based on their status

User · Answer

mysqli affected rows returns number of items affected

User · Answer

if you re not using the - gt  format  you can do this    a    SQL command      if   b   mysqli query  con  a          results was successful   else        result was not successful

User · Answer

This is the simplest way you could test   query    DB- gt query  UPDATE exp members SET group id     group id  WHERE member id     member id      if  query     will return true if succefull else it will return false      code here

User · Answer

if   DB- gt rowCount    gt  0         Update worked because query affected X amount of rows      else       error    DB- gt errorInfo

User · Answer

if the value is 0 then it wasn t successful  but if 1 then successful    this- gt db- gt affected rows

User · Answer

Check this    lt  php if  mysqli num rows mysqli query  con  sqlselectquery    gt  0        echo  found     else       echo  not found       gt    lt  ----comment ---for select query to know row matching the condition are fetched or not--- gt

User · Answer

You can use this to check if there are any results   result  from a query   if  mysqli num rows  result     0         results found    else        results not found

User · Answer

This has proven the safest mechanism for me to test for failure on insert or update    result    db- gt query           if   gettype  result      object   amp  amp   result- gt num rows    0       result       failure

User · Answer

mysql affected rows  I understand that by saying  successful  you want to know if any rows have been updated  You can check it with this function   If you use PDO -  http   www php net manual en pdostatement rowcount php

[php] need to test if sql query was successful

Examples related to php

Examples related to sql