本文整理汇总了PHP中table::getRecords方法的典型用法代码示例。如果您正苦于以下问题:PHP table::getRecords方法的具体用法?PHP table::getRecords怎么用?PHP table::getRecords使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类table
的用法示例。
在下文中一共展示了table::getRecords方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: table
function __construct()
{
parent::__construct();
$geometryColumnsObj = new table("settings.geometry_columns_view");
$this->rows = $geometryColumnsObj->getRecords();
$this->rows = $this->rows['data'];
}
示例2: table
<?php
$table = new table("settings.geometry_columns_view");
$responseWmsLayers = $table->getRecords(NULL, "*", "1=1 ORDER BY sort_id,f_table_title,f_table_name");
示例3: table
<?php
$plannr = $_GET['plannr'];
$table = new table("lokalplaner.lpplandk2_join");
$table->execQuery("set client_encoding='LATIN1'", "PDO");
$response = $table->getRecords(NULL, "*", "plannr='{$plannr}'");
$row = $response['data'][0];
示例4: table
<?php
session_start();
ini_set("display_errors", "On");
error_reporting(3);
include '../../../conf/main.php';
include 'libs/functions.php';
include 'inc/user_name_from_uri.php';
include 'libs/FirePHPCore/FirePHP.class.php';
include 'libs/FirePHPCore/fb.php';
include 'model/tables.php';
$postgisdb = $parts[3];
include "inc/lp_fields.php";
include "inc/lp_ref.php";
preg_match('/[0-9]+/', $_REQUEST['plannr'], $matches);
$_REQUEST['plannr'] = $matches[0];
//$_REQUEST['plannr'] = "5033";
$table = new table("lokalplaner.lpplandk2_join");
$table->execQuery("set client_encoding='LATIN1'", "PDO");
$response = $table->getRecords(NULL, "*", "plannr='{$_REQUEST['plannr']}'");
$row = $response['data'][0];
$table = new table("lokalplaner.lpdelplandk2_join");
$table->execQuery("set client_encoding='LATIN1'", "PDO");
$response = $table->getRecords(NULL, "*", "lokplan_id='{$row['planid']}' ORDER by delnr");
$rowsLpDel = $response['data'];
if (!is_array($rowsLpDel)) {
$rowsLpDel = array();
}
//print_r($rowsLpDel);
示例5: table
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++;
}
示例6: table
<?php
include '../../conf/main.php';
include '../../libs/functions.php';
include '../../model/tables.php';
include '../../inc/user_name_from_uri.php';
//print_r($parts);
$postgisdb = $parts[3];
$postgisschema = $parts[4];
$table = new table($parts[4] . "." . $parts[5]);
$response = $table->getRecords(NULL, $parts[6], "gid={$parts[7]}");
$data = base64_decode($response['data'][0][$parts[6]]);
示例7: table
<?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>
示例8: table
<?php
$table = new table("public.ways");
//$table->execQuery("set client_encoding='latin1'","PDO");
$response = $table->getRecords(NULL, "*", "id={$parts['2']}");
//print_r($response['data'][0]);
$row = $response['data'][0];
示例9: table
<?php
//preg_match('/(?<=\s)[0-9|\.]+/',$_GET['plannr'],$matches);
//$plannr = $matches[0];
$table = new table("lokalplaner.lpplandk2_join");
$table->execQuery("set client_encoding='LATIN1'", "PDO");
$response = $table->getRecords(NULL, "*", "planid='{$_GET['planid']}'");
$row = $response['data'][0];
$time = time();
示例10: table
<?php
$table = new table("lokalplaner.lpplandk2_join");
$table->execQuery("set client_encoding='LATIN1'", "PDO");
$response = $table->getRecords(NULL, "forsidebillede,plannr,plannavn,forsidetekst", "forsidebillede<>'' order by planid");
$row = $response['data'];
示例11: table
<?php
include "../server_header.inc";
//include("../../inc/oauthcheck.php");
$table = new table($parts[5]);
if ($HTTP_RAW_POST_DATA) {
$obj = json_decode($HTTP_RAW_POST_DATA);
}
//print_r($obj);
switch ($parts[4]) {
case "getrecords":
// only geometrycolumns table
$response = $table->getRecords(true, "*", $whereClause = "f_table_schema='{$postgisschema}'");
break;
case "getgeojson":
// only geometrycolumns table
$response = $table->getGeoJson();
break;
case "getallrecords":
// All tables
$response = $table->getRecords(false, "gid,plannr,plannavn,distrikt,anvendelsegenerel,zonestatus,doklink", null);
break;
case "getgroupby":
// All tables
$response = $table->getGroupBy($parts[6]);
break;
case "updaterecord":
// All tables
$response = $table->updateRecord($obj->data, $parts[6]);
makeMapFile($_SESSION['screen_name']);
break;
示例12: table
MapappWin = window.open(strURL, strWinName, strParameters);
MapappWin.focus();
} else {
if (!MapappWin.closed) {
MapappWin.focus();
}
}
}
</script>
<div id="map-win"></div>
<?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("planid='{$_REQUEST['planid']}'");
//print_r($response['data'][0]);
$row = $response['data'][0];
/*
$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='" . $_REQUEST["planid"] . "' order by delnr";
//echo $query;
$result = $postgisObject->execQuery($query, "PG");
$rowsLpDel = pg_fetch_all($result);
if (!is_array($rowsLpDel)) {
示例13: table
<?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);
示例14: table
<?php
$table = new table("tforms_115770000000094_join");
$response = $table->getRecords("f_table_schema='{$postgisschema}'", true);
示例15: table
<?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);