一次尝试使用更多查询的有效性？

Question

Is valid to use e.g. two query in one try-catch block?

try
{
   $query1 = prepare("SELECT * FROM tbl1...");
   $query2 = prepare("SELECT * FROM tbl2...");
   $query1 = execute();
   $query2 = execute();
}catch (PDOException $e)
{
   print "Error!: " . $e->getMessage();
   return false;
}

OR, it should be:

try
{
   $query1 = prepare("SELECT * FROM tbl1...");
   $query1 = execute();
}catch (PDOException $e)
{
   print "Error!: " . $e->getMessage();
   return false;
}


try
{
   $query2 = prepare("SELECT * FROM tbl2...");
   $query2 = execute();
}catch (PDOException $e)
{
   print "Error!: " . $e->getMessage();
   return false;
}

If both method are accepted and in use are there any differenc between them? (Speed?) Because I have to do more query in the index but I dont want to separet all

Answer 1

Both method are accepted but the first one is more readable. One try catch for the same group of functions is enough.

If one of your calls fails it will stop the bloc execution and go directly to the catch, so putting all in the same try works.

I suspect that in the second way, the compiler might recognize the code in the two catchs as being identical and optimize it as the first one but this should be tried out.