本文整理汇总了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;示例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];示例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 */