PHP BasicSearchWhere Examples

Example #1

File: archiveslist.php Project: BGCX261/zhss-svn-to-git

$sSrchBasic = "";
// Basic search filter
$sSrchWhere = "";
// Search where clause
$sFilter = "";
// Master/Detail
$sDbMasterFilter = "";
// Master filter
$sDbDetailFilter = "";
// Detail filter
$sSqlMaster = "";
// Sql for master record
// Handle reset command
ResetCmd();
// Get basic search criteria
$sSrchBasic = BasicSearchWhere();
// Build search criteria
if ($sSrchAdvanced != "") {
    if ($sSrchWhere != "") {
        $sSrchWhere .= " AND ";
    }
    $sSrchWhere .= "(" . $sSrchAdvanced . ")";
}
if ($sSrchBasic != "") {
    if ($sSrchWhere != "") {
        $sSrchWhere .= " AND ";
    }
    $sSrchWhere .= "(" . $sSrchBasic . ")";
}
// Save search criteria
if ($sSrchWhere != "") {

Example #2

File: 复件 postslist.php Project: BGCX261/zhss-svn-to-git

	$posts->setSearchWhere($sSrchWhere); // Save to Session
	$nStartRec = 1; // Reset start record counter
	$posts->setStartRecordNumber($nStartRec);
} else {
	RestoreSearchParms();
}

// Build filter
$sFilter = "";
if ($sDbDetailFilter <> "") {
	if ($sFilter <> "") $sFilter .= " AND ";
	$sFilter .= "(" . $sDbDetailFilter . ")";
}
if ($sSrchWhere <> "") {
	if ($sFilter <> "") $sFilter .= " AND ";
	$sFilter .= "(" . BasicSearchWhere() . ")";
}

// Set up filter in Session
$posts->setSessionWhere($sSrchWhere);
$posts->CurrentFilter = "";

// Set Up Sorting Order
SetUpSortOrder();

// Set Return Url
$posts->setReturnUrl("postslist.php");

?>
<?php include "header.php" ?>
<table width="100%" height="100%" border="0" cellspacing="0" cellpadding="0">