Want results page to not show any records when Search submit is pressed
My Code on results page
<?php require_once('Connections/connpco1.php'); ?>
<?php require_once("webassist/database_management/wada_search.php"); ?>
<?php
//WA Database Search (Copyright 2005, WebAssist.com)
//Recordset: WADAplayer_info;
//Searchpage: ;
//Form: ;
$WADbSearch1_DefaultWhere = "0!=0";
if (!session_id()) session_start();
if (isset($_POST["search1"]) || isset($_POST["search1"])) {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//keyword array declarations
//comparison list additions
$WADbSearch1->addComparison("sponsor_DONOR","".((isset($_POST["sponsor1"]))?$_POST["sponsor1"]:"") ."","AND","Includes",0);
$WADbSearch1->addComparison("player_1_name","".((isset($_POST["player1"]))?$_POST["player1"]:"") ."","AND","Includes",0);
$WADbSearch1->addComparison("player_2_name","".((isset($_POST["player2"]))?$_POST["player2"]:"") ."","AND","Includes",0);
$WADbSearch1->addComparison("entrydate","2015/03/01","AND",">=",2);
//save the query in a session variable
if (1 == 1) {
$_SESSION["WADbSearch1_Registered_Players_Information"]=$WADbSearch1->whereClause;
}
}
else {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");
//get the filter definition from a session variable
if (1 == 1) {
if (isset($_SESSION["WADbSearch1_Registered_Players_Information"]) && $_SESSION["WADbSearch1_Registered_Players_Information"] != "") {
$WADbSearch1->whereClause = $_SESSION["WADbSearch1_Registered_Players_Information"];
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
else {
$WADbSearch1->whereClause = $WADbSearch1_DefaultWhere;
}
}
$WADbSearch1->whereClause = str_replace("\\''", "''", $WADbSearch1->whereClause);
$WADbSearch1whereClause = '';
?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
?>
<?php
$currentPage = $_SERVER["PHP_SELF"];
?>
<?php
$maxRows_WADAplayer_info = 10;
$pageNum_WADAplayer_info = 0;
if (isset($_GET['pageNum_WADAplayer_info'])) {
$pageNum_WADAplayer_info = $_GET['pageNum_WADAplayer_info'];
}
$startRow_WADAplayer_info = $pageNum_WADAplayer_info * $maxRows_WADAplayer_info;
mysql_select_db($database_connpco1, $connpco1);
$query_WADAplayer_info = "SELECT ID, sponsor_DONOR, player_1_name, player_2_name, player_1_address, player_2_address, player_1_city, player_2_city, player_1_zip, player_2_zip, player_1_phone, player_2_phone, player_1_email, player_2_email, player_1_hdcp, player_2_hdcp, first_day_am_pm, second_day_am_pm FROM player_info";
setQueryBuilderSource($query_WADAplayer_info,$WADbSearch1,false);
$query_limit_WADAplayer_info = sprintf("%s LIMIT %d, %d", $query_WADAplayer_info, $startRow_WADAplayer_info, $maxRows_WADAplayer_info);
$WADAplayer_info = mysql_query($query_limit_WADAplayer_info, $connpco1) or die(mysql_error());
$row_WADAplayer_info = mysql_fetch_assoc($WADAplayer_info);
if (isset($_GET['totalRows_WADAplayer_info'])) {
$totalRows_WADAplayer_info = $_GET['totalRows_WADAplayer_info'];
} else {
$all_WADAplayer_info = mysql_query($query_WADAplayer_info, $connpco1);
$totalRows_WADAplayer_info = mysql_num_rows($all_WADAplayer_info);
}
$totalPages_WADAplayer_info = ceil($totalRows_WADAplayer_info/$maxRows_WADAplayer_info)-1;
?>
<?php
$queryString_WADAplayer_info = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_WADAplayer_info") == false &&
stristr($param, "totalRows_WADAplayer_info") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_WADAplayer_info = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_WADAplayer_info = sprintf("&totalRows_WADAplayer_info=%d%s", $totalRows_WADAplayer_info, $queryString_WADAplayer_info);
?>
<?php
//WA AltClass Iterator
class WA_AltClassIterator {
var $DisplayIndex;
var $DisplayArray;
function WA_AltClassIterator($theDisplayArray = array(1)) {
$this->ClassCounter = 0;
$this->ClassArray = $theDisplayArray;
}
function getClass($incrementClass) {
if (sizeof($this->ClassArray) == 0) return "";
if ($incrementClass) {
if ($this->ClassCounter >= sizeof($this->ClassArray)) $this->ClassCounter = 0;
$this->ClassCounter++;
}
if ($this->ClassCounter > 0)
return $this->ClassArray[$this->ClassCounter-1];
else
return $this->ClassArray[0];
}
}
?>
<?php
//WA Alternating Class
$WARRT_AltClass1 = new WA_AltClassIterator(explode("|", "|WADAResultsRowDark"));
?>