Hello everybody,
I’m having some issue with my webinterface,
I’m trying to create a dhtmlxgrid in order to load data from an oracle databases, some fields may be modified, but no insert or delete are needed.
I’m using a phpconnector to load the data, and i followed the instruction of the tutorial to implement dataprocessor with phpconnector.
The data are well displayed, but when i try to modify the data, the modification is not done into the database.
here is the code of my html page :
[code]
[/code] and the server side : [code]<?php require_once("codebase/grid_connector.php"); require("codebase/db_oracle.php");$res = oci_connect(xxx, xxx, xxxx);
if (!$res) {
echo "Unable to connect: " . var_dump( oci_error() );
die();
}
$conn = new GridConnector($res,“Oracle”);
$conn->enable_log(“temp.log”);
$conn->dynamic_loading(20);
$conn->render_table(“SEC_ISAE_SERVERS_JUSTIF_2”,“”,“BURESP,SERVER, DOMAIN, ACCOUNT, VALIDITY, TYPE, OWNER, COMMENTS, TSNEEDED, TSCOMMENTS, REVIEWED, REVIEWED_COMMENT”);
?>[/code]
and there is the response received from the server as shown in the dataprocessor debugger:
<?xml version='1.0' encoding='utf-8' ?><rows total_count='17926'><row id='1363339596x0'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW04]]></cell><cell><![CDATA[ESFRPDLPGW04]]></cell><cell><![CDATA[ESFRPDLPGW04\ChangedByCCMS2]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Generic]]></cell><cell><![CDATA[slopez]]></cell><cell><![CDATA[Local Administrator account renamed]]></cell><cell><![CDATA[Yes]]></cell><cell><![CDATA[Only way to connect to servers when AD is down]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x1'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW04]]></cell><cell><![CDATA[INFREHCADPCOM]]></cell><cell><![CDATA[INFREHCADPCOM\Domain Admins]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[System]]></cell><cell><![CDATA[qdqdqd]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x2'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\EHC - CCMS]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[njkndfgaaa]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x3'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\EHC - CCMS SCOM]]></cell><cell><![CDATA[OKp]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[njkndfg]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x4'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\EHC - SC]]></cell><cell><![CDATA[huhOK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[pol]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[ ]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x5'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\EHC - SCBO]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[njkndfg]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x6'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\GSO_TSS_ENG_Admin]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[njkndfgqsxqsx]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[KO]]></cell><cell><![CDATA[Validity is missing]]></cell></row><row id='1363339596x7'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\GSO_TSS_OPS_Admin]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[njkndfg]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[KO]]></cell><cell><![CDATA[Validity is missing]]></cell></row><row id='1363339596x8'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\Metier IPC - Operational Security]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[njkndfg]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x9'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\rsadlpadmin]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[njkndfg]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[KO]]></cell><cell><![CDATA[Validity is missing]]></cell></row><row id='1363339596x10'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[ESFRPDLPGW05\ChangedByCCMS]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[njkndfg]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x11'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[ESFRPDLPGW05\ChangedByCCMS2]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[njkndfg]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x12'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW05]]></cell><cell><![CDATA[NLEHCADPCOM]]></cell><cell><![CDATA[NLEHCADPCOM\Domain Admins]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[njkndfg]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x13'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW06]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\EHC - CCMS]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Members of group IPC CCMS]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x14'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW06]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\EHC - CCMS SCOM]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Group for scom monitoring]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x15'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW06]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\EHC - SC]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Members of group Solution Center]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x16'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW06]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\EHC - SCBO]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Members of group SC Back Office]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row><row id='1363339596x17'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW06]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\GSO_TSS_ENG_Admin]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[KO]]></cell><cell><![CDATA[Validity is missing]]></cell></row><row id='1363339596x18'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW06]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\GSO_TSS_OPS_Admin]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[KO]]></cell><cell><![CDATA[Validity is missing]]></cell></row><row id='1363339596x19'><cell><![CDATA[IPC]]></cell><cell><![CDATA[ESFRPDLPGW06]]></cell><cell><![CDATA[EHCADPCOM]]></cell><cell><![CDATA[EHCADPCOM\Metier IPC - Operational Security]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[Group]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[Members of group IPC Security]]></cell><cell><![CDATA[?]]></cell><cell><![CDATA[]]></cell><cell><![CDATA[OK]]></cell><cell><![CDATA[]]></cell></row></rows>I really apreciate if someone could help me because i’m kinda stuck.
Thx in advance