<?php $_REQUEST['schema'] = "svendborg"; $_REQUEST['formid'] = "115770004835770"; $table = new table("{$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join"); $table->execQuery("set client_encoding='UFT8'", "PDO"); $query = "SELECT {$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join.*,public.save_check.ok FROM {$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join LEFT JOIN public.save_check ON public.save_check.irowid={$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join.irowid ORDER by public.save_check.irowid, {$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join.adresse LIMIT 100000000"; $result = $table->execQuery($query); $rows = $table->fetchAll($result, "assoc"); //print_r($rows);
<?php $table = new table("{$_REQUEST['schema']}.tforms{$_REQUEST['formid']}_join"); $table->execQuery("set client_encoding='UTF8'", "PDO"); $response = $table->getRecords(NULL, "*", "irowid='{$_REQUEST['id']}'"); $row = $response['data'][0]; if (empty($row)) { die("empty"); } //print_r($row); $checkTable = new table("public.save_check"); $checkTable->execQuery("set client_encoding='UTF8'", "PDO"); $checkResponse = $checkTable->getRecords(NULL, "*", "irowid={$_REQUEST['id']}"); $checkRow = $checkResponse['data'][0]; //print_r($checkRow);
include 'libs/FirePHPCore/fb.php'; include 'model/tables.php'; $postgisdb = $parts[3]; $table = new table("vandforsyningsplan.anlaeg_join"); $table->execQuery("set client_encoding='LATIN1'", "PDO"); $response = $table->getRecords(NULL, "*", "id='{$_REQUEST['id']}'"); $row = $response['data'][0]; $response = $table->getRecords(NULL, "id,navn_paa_vandvaerk,html", "overordnet_id='{$row['overordnet_id']}'"); $rowOverordnet = $response['data']; //print_r($rowOverordnet); $table = new table("vandforsyningsplan.boringer"); $table->execQuery("set client_encoding='LATIN1'", "PDO"); $response = $table->getRecords(NULL, "*", "plant_id='{$_REQUEST['id']}'"); $rowBoringer = $response['data']; //print_r($rowBoringer); $table = new table("vandforsyningsplan.maengde"); $table->execQuery("set client_encoding='LATIN1'", "PDO"); $table->execQuery("set datestyle TO SQL,DMY", "PDO"); //$response = $table->getRecords(NULL,"*","plantid='{$_REQUEST['id']}' AND startdate::date>='01/01/2010'"); $response = $table->getRecords(NULL, "*", "plantid='{$row['overordnet_id']}'"); $rowMaengde = $response['data']; $i = 0; foreach ($rowMaengde as $value) { if (is_int($i / 2)) { $year[] = $value['time']; } else { $year[] = ""; } $amount[] = $value['amount']; $i++; }
<?php include "inc/lp_fields.php"; include "inc/lp_ref.php"; $table = new table("lokalplaner.lpplandk2_join"); $table->execQuery("set client_encoding='LATIN1'", "PDO"); $response = $table->getRecords(NULL, "*", "planid='{$_REQUEST['planid']}'"); $row = $response['data'][0]; $table = new table("lokalplaner.lpdelplandk2_join"); $table->execQuery("set client_encoding='LATIN1'", "PDO"); $response = $table->getRecords(NULL, "*", "lokplan_id='{$_REQUEST['planid']}'"); $rowsLpDel = $response['data']; if (!is_array($rowsLpDel)) { $rowsLpDel = array(); } //print_r($rowsLpDel);
<?php include "html_header.php"; include "inc/lp_fields.php"; include "inc/lp_ref.php"; $table = new table("lokalplaner.lpplandk2_join"); $table->execQuery("set client_encoding='latin1'", "PDO"); $response = $table->getRecords(null, "*", "plannr='{$_REQUEST['plannr']}'"); //print_r($response['data'][0]); $row = $response['data'][0]; if (empty($row)) { die; } /* $table = new table("public.lpdelplandk2_join"); $response = $table->getRecords("lokplan_id='{$_REQUEST['planid']}'"); print_r($response['data']); $rowsLpDel = $response['data']; */ $postgisObject = new postgis(); //$postgisObject->execQuery("set client_encoding='latin1'","PG"); $query = "SELECT * FROM lokalplaner.lpdelplandk2_join where lokplan_id='" . $row["planid"] . "' order by delnr"; //echo $query; $result = $postgisObject->execQuery($query, "PG"); $rowsLpDel = pg_fetch_all($result); if (!is_array($rowsLpDel)) { $rowsLpDel = array(); } $i = 1; ?> <!DOCTYPE html>