Problems with dxhtml connector

Suite and Optimus Suite 5
#1

require_once(“/codebase/data_connector.php”);
require_once(“/codebase/db_mysqli.php”);

$conn = mysqli_connect(“localhost”, “root”, “”, “randl”);
$dbtype = “MySQL”;
$data = new JSONDataConnector($conn, $dbtype);

$data->render_sql(“SELECT * FROM table”,“id”, “project, item, detailer”); //or $render_table(“table”, “id”, “project, item, detailer”)

retrieves only this:
{ “data”:[ ] }

$result = mysqli_query($conn, “SELECT * FROM table”);
$row = mysqli_fetch_all($result);
var_dump($data); // retrieves normal array of data
use latest version of dhtml connector

in logs next errors:

Log started, 10/07/2014 12:07:30

SELECT id,project,item,detailer FROM table

mysql_query() expects parameter 2 to be resource, object given at C:\OpenServer\OpenServer\domains\job2.local\tables\codebase\db_common.php line 964

mysql_fetch_assoc() expects parameter 1 to be resource, null given at C:\OpenServer\OpenServer\domains\job2.local\tables\codebase\db_common.php line 974

Done in 0.00500011444092s

#2

Change dbtype to

$dbtype = “MySQLi”;

docs.dhtmlx.com/connector__php__ … ample.html

#3

thanks, Stanislav

and connect must be as this:
$conn = new mysqli(“localhost”, “root”, “”, “randl”);
not:
$conn = mysqli_connect(“localhost”, “root”, “”, “randl”);