I am trying to use the grid to access and modify an Oracle database. Following your advice, I was able to retrieve, display and filter data using PDO.
When it comes to updating data though, I can’t get it to work and I can’t find where the problem is - another issue with PDO maybe?
Here’s the script:
**************************************************************************
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
“http://www.w3.org/TR/html4/loose.dtd”>
**************************************************************************
And the php file:
**************************************************************************
<?php
require_once(“dhtmlxConnector_php/codebase/grid_connector.php”);
require_once(“dhtmlxConnector_php/codebase/db_pdo.php”);
try {
$dbh = new PDO(“oci:dbname=//server:port/database”, “user”, “pwd”);
$grid = new GridConnector($dbh, “PDO”);
$grid->enable_log(“temp.log”,true);
$grid->render_table(“MACHINE_RECIPES”, “RECORD_NUMBER”, “RECORD_NUMBER,RECIPE_NOTES”);
} catch (PDOException $e) {
echo "Failed to obtain database handle - error: ". $e->getMessage();
}
?>
**************************************************************************