Why Does My PHP MySQLi Code Throw a 'Call to undefined method mysqli_stmt::get_result()' Error?

MySQLi: Resolving "Call to undefined method mysqli_stmt::get_result() Error

In PHP, when executing a MySQL query with MySQLi, the error "Call to undefined method mysqli_stmt::get_result()" may arise. This issue typically occurs when the MySQL native driver (mysqlnd) is not installed.

Consider the following code snippet:

$stmt = $conn->mysqli->prepare($query);
$stmt->bind_param('sss', $_POST['EmailID'], $_POST['SLA'], $_POST['Password']);
$stmt->execute();
$result = $stmt->get_result();

In this example, the $result = $stmt->get_result(); line throws the "Call to undefined method mysqli_stmt::get_result()" error. This is because the get_result() method requires the mysqlnd driver, which is not always installed on the web hosting environment.

To rectify this issue, ensure that the mysqlnd driver is enabled. You can verify its installation by checking the phpinfo() output or using a command like:

php -i | grep mysqlnd

If the mysqlnd driver is not installed, follow these steps:

For Debian-based systems:

sudo apt-get install php-mysqlnd

For Red Hat-based systems:

sudo yum install php-mysqlnd

For Mac OS X using Homebrew:

brew install php-mysqlnd

For Windows systems:

Install the latest version of PHP with the mysqlnd driver enabled.

After installing the mysqlnd driver, it is necessary to restart the web server to load the changes. Once the driver is installed and activated, the get_result() method will work properly.

Alternatively, if mysqlnd cannot be installed, you can use the bind_result() and fetch() methods to retrieve the results of the query. These methods are less efficient than get_result() but do not require the mysqlnd driver.

The above is the detailed content of Why Does My PHP MySQLi Code Throw a 'Call to undefined method mysqli_stmt::get_result()' Error?. For more information, please follow other related articles on the PHP Chinese website!