Error handling in a php loop executing mySql

Question

I have a php loop that executes a mySQL query for each cycle of the loop. Right now my loop is hitting a mySql error and stopping. How do I set it up so when it hits a mySql error it just stops what it's doing and moves on to the next loop?

I have added the code below. Please keep in mind I am not trying to solve the SQL error but rather tell the php loop to skip over it.

   foreach ($queryData as $value) { 
       mysql_query(" PREPARE stmt FROM 'INSERT INTO `table_name`( `column_name`) VALUES   ('value'  )'EXECUTE stmt1"
                   )or die("die message");
                                  }

Show us the code that generates the error. Why don't you just fix the error? — Explosion Pills
– Explosion Pills, Commented Apr 25, 2013 at 1:38
You'd get more productive help if you actually shared the code and query in question. — hannebaumsaway
– hannebaumsaway, Commented Apr 25, 2013 at 1:42

sel · Accepted Answer · 2013-04-25 02:03:44Z

1

If you don't want to halt upon execution, just omit the die.

$res = mysql_query($sql);
if ($res) {
 /* do stuff with the query results */
} else {
  /* output an error if desired... or don't */
  echo 'There was a database error: '.mysql_error();
}

answered Apr 25, 2013 at 2:03

sel

4,9421 gold badge18 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error handling in a php loop executing mySql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related