PDO: Using the same statement in different fetches

Question

which one of the following is the proper way to perform multiple queries? These queries are on the same table (but they need to be different because of SUM function on different conditions)

$var1=($db->query($query1))->fetch(); $var2=($db->query($query2))->fetch(); $var3=($db->query($query3))->fetch(); $temp=$db->query($query1); $var1 =$temp->fetch(); $temp=$db->query($query2); $var2 =$temp->fetch(); $temp=$db->query($query3); $var3 =$temp->fetch(); $vars1=$db->query($query1); $var1 =$vars1->fetch(); $vars2=$db->query($query2); $var2 =$vars2->fetch(); $vars3=$db->query($query3); $var3 =$vars3->fetch();

If they are the same, as I suppose, can it happen that only the third works with some specific PHP configuration?

Thank you in advance

Davide

the ones that work are proper, the ones that dont work are not — user557846
– user557846, Commented Mar 3, 2016 at 0:04
Aren't the second and third one the same? You are just using a differently-named variable for the pdo statement object. — Cave Johnson
– Cave Johnson, Commented Mar 3, 2016 at 0:27

Your Common Sense · Accepted Answer · 2016-03-03 03:28:35Z

which one of the following is the proper way to perform multiple queries?

In theory they range from best to worst in terms of memory consumption, but for your particular query returning just one number, it's practically all the same.

it happen that only the third works with some specific PHP configuration?

No.

Collectives™ on Stack Overflow

PDO: Using the same statement in different fetches

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related