Demi Report from MySql Table

Hi forum

I just tested Sales By Customer Report Demo from Orders.csv demo file and everything was Ok

Then I migrated Orders.csv data to a MySql table and change php code to "SalesByCustomer_mysql.php" and then got the following php error message

Fatal error: Uncaught Error: Call to undefined method mysqli_stmt::get_result() in in /srv/.../koolreport/core/src/datasources/MySQLDataSource.php on line 395

Some internet search suggests the php server doesn´t have mysqlnd activated

I asked info() to server and it said:

MySQL is not installed
MySQLi is installed
libmysqlclient driver is being used

Using this code:

echo "<p>";
if (function_exists('mysql_connect')) {
    echo "- MySQL is installed";
} else  {
    echo "- MySQL is not installed";
}

echo "<p>";
if (function_exists('mysqli_connect')) {
    echo "- MySQLi is installed";
} else {
    echo "- MySQLi is not installed";
}

echo "<p>";
if (function_exists('mysqli_get_client_stats')) {
    echo "- MySQLnd driver is being used";
} else {
    echo "- libmysqlclient driver is being used";
}

echo "<p>";
// $salesByCustomer = new SalesByCustomer_mysql;

My question is: Is there any alternative to read MySql table data with this php configuration

Thank you in advance AR

function settings() { return array( "dataSources"=>array( "sakila_rental"=>array( "connectionString"=>"mysql:host=localhost;dbname=sakila", "username"=>"root", "password"=>"", "charset"=>"utf8" ), ) ); }

KoolReport's Forum

Demi Report from MySql Table #2502

Build Your Excellent Data Report