Elementary DB operations with Connector

dhtmlxConnector allows to execute some actions against DB.

DBWrapper object can be accessed as:

$connector->sql

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

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

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

Parameters:

• hash of values

$connector->update(array(
		"type_id" => '1'
		"type" => 'simple'
));

Parameters:

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

$connector->delete($id);

Parameters:

• ID of the record that should be deleted

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

$temp = new Connector($db_connection);
$temp->configure("some_table");
 
$temp->insert(array(
	"some1" => "value 1",
	"some2" => "value 2"
));
$temp->delete("2");