How can I execute multiple procedures continuously?
The quick and dirty answer here would be to do the following


prepare each query once
prepare each query in separate statement handles
call your execute and save result sets in separate arrays


LIke this

$query = "CALL user_top_categories_score(?, 'ALL', 0, 1)";
$topcat_sth = $this-&gt;dbh-&gt;prepare($query);

$query = "CALL user_top_tags_score(?, 'ALL', 0, 3)";
$toptag_sth = $this-&gt;dbh-&gt;prepare($query);

$topcat_sth-&gt;execute([$user_id]);
$topcat_rs = $topcat_sth-&gt;fetchAll(PDO::FETCH_ASSOC);

$toptag_sth-&gt;execute([$user_id]);
$toptag_rs = $toptag_sth-&gt;fetchAll(PDO::FETCH_ASSOC);

...