I updated my website scripts to use mysqli prepared statements. They worked well on my localhost but when I uploaded the files to my website, it gave “PHP Fatal error: Call to undefined method mysqli_stmt::get_result()” error. I learned that mysqli prepared statements require mysqli to be enabled as API extension for mysqlnd (not sure if I’m describing it correctly). Checked php_info() and noticed it was not enabled on my hosting server.
I contacted my hosting support to enable it but I wanted to ask here too while waiting in case their reply takes long.
On my server there is a PHP extension settings page as follows:
My guess was to enable nd_mysqli (not sure if it is what I need), but when I checked it and tried to save it gave the error “nd_mysqli skipped as conflicting”.
Do you have any ideas how I can enable mysqli API extension for mysqlnd so that my prepared statements will work?