Uncaught Error: Call to undefined method mysqli_stmt::get_result() in mamp

Question

I am running MAMP on windows. php_mysqli.dll is enabled in the php.ini file.

Along with that, in php info it says the mysqlnd is enabled:

Here is what my php looks like:

$connection = connect();
if($stmt = $connection->prepare("SELECT * FROM `users` WHERE `email` = '?'")){
    $stmt->bind_param("s", $email);
    $stmt->execute();
    $result = $stmt->get_result();
}

The line $result = $stmt->get_result() throws the error

PHP Fatal error: Uncaught Error: Call to undefined method mysqli_stmt::get_result()

Any guesses why get_result() is not working?

This is different than the questions already asked because all of the solutions refer to mysqlind not being enabled although, in my case it is.

**My solution:** Stop using MAMP. – Tsangares Jul 28 '16 at 23:50 — Tsangares, Jul 28 '16 at 23:50

score 3 · Accepted Answer · answered Jul 31 '16 at 02:31

3

If you switch to PDO you can use fetchAll instead. PDO is better than mysqli for several reasons, one including the ability to pass in arrays as parameters before execution.

answered Jul 31 '16 at 02:31

HeavyHeavyMind

46
2

score 2 · Answer 2 · answered Jul 31 '16 at 00:35

2

You can probably do something like download the php install from here: and use the MAMP php directory as the install location.

answered Jul 31 '16 at 00:35

SocraticMoney

21
4

Welcome to Stack Overflow! Whilst this may theoretically answer the question, [it would be preferable](//meta.stackoverflow.com/q/8259) to include the essential parts of the answer here, and provide the link for reference. – Enamul Hassan Jul 31 '16 at 00:42
Thank you, I will take that into account for further activities – SocraticMoney Jul 31 '16 at 00:48

Uncaught Error: Call to undefined method mysqli_stmt::get_result() in mamp

2 Answers2