当前位置: 首页>>代码示例>>PHP>>正文


PHP fnSearchCondition函数代码示例

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


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

示例1: UPPER

 					$sql.=" JOIN ".$crudTableJoin2." ".$crudTableJoin2." ON ".$crudTableJoin1.".".$crudIdJoin2. "=" .$crudTableJoin2.".".$crudIdJoin2;
 	
 			}
 			if(!empty($crudTableJoin1) && !empty($crudTableJoin2) && !empty($crudTableJoin3)){
 	
 				   $sql.=" JOIN ".$crudTableJoin3." ".$crudTableJoin3." ON ".$crudTableName.".".$crudIdJoin3. "=" .$crudTableJoin3.".".$crudIdJoin3;
 	
 			}*/
 if (!empty($Filter) && $postConfig['search'] == 'false') {
     $sql .= " WHERE  " . $Filter . " = '" . $NilaiFilter . "' ";
 }
 if (!empty($Filter) && $postConfig['search'] == 'true') {
     $sql .= " WHERE " . $Filter . " = '" . $NilaiFilter . "' AND UPPER(" . $postConfig['searchField'] . ") " . fnSearchCondition($_POST['searchOper'], $postConfig['searchStr']);
 }
 if (empty($Filter) && $postConfig['search'] == 'true') {
     $sql .= " WHERE UPPER(" . $postConfig['searchField'] . ") " . fnSearchCondition($_POST['searchOper'], $postConfig['searchStr']);
 }
 //if(!empty($crudTableJoin1)){
 $sql .= ' ORDER BY ' . $crudTableName . '.' . $postConfig['id'] . ' ' . $postConfig['sortOrder'];
 //}else{
 //	$sql .= ' ORDER BY '.$postConfig['id'].' ' . $postConfig['sortOrder'];
 //}
 //echo $sql;
 //if($postConfig['search'] == true){ $sql .= ' where '.$searchCondition; }
 if ($DEBUGMODE == 1) {
     $firephp->info($sql, 'query');
 }
 $result = gcms_query($sql) or die($firephp->error('Couldn t execute query.' . mysql_error()));
 /*Create the output object*/
 $o->page = $intPage;
 $o->total = $total_pages;
开发者ID:ibnoe,项目名称:simpatda-thinkfrogs,代码行数:31,代码来源:jqGridCrudPendataanRetribusi.php

示例2: ON

            //$sql = 'select FIRST '.$intLimit.' SKIP '.$intStart.' '.implode(',',$crudColumns).' from '.$crudTableName;
            $sql = 'SELECT 
				  PENDAFTARAN.PENDAFTARAN_ID as id,
				  PENDAFTARAN.NO_PENDAFTARAN,
				  PENDAFTARAN.TANGGAL_KARTU,
				  BADAN_USAHA.NAMA,
				  PENDAFTARAN.JENIS_PENDAFTARAN,
				  PENDAFTARAN.NPWP
				FROM
				  PENDAFTARAN
				  INNER JOIN BADAN_USAHA ON (BADAN_USAHA.ID = PENDAFTARAN.ID_PEMOHON)
				WHERE PENDAFTARAN.OBJEK_PDRD=\'BU\'		
				';
        }
        if ($postConfig['search'] == 'true') {
            $sql .= ' and UPPER(' . $postConfig['searchField'] . ') ' . fnSearchCondition($_POST['searchOper'], $postConfig['searchStr']);
        }
        $sql .= ' ORDER BY ' . $postConfig['sortColumn'] . ' ' . $postConfig['sortOrder'];
        //if($postConfig['search'] == true){ $sql .= ' where '.$searchCondition; }
        if ($DEBUGMODE == 1) {
            $firephp->info($sql, 'query');
        }
        $result = gcms_query($sql) or die($firephp->error('Couldn t execute query.' . mysql_error()));
        /*Create the output object*/
        $o->page = $intPage;
        $o->total = $total_pages;
        $o->records = $count;
        $i = 0;
        while ($row = gcms_fetch_row($result)) {
            /* 1st column needs to be the id, even if it's not named ID */
            $o->rows[$i]['id'] = $row[0];
开发者ID:ibnoe,项目名称:simpatda-thinkfrogs,代码行数:31,代码来源:handler_pendaftaran_bu.php

示例3: ceil

     $total_pages = ceil($count / $intLimit);
 } else {
     $total_pages = 1;
 }
 if ($DEBUGMODE == 1) {
     $firephp->info($total_pages, 'total_pages');
 }
 $intPage = $postConfig['page'];
 if ($intPage > $total_pages) {
     $intPage = $total_pages;
 }
 $intStart = ($intPage - 1) * $intLimit;
 /*Run the data query*/
 $sql = 'select ' . implode(',', $crudColumns) . ' from ' . $crudTableName;
 if ($postConfig['search'] == 'true') {
     $sql .= ' WHERE ' . $postConfig['searchField'] . ' ' . fnSearchCondition($_POST['searchOper'], $postConfig['searchStr']);
 }
 $sql .= ' ORDER BY ' . $postConfig['sortColumn'] . ' ' . $postConfig['sortOrder'];
 $sql .= ' LIMIT ' . $intStart . ',' . $intLimit;
 //if($postConfig['search'] == true){ $sql .= ' where '.$searchCondition; }
 if ($DEBUGMODE == 1) {
     $firephp->info($sql, 'query');
 }
 $result = mysql_query($sql) or die($firephp->error('Couldn t execute query.' . mysql_error()));
 /*Create the output object*/
 $o->page = $intPage;
 $o->total = $total_pages;
 $o->records = $count;
 $i = 0;
 while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
     /* 1st column needs to be the id, even if it's not named ID */
开发者ID:jimmyc815,项目名称:algo,代码行数:31,代码来源:jqGridCrud.php


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