PHPRunner 6.0 manual - Make search button return data only when search value was entered

To make search button return data only when search value was entered use the following code in the List page: Before process event.

global $strTableName;

if (isset($_SESSION[$strTableName.'_advsearch'])){

include_once("classes/searchclause.php");

$searchClauseObj = unserialize($_SESSION[$strTableName.'_advsearch']);

if ($searchClauseObj->isUsedSrch()){

if ($searchClauseObj->_where[$strTableName."_simpleSrch"] == ''){

foreach($searchClauseObj->_where[$strTableName."_srchFields"]

as $srchField)

if($srchField['value1'] != ''){

return;

}

$_SESSION[$strTableName.'strWhereClause'] = " 1=0";

}

};

and use this code in the List page: Before SQL query event:

global $strTableName;

if (isset($_SESSION[$strTableName.'strWhereClause'])){

$strWhereClause = $_SESSION['strWhereClause'];

unset($_SESSION['strWhereClause']);

}