public static function getInstance() { if (null === self::$instance) { self::$instance = new self(); } return self::$instance; }
private function __construct() { $this->classloader = Classloader::getInstance(); $this->classloader->initLoadLib(); $this->dataConnector = DataConnector::getInstance(); $this->routingEngine = RoutingEngine::getInstance(); $this->templateEngine = TemplateEngine::getInstance(); }
public static function getConnection() { if (self::$connection == null) { $dbConfig = Rays::app()->getDbConfig(); self::$connection = mysql_connect($dbConfig['host'], $dbConfig['user'], $dbConfig['password']) or die(mysql_error()); mysql_select_db($dbConfig['db_name']) or die(mysql_error()); mysql_query("set names " . $dbConfig['charset']) or die(mysql_error()); } return self::$connection; }
public function __construct($res, $type = false, $item_type = false, $data_type = false) { if (!$item_type) { $item_type = "JSONCommonDataItem"; } if (!$data_type) { $data_type = "CommonDataProcessor"; } $this->data_separator = ",\n"; parent::__construct($res, $type, $item_type, $data_type); }
<?php $db = new SQLite3('../../common/testdata.sqlite'); require "../../common/connector/data_connector.php"; require "../../common/connector/db_sqlite3.php"; ConnectorSecurity::$xss = DHX_SECURITY_SAFEHTML; $conn = new DataConnector($db, "SQLite3"); $conn->render_table("films", "id", "title,year,votes,rating,rank");
<?php session_start(); include_once "check.php"; include_once "defines.php"; include_once "ClassLibrary/Text.php"; include_once "ClassLibrary/DataConnector.php"; include_once "DataAccessObjects/ContractDAO.php"; include_once "DataTransferObjects/ContractDTO.php"; include_once "DataAccessObjects/SubContractDAO.php"; include_once "DataTransferObjects/SubContractDTO.php"; include_once "DataAccessObjects/BusinessPartnerDAO.php"; include_once "DataTransferObjects/BusinessPartnerDTO.php"; $slpCode = $_REQUEST["slpCode"]; // Abre a conexao com o banco de dados $dataConnector = new DataConnector('both'); $dataConnector->OpenConnection(); if ($dataConnector->mysqlConnection == null || $dataConnector->sqlserverConnection == null) { echo 'Não foi possível se connectar ao bando de dados!'; exit; } // Cria os objetos de mapeamento objeto-relacional $contractDAO = new ContractDAO($dataConnector->mysqlConnection); $contractDAO->showErrors = 1; $subContractDAO = new SubContractDAO($dataConnector->mysqlConnection); $subContractDAO->showErrors = 1; // Busca os contratos pertencentes ao vendedor $contractArray = $contractDAO->RetrieveRecordArray("vendedor=" . $slpCode . " AND id > 0 ORDER BY convert(numero, signed)"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
// SOFTWARE NAME: Thematic Mapping Engine // SOFTWARE RELEASE: 1.6 // COPYRIGHT NOTICE: Copyright (C) 2008 Bjorn Sandvik, // bjorn@thematicmapping.org // SOFTWARE LICENSE: GNU General Public License version 3 (GPLv3) // NOTICE: > // This program is free software; you can redistribute it and/or // modify it under the terms of version 3 of the GNU General // Public License as published by the Free Software Foundation. // // This program is distributed in the hope that it will be useful, // but WITHOUT ANY WARRANTY; without even the implied warranty of // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // GNU General Public License for more details. // http://www.gnu.org/licenses/ // // // This file shows how maps can be created with the DataConnector // and ThematicMap classes. // Can be changed to another data connector class require_once 'TME_MySQL_DataConnector.php'; // Include engine class require_once 'TME_Engine.php'; $dataConnector = new DataConnector(); $dataStore = $dataConnector->getDataStore(1230, 2005, 0); // indicator / year / region $parameters = array('mapType' => 'prism', 'indicator' => 1230, 'year' => 2005, 'classification' => 'equal'); // Create thematic map object $map = new ThematicMap($dataStore, $parameters); $file = $map->getKML(); echo "<p><a href='{$file}'>{$file}</a>";
<?php require_once "../../../common/config.php"; $data = new DataConnector($conn, $dbtype); $data->add_section("config", ' <columns stack="true"> <column id="package" header="Name" width="200"></column> <column id="section" header="Section" width="120"></column> <column id="size" header="Size" width="80"></column> <column id="architecture" header="PC" width="60"></column> </columns> <height>100</height> <autowidth>true</autowidth> '); $data->render_table("packages_plain", "id", "package, size, architecture, section");
<?php session_start(); require_once "../codebase/connector/scheduler_connector.php"; $res = mysql_connect("localhost", "root", ""); mysql_select_db("calendar"); // $conn = new SchedulerConnector($res); $details = new DataConnector($res); $details->configure("cus", "c_id", "c_id,c_fname"); $conn = new SchedulerConnector($res); $conn->mix("cus", $details, array("c_id" => "c_id")); // function my_update($data){ // $data->add_field("c_id",1); // $data->set_value("c_id","10"); // //will be included in update processing // } // $conn->event->attach("beforeUpdate","my_update"); $conn->enable_log("temp.log"); $c_id = $_SESSION["login"]; $type = $_GET['type']; $eid = $_GET['eid']; // $conn->render_table("bookevent","event_id","start_date,end_date,event_name"); function insert_session($action) { $action->add_field("cid", $_SESSION["login"]); $action->add_field("eid", $_GET["eid"]); } $conn->event->attach("beforeProcessing", "insert_session"); // $conn->event->attach("Select","select * from bookevent where c_id={c_id}"); // $conn->render_table("bookevent","event_id","start_date,end_date,event_name,cid"); // $conn->render_sql("select * from bookevent where c_id = ".$c_id." AND `start_date` >= '2015-07-08 00:00:00' AND `end_date` <= '2015-07-11 00:00:00' ","event_id","start_date,end_date,event_name,rec_type,event_pid,event_length,details,event_location,lat,lng");
/** * Creats table of the model like it is defined. * This is very usefull for the install process in your webapp. */ public function createDatabaseTable() { $notFirst = false; $query = 'CREATE TABLE ' . $this->table . ' ('; foreach ($this->attributes as $attribute) { if ($notFirst) { $query .= ','; } else { $notFirst = true; } $query .= $attribute[0] . ' ' . $attribute[1]; } $query .= ');'; DataConnector::getInstance()->query($query); }
<?php require_once "../../../common/config.php"; $data = new DataConnector($conn, $dbtype); $data->render_table("packages_plain", "id", "package,version,maintainer");
// modify it under the terms of version 3 of the GNU General // Public License as published by the Free Software Foundation. // // This program is distributed in the hope that it will be useful, // but WITHOUT ANY WARRANTY; without even the implied warranty of // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // GNU General Public License for more details. // http://www.gnu.org/licenses/ // // // Can be changed to another data connector class require_once 'TME_MySQL_DataConnector.php'; // Check if a task is specified if (isset($_REQUEST['task'])) { // Make connection object $dataConnector = new DataConnector(); // Check which task switch ($_REQUEST['task']) { // Fetch all statistical indicators in database case 'indicators': // Returns JSON encoded array of indicators echo $dataConnector->getIndicators(); break; // Fetch available years for one indicator // Fetch available years for one indicator case 'indYears': $indicatorID = (int) $_REQUEST['id']; // Avoid exploitation // Returns JSON encoded array of available years for one indicator echo $dataConnector->getIndicatorYears($indicatorID); break;
<?php require_once "../lib/DataConnector.class.php"; $myCon = new DataConnector("192.168.1.10", "8550", "rtls_user", "welcome"); $xmlRequest = new DOMDocument("1.0", "utf-8"); $xmlRequest->formatOutput = true; $request = $xmlRequest->createElement("request"); $request = $xmlRequest->appendChild($request); $params = $xmlRequest->createElement("PARAMS"); $params = $request->appendChild($params); $params->appendChild($xmlRequest->createElement("fields", "all")); try { $xmlResponse = $myCon->request($xmlRequest, "epe/pos/taglist"); echo $xmlResponse->saveXML(); } catch (CannotConnectException $e) { echo $e->getMessage(); }
$ano = $colunas[0]; $tipo = "year"; } if (empty($barSize)) { $barSize = 5000; } if (empty($maxHeight)) { $maxHeight = 2000000; } $parametersTME = array('mapType' => 'bar', 'indicator' => 'valores', 'year' => $ano, 'classification' => 'quantile', 'mapTitle' => $_GET["titulo"], 'timeType' => $tipo, 'dirtmp' => $dir_tmp, 'barSize' => $barSize, 'maxHeight' => $maxHeight, 'outlinecolor' => $_GET["outlinecolor"], 'numvertices' => $_GET["numvertices"], 'symbolType' => 'polygon'); } $nomeTemp = array_merge($_GET, $_POST); $nomeTemp = md5(implode("", $nomeTemp)); $nomeFile = $dir_tmp . "/tme" . $nomeTemp . ".kmz"; //sesion e aberto com isso $dataConnector = new DataConnector($_GET["sid"], $verificaSID); if (!file_exists($nomeFile)) { $dataStore = $dataConnector->getDataStore($_GET["nomelayer"], $colunas, $_GET["colunanomeregiao"], $_GET["titulo"], $_GET["descricao"], "", $parametersTME["mapType"]); } else { $dataStore = ""; } $url = $_SESSION["tmpurl"] . "/tme" . $nomeTemp . ".kmz"; // Create thematic map object $map = new ThematicMap($dataStore, $parametersTME, $nomeTemp); $file = $map->getKML($dataConnector->url, $download, $nomeFile); $nomeArquivo = $map->nomeArquivo; $legenda = str_replace("kmz", "png", basename($nomeArquivo)); $legenda = str_replace("tme", "legend", $legenda); $legenda = str_replace(basename($nomeArquivo), $legenda, $file); if (isset($inclusao) && $inclusao == true) { $download = true;
protected function parse_request() { parent::parse_request(); if (isset($_GET[$this->parent_name])) { $this->request->set_relation($_GET[$this->parent_name]); } else { $this->request->set_relation("0"); } $this->request->set_limit(0, 0); //netralize default reaction on dyn. loading mode }
private function logToDatabase($msg, $type) { DataConnector::getInstance()->query("INSERT INTO log (id,time,type,message,url) VALUES (NULL,NOW(),{$type},{$msg}," . $_SERVER['REQUEST_URI'] . ")"); }
<?php session_start(); include_once "../check.php"; include_once "../defines.php"; include_once "../ClassLibrary/DataConnector.php"; include_once "../DataTransferObjects/ContractBonusDTO.php"; include_once "../DataAccessObjects/ContractBonusDAO.php"; include_once "../DataTransferObjects/CounterDTO.php"; include_once "../DataAccessObjects/CounterDAO.php"; $subContractId = 0; if (isset($_REQUEST["subContractId"]) && $_REQUEST["subContractId"] != 0) { $subContractId = $_REQUEST["subContractId"]; } // Abre a conexao com o banco de dados $dataConnector = new DataConnector('mySql'); $dataConnector->OpenConnection(); if ($dataConnector->mysqlConnection == null) { echo 'Não foi possível se connectar ao bando de dados!'; exit; } $nivelAutorizacao = GetAuthorizationLevel($dataConnector->mysqlConnection, $functionalities["gerenciamentoContratos"]); if ($nivelAutorizacao <= 1) { DisplayNotAuthorizedWarning(); exit; } // Cria os objetos de mapeamento objeto-relacional $contractBonusDAO = new ContractBonusDAO($dataConnector->mysqlConnection); $contractBonusDAO->showErrors = 1; $counterDAO = new CounterDAO($dataConnector->mysqlConnection); $counterDAO->showErrors = 1;
public static function executeSQL($sql) { DataConnector::getConnection(); mysql_query($sql) or die(mysql_error()); }