Web3 Events ()
include("admin/classes/initial.php"); include("admin/classes/config.php"); include("admin/classes/functions.php"); $SearchString = trim($_REQUEST['SearchString']); $EventType = trim($_REQUEST['EventType']); $Country = trim($_REQUEST['Country']); $FromDate = trim($_REQUEST['FromDate']); $ToDate = trim($_REQUEST['ToDate']); $rowperpage = 9; $sql = "select a.*,b.FirstName,b.LastName from events a join members b on a.CreatedBy=b.MemberId where a.IsAapproved=1 "; if ($SearchString!="") { $sql .= " and a.EventTitle like '%".mysqli_real_escape_string($con,$EventTitle)."%' "; } if ($EventType!="") { $sql .= " and a.EventType='".mysqli_real_escape_string($con,$EventType)."' "; } if ($Country!="") { $sql .= " and a.Country='".mysqli_real_escape_string($con,$Country)."' "; } if ($FromDate!="" && $ToDate!="") { $sql .= " and a.StartDate >= '".mysqli_real_escape_string($con,$FromDate)."' and a.EndDate <= '".mysqli_real_escape_string($con,$ToDate)."' "; } $sql .= " order by a.UpdatedOn desc limit 0, $rowperpage "; $rsq = mysqli_query($con,$sql); $allcount_query = "select count(*) as allcount from events a join members b on a.CreatedBy=b.MemberId where a.IsAapproved=1 "; if ($SearchString!="") { $allcount_query .= " and a.EventTitle like '%".mysqli_real_escape_string($con,$EventTitle)."%' "; } if ($EventType!="") { $allcount_query .= " and a.EventType='".mysqli_real_escape_string($con,$EventType)."' "; } if ($Country!="") { $allcount_query .= " and a.Country='".mysqli_real_escape_string($con,$Country)."' "; } if ($FromDate!="" && $ToDate!="") { $sql .= " and a.StartDate >= '".mysqli_real_escape_string($con,$FromDate)."' and a.EndDate <= '".mysqli_real_escape_string($con,$ToDate)."' "; } $allcount_result = mysqli_query($con,$allcount_query); $allcount_fetch = mysqli_fetch_array($allcount_result); $allcount = $allcount_fetch['allcount']; ?>