PHP gSQLWhere函数代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中gSQLWhere函数的典型用法代码示例。如果您正苦于以下问题：PHP gSQLWhere函数的具体用法？PHP gSQLWhere怎么用？PHP gSQLWhere使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了gSQLWhere函数的7个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: array

<?php

$strTableName = "dbo.Anomalies";
$_SESSION["OwnerID"] = $_SESSION["_" . $strTableName . "_OwnerID"];
$strOriginalTableName = "dbo.Anomalies";
$gstrOrderBy = "";
if (strlen($gstrOrderBy) && strtolower(substr($gstrOrderBy, 0, 8)) != "order by") {
    $gstrOrderBy = "order by " . $gstrOrderBy;
}
$g_orderindexes = array();
$gsqlHead = "SELECT ID,   [Module ID],   [Anomaly Description],   [Anomaly Type],   [Date Time],   [Action Taken]";
$gsqlFrom = "FROM dbo.Anomalies";
$gsqlWhereExpr = "";
$gsqlTail = "";
include_once getabspath("include/Anomalies_settings.php");
// alias for 'SQLQuery' object
$gQuery =& $queryData_Anomalies;
$eventObj =& $tableEvents["dbo.Anomalies"];
$reportCaseSensitiveGroupFields = false;
$gstrSQL = gSQLWhere("");

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:20，代码来源:Anomalies_variables.php

示例2: trim

 //	order by
 $strOrderBy = $_SESSION[$strTableName . "_order"];
 if (!$strOrderBy) {
     $strOrderBy = $gstrOrderBy;
 }
 $strSQL .= " " . trim($strOrderBy);
 $strSQLbak = $strSQL;
 if ($eventObj->exists("BeforeQueryExport")) {
     $eventObj->BeforeQueryExport($strSQL, $strWhereClause, $strOrderBy);
 }
 //	Rebuild SQL if needed
 if ($strSQL != $strSQLbak) {
     //	changed $strSQL - old style
     $numrows = GetRowCount($strSQL);
 } else {
     $strSQL = gSQLWhere($strWhereClause, $strHavingClause);
     $strSQL .= " " . trim($strOrderBy);
     $rowcount = false;
     if ($eventObj->exists("ListGetRowCount")) {
         $masterKeysReq = array();
         for ($i = 0; $i < count($pageObject->detailKeysByM); $i++) {
             $masterKeysReq[] = $_SESSION[$strTableName . "_masterkey" . ($i + 1)];
         }
         $rowcount = $eventObj->ListGetRowCount($pageObject->searchClauseObj, $_SESSION[$strTableName . "_mastertable"], $masterKeysReq, $selected_recs);
     }
     if ($rowcount !== false) {
         $numrows = $rowcount;
     } else {
         $numrows = gSQLRowCount($strWhereClause, $strHavingClause);
     }
 }

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:31，代码来源:Anomalies_export.php

示例3: unset

    $message = $_SESSION["message_edit"];
    unset($_SESSION["message_edit"]);
}
/////////////////////////////////////////////////////////////
//	read current values from the database
/////////////////////////////////////////////////////////////
$query = $queryData_Customers->Copy();
$strWhereClause = KeyWhere($keys);
$strSQL = gSQLWhere($strWhereClause);
$strSQLbak = $strSQL;
//	Before Query event
if ($eventObj->exists("BeforeQueryEdit")) {
    $eventObj->BeforeQueryEdit($strSQL, $strWhereClause);
}
if ($strSQLbak == $strSQL) {
    $strSQL = gSQLWhere($strWhereClause);
}
LogInfo($strSQL);
$rs = db_query($strSQL, $conn);
$data = db_fetch_array($rs);
if (!$data) {
    if ($inlineedit == EDIT_SIMPLE) {
        header("Location: Customers_list.php?a=return");
        exit;
    } else {
        $data = array();
    }
}
$readonlyfields = array();
if ($readevalues) {
    $data["Name"] = $evalues["Name"];

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:31，代码来源:Customers_edit.php

示例4: array

     if ($HaveData) {
         $returnJSON['noKeys'] = false;
     } else {
         $returnJSON['noKeys'] = true;
     }
     $respJSON['keys'] = $keys;
     $respJSON['rawVals'] = $showRawValues;
     $respJSON['detKeys'] = $showDetailKeys;
     $respJSON['userMess'] = $usermessage;
 }
 $respJSON['mKeys'] = array();
 for ($i = 0; $i < count($dpParams['ids']); $i++) {
     $data = 0;
     if (count($keys)) {
         $where = KeyWhere($keys);
         $strSQL = gSQLWhere($where);
         LogInfo($strSQL);
         $rs = db_query($strSQL, $conn);
         $data = db_fetch_array($rs);
     }
     if (!$data) {
         $data = $avalues;
     }
     $mKeyId = 1;
     foreach ($mKeys[$dpParams['strTableNames'][$i]] as $mk) {
         if ($data[$mk]) {
             $respJSON['mKeys'][$dpParams['strTableNames'][$i]]['masterkey' . $mKeyId++] = $data[$mk];
         } else {
             $respJSON['mKeys'][$dpParams['strTableNames'][$i]]['masterkey' . $mKeyId++] = '';
         }
     }

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:31，代码来源:Month_Billings_add.php

示例5: DeleteUploadedFiles

function DeleteUploadedFiles($where, $table = "")
{
    global $conn, $gstrSQL;
    $sql = gSQLWhere($where);
    $rs = db_query($sql, $conn);
    if (!($data = db_fetch_array($rs))) {
        return;
    }
    foreach ($data as $field => $value) {
        if (strlen($value) && GetEditFormat($field) == EDIT_FORMAT_FILE) {
            $isAbs = GetFieldData($table, $field, "Absolute", false);
            $filename = GetUploadFolder($field) . $value;
            if (!$isAbs) {
                $filename = getabspath($filename);
            }
            runner_delete_file($filename);
            if (GetCreateThumbnail($field)) {
                $filename = GetUploadFolder($field) . GetThumbnailPrefix($field) . $value;
                if (!$isAbs) {
                    $filename = getabspath($filename);
                }
                runner_delete_file($filename);
            }
        }
    }
}

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:26，代码来源:commonfunctions.php

示例6: array

    $returnJSON = array("success" => false, "error" => 'Error: You have not permission for read this text');
    echo my_json_encode($returnJSON);
    return;
}
if (!$gQuery->HasGroupBy()) {
    // Do not select any fields except current (full text) field.
    // If query has 'group by' clause then other fields are used in it and we may not simply cut 'em off.
    // Just don't do anything in that case.
    $gQuery->RemoveAllFieldsExcept(GetFieldIndex($field));
}
$keysArr = GetTableData($strTableName, '.Keys', array());
$keys = array();
foreach ($keysArr as $ind => $k) {
    $keys[$k] = postvalue("key" . ($ind + 1));
}
$where = KeyWhere($keys);
$secOpt = GetTableData($strTableName, '.nSecOptions', array());
if ($secOpt == ADVSECURITY_VIEW_OWN) {
    $where = whereAdd($where, SecuritySQL("Search"));
}
$sql = gSQLWhere($where);
$rs = db_query($sql, $conn);
if (!$rs || !($data = db_fetch_array($rs))) {
    $returnJSON = array("success" => false, "error" => 'Error: Wrong SQL query');
    echo my_json_encode($returnJSON);
    return;
}
$value = nl2br(htmlspecialchars($data[$field]));
$returnJSON = array("success" => true, "textCont" => $value);
echo my_json_encode($returnJSON);
return;

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:31，代码来源:fulltext.php

示例7: Chart


//.........这里部分代码省略.........
         }
     }
     if ($this->chrt_array["chart_type"]["type"] != "gauge") {
         $this->strLabel = $this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['name'];
         for ($j = 0; $j < count($this->chrt_array['fields']); $j++) {
             if ($this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['name'] == $this->chrt_array['fields'][$j]['name']) {
                 if ($this->table_type == "project") {
                     $this->label2 = $this->chart_xmlencode(GetFieldLabel($TableName, GoodFieldName($this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['name'])));
                 } else {
                     $this->label2 = $this->chart_xmlencode($this->chrt_array['parameters'][count($this->chrt_array['parameters']) - 1]['name']);
                 }
             }
         }
     }
     if ($this->chrt_array["chart_type"]["type"] != "ohlc" && $this->chrt_array["chart_type"]["type"] != "candlestick") {
         foreach ($this->arrDataColor as $ind => $val) {
             if ($ind == 0) {
                 $this->arrAxesColor = "#000000";
             } else {
                 $this->arrAxesColor = "#" . $this->arrDataColor[$ind];
             }
         }
     } else {
         foreach ($this->arrOHLC_color as $ind => $val) {
             if ($ind == 0) {
                 $this->arrAxesColor = "#000000";
             } else {
                 $this->arrAxesColor = "#" . $this->arrOHLC_color[$ind];
             }
         }
     }
     // prepare search params
     global $gsqlFrom, $gsqlWhereExpr;
     $gQuery = GetTableData($this->sessionPrefix, ".sqlquery", null);
     $strWhereClause = "";
     $searchHavingClause = "";
     // search where for basic charts
     if (!$this->webchart) {
         global $strTableName;
         if (isset($_SESSION[$this->sessionPrefix . '_advsearch'])) {
             $searchClauseObj = unserialize($_SESSION[$this->sessionPrefix . '_advsearch']);
             $strWhereClause = $searchClauseObj->getWhere(GetListOfFieldsByExprType(false));
             $searchHavingClause = $searchClauseObj->getWhere(GetListOfFieldsByExprType(true));
         }
     } else {
         if ($this->table_type != "project") {
             $strTableName = "webchart" . $this->cname;
         } else {
             $strTableName = $TableName;
         }
         $strWhereClause = CalcSearchParam($this->table_type != "project");
     }
     if ($strWhereClause) {
         $this->chrt_array['where'] .= $this->chrt_array['where'] ? " AND (" . $strWhereClause . ")" : " WHERE (" . $strWhereClause . ")";
     }
     if ($this->table_type == "project") {
         if (SecuritySQL("Search")) {
             $strWhereClause = whereAdd($strWhereClause, SecuritySQL("Search"));
         }
         $this->strSQL = gSQLWhere($strWhereClause, $searchHavingClause);
         $strOrderBy = $this->gstrOrderBy;
         $this->strSQL .= " " . $strOrderBy;
         $strSQLbak = $this->strSQL;
         if (tableEventExists("BeforeQueryChart", $strTableName)) {
             $tstrSQL = $this->strSQL;
             $eventObj = getEventObject($strTableName);
             $eventObj->BeforeQueryChart($tstrSQL, $strWhereClause, $strOrderBy);
             $this->strSQL = $tstrSQL;
         }
         if ($strSQLbak == $this->strSQL) {
             $this->strSQL = gSQLWhere($strWhereClause, $searchHavingClause);
             $this->strSQL .= " " . $strOrderBy;
         }
     }
     if ($this->cname && $this->table_type == "db") {
         $this->strSQL = $this->chrt_array['sql'] . $this->chrt_array['where'] . $this->chrt_array['group_by'] . $this->chrt_array['order_by'];
     } elseif ($this->cname && $this->table_type == "custom") {
         if (!IsStoredProcedure($this->chrt_array['sql'])) {
             $sql_query = $this->chrt_array['sql'];
             if (GetDatabaseType() == 2) {
                 $pos = strrpos(strtoupper($sql_query), "ORDER BY");
                 if ($pos) {
                     $sql_query = substr($sql_query, 0, $pos);
                 }
             }
             if (GetDatabaseType() != 1) {
                 //Oracle
                 $this->strSQL = "select * from (" . $sql_query . ") as custom_query" . $this->chrt_array['where'];
             } else {
                 $this->strSQL = "select * from (" . $sql_query . ")" . $this->chrt_array['where'];
             }
         } else {
             $this->strSQL = $this->chrt_array['sql'];
         }
     }
     if (tableEventExists("UpdateChartSettings", $strTableName)) {
         $eventObj = getEventObject($strTableName);
         $eventObj->UpdateChartSettings($this);
     }
 }

开发者ID:samsulpendis，项目名称:Instant_Appointment，代码行数:101，代码来源:charts.php

注：本文中的gSQLWhere函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP gT函数代码示例发布时间：2022-05-15

PHP gSQLRowCount函数代码示例发布时间：2022-05-15

bradtraversy/iweather: Ionic 3 mobile we

1 CVE-2022-30203

Windows Boot Manager Security Feature Bypass Vulnerability.

阅读：888|2022-07-29

2 PacktPublishing/Python-Machine-Learning-

PacktPublishing/Python-Machine-Learning-Second-Edition: Python Machine Learning

阅读：971|2022-08-18

3 altair-viz/altair: Declarative statistic

altair-viz/altair: Declarative statistical visualization library for Python

阅读：1105|2022-08-15

4 sussillo/hfopt-matlab: A parallel, cpu-b

sussillo/hfopt-matlab: A parallel, cpu-based matlab implemention of the Hessian

阅读：995|2022-08-17

5 鲁东大学一米网:Win7系统USB驱动器RAM的操

win7系统电脑使用过程中有不少朋友表示遇到过win7系统USB驱动器RAM的状况，当出现win7

阅读：887|2022-11-06

6 emersion/go-ostatus: An OStatus library

emersion/go-ostatus: An OStatus library written in Go

阅读：751|2022-08-17

7 小程序云开发获取不到openid

这篇文章讲的很好但是那位老哥你唯一没有说的就是最后结局方法里面的 env:“jnfrie

阅读：573|2022-07-18

8 elipapa/markdown-cv: a simple template t

elipapa/markdown-cv: a simple template to write your CV in a readable markdown f

阅读：509|2022-08-17

9 zju-sclab/NDT-library: These is ndt libr

zju-sclab/NDT-library: These is ndt library for ndt_mapping and ndt_localization

阅读：732|2022-08-16

10 卡莉·蕾·吉普森是谁?不雅录像是怎么回事?

Call Me Maybe 中英字幕对于加拿大歌手卡莉·蕾·吉普森很多人有些陌生，她隶属于贾

阅读：629|2022-11-06

客服电话

电子邮件

PHP gSQLWhere函数代码示例

示例1: array

示例2: trim

示例3: unset

示例4: array

示例5: DeleteUploadedFiles

示例6: array

示例7: Chart

请发表评论

全部评论

上一篇：

下一篇：

dphi-official/Machine_Learning_Bootcamp

juven/maven-bash-completion: Maven Bash

win7系统注册表编辑器打开的操作方法

route101/mastoinker: Quick image view as

openshift/library-go: Helpers for going

bradtraversy/iweather: Ionic 3 mobile we

Matlab：二维图（一）

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

rugk/mastodon-simplified-federation: Sim

CVE-2022-33678

关于我们

产品与服务

解决方案

139-2527-9053