<?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");
Exemplo n.º 2
0
<?php

require_once '../../../codebase/grid_connector.php';
require_once '../../config.php';
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
$grid = new GridConnector($res);
$grid->enable_log("sql.log");
$grid->configure("grid50000", "item_id", "item_nm,item_cd");
$sql = $grid->sql;
echo $id = $grid->insert(array("item_nm" => "1", "item_cd" => Null));
echo "<hr>";
$sql->query("SELECT * FROM grid50000 WHERE item_id=" . $id);
print_r($sql->get_next());
echo "<hr>";
echo $grid->update(array("item_id" => $id, "item_nm" => "2"));
echo "<hr>";
$sql->query("SELECT * FROM grid50000 WHERE item_id=" . $id);
print_r($sql->get_next());
echo "<hr>";
echo $grid->delete($id);
echo "<hr>";
$sql->query("SELECT * FROM grid50000 WHERE item_id=" . $id);
print_r($sql->get_next() == Null);
Exemplo n.º 3
0
<?php

require_once 'config.php';
require_once '../codebase/dhtmlx/grid_connector.php';
$grid = new GridConnector($conn);
$grid->enable_log("log.txt", true);
$grid->render_complex_sql("SELECT `DicomWorklist`.* FROM DicomWorklist INNER JOIN DicomWorklistExclude ON `DicomWorklist`.`RequestedProcedureDescription` = `DicomWorklistExclude`.`RequestedProcedureDescription`", "StudyInstanceUID", "PatientName, PatientID, PatientDOB, PatientSex, RequestedProcedureDescription, CurrentPatientLocation, Modality");
Exemplo n.º 4
0
<?php

require_once 'config.php';
require_once "../codebase/dhtmlx/grid_connector.php";
$conn = new GridConnector($conn);
$conn->enable_log("log.txt", true);
$conn->render_table("Generators", "generator_id", "generator_id,batch_number ,supplier_name ,arrival_date ,arrival_username,decommission_date,decommission_username");
?>

Exemplo n.º 5
0
<?php

require_once "../config.php";
require "../../codebase/db_pdo.php";
$res = new PDO($mysql_server, $mysql_user, $mysql_pass);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res, "PDO");
$grid->enable_log("some.txt", true);
$grid->dynamic_loading(100);
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");