PHP 8.2 - Handling MySQLi Prepared Statements with Multiple Result Sets
I'm optimizing some code but I'm testing a new approach and I've been struggling with this for a few days now and could really use some help..... I'm working with an scenario when trying to handle multiple result sets from a MySQLi prepared statement in PHP 8.2. I've been using prepared statements to securely execute my queries, but I recently had a requirement to fetch data from multiple related queries in one go. Here's the code I'm using: ```php $mysqli = new mysqli('localhost', 'user', 'password', 'database'); if ($mysqli->connect_error) { die('Connect behavior (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error); } $stmt = $mysqli->prepare('SELECT * FROM first_table; SELECT * FROM second_table;'); $stmt->execute(); $stmt->store_result(); do { $result = $stmt->get_result(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { print_r($row); } } } while ($stmt->more_results() && $stmt->next_result()); $stmt->close(); $mysqli->close(); ``` While this seems straightforward, I am getting the following behavior: `Call to a member function get_result() on bool` on the first call to `$stmt->get_result()`. I suspect the scenario arises because `$stmt->execute()` seems to be returning false due to the way I'm structuring the SQL query. I've tried breaking it down into separate queries, which works fine, but I really want to avoid multiple round-trips to the database for performance reasons. I've also checked that MySQL's multi-query support is enabled, as I can see it working in other contexts. Additionally, I tried to use `mysqli_multi_query()` instead, but it doesn't play nicely with prepared statements in my case since I need to bind parameters. Is there a correct way to handle multiple result sets with prepared statements in MySQLi in PHP? Any insights or corrections to my approach would be greatly appreciated. For context: I'm using Php on macOS. Thanks in advance! Has anyone dealt with something similar? I'd really appreciate any guidance on this. I recently upgraded to Php LTS. Cheers for any assistance!