<?php
require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res);
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
$grid->render_sql("SELECT grid50000.item_id as ID , grid50000.item_nm FROM grid50000", "item_id(ID)", "grid50000.item_id(ID),item_nm");
<?php
require_once "../config.php";
$res = oci_connect($oci_dbuser, $oci_dbpass, $oci_dbname);
require "../../codebase/grid_connector.php";
require "../../codebase/db_oracle.php";
$grid = new GridConnector($res, "Oracle");
$grid->dynamic_loading(50);
$grid->sql->sequence("EMPLOYEES_INC.nextVal");
$grid->render_table("EMPLOYEES", "EMPLOYEE_ID", "FIRST_NAME,LAST_NAME");
<?php
require_once "../dhtmlx/connector_codebase/grid_connector.php";
$res3 = mysql_connect("localhost", "root", "");
mysql_select_db("company");
session_start();
$CR_Code = strip_tags($_SESSION['PCR_Code']);
$conn3 = new GridConnector($res3, "MySQL");
$conn3->dynamic_loading(30);
// limited the loading data details
if ($CR_Code != null) {
$conn3->render_sql("Select * from `paydetailtable` where `CRCode`='{$CR_Code}'", "id", "CRCode,No,date,period,invoice_no,po_number,invoice_amount,paid_period,payment_amount,remark");
} else {
$conn3->render_sql("Select * from `paydetailtable` where `CRCode`='0'", "id", "CRCode,No,date,period,invoice_no,po_number,invoice_amount,paid_period,payment_amount,remark");
//$conn2->render_table("ivdetailtable","id","InvNumber,itemid,Description,UOM,Quantity,UnitPrice,ItemPrice"); //"table ","id" for table,"data column" for table
}
?>
<?php
require_once "../dhtmlx/connector_codebase/grid_connector.php";
$res2 = mysql_connect("localhost", "root", "");
mysql_select_db("company");
session_start();
$invno = strip_tags($_SESSION['invnumber']);
$conn2 = new GridConnector($res2, "MySQL");
$conn2->dynamic_loading(30);
// limited the loading data details
if ($invno != null) {
$conn2->render_sql("Select * from `ivdetailtable` where `InvNumber`='{$invno}'", "id", "InvNumber,itemid,Description,UOM,Quantity,UnitPrice,ItemPrice");
} else {
$conn2->render_sql("Select * from `ivdetailtable` where `InvNumber`='0'", "id", "InvNumber,itemid,Description,UOM,Quantity,UnitPrice,ItemPrice");
//$conn2->render_table("ivdetailtable","id","InvNumber,itemid,Description,UOM,Quantity,UnitPrice,ItemPrice"); //"table ","id" for table,"data column" for table
$conn->sql->attach("DELETE", "DELETE * FROM `ivdetailtable` WHERE `itemid` = 0");
}
<?php
require_once "../dhtmlx/connector_codebase/grid_connector.php";
$res1 = mysql_connect("localhost", "root", "");
mysql_select_db("company");
session_start();
$crno = strip_tags($_SESSION['CRNoteNo']);
$conn1 = new GridConnector($res1, "MySQL");
$conn1->dynamic_loading(30);
// limited the loading data details
if ($crno != null) {
$conn1->render_sql("Select * from `cndetailtable` where `CNnumber`={$crno}", "id", "CNnumber,itemid,ReferenceNumber,Narrative,Amount");
} else {
$conn1->render_sql("Select * from `cndetailtable` where `CNnumber`='0'", "id", "CNnumber,itemid,ReferenceNumber,Narrative,Amount");
$conn->sql->attach("DELETE", "DELETE * FROM `cndetailtable` WHERE `itemid` = 0");
}
