dhtmlxconnector:db_operations [DHX documentation]

PHP Connector DHTMLX

Elementary DB operations with Connector

dhtmlxConnector allows to execute some actions against DB.

SQL queries

DBWrapper object can be accessed as:


Then, it can be used in queries in the following way:

$connector->sql->query("DELETE FROM some_table WHERE ID=1");
$res = $connector->sql->query("SELECT * FROM some_table WHERE ID=1");
$data =  $connector->sql->get_next($res);
$connector->sql->query("INSERT INTO some_table(type) VALUES('simple')");
$id = $connector->sql->get_new_id();

INSERT query

$id = $connector->insert(array(
		"type" => "simple",


  • hash of values

UPDATE query

		"type_id" => '1'
		"type" => 'simple'


  • hash of values. For successful result it must contain identity field.

DELETE query



  • ID of the record that should be deleted

Creating a new connector

You can create an extra connector object on the fly and use it for DB operations.

$temp = new Connector($db_connection);
	"some1" => "value 1",
	"some2" => "value 2"