List of Web3Preneurs ()
Connect
include("admin/classes/initial.php"); include("admin/classes/config.php"); $SearchString = trim($_REQUEST['SearchString']); $CategoryId = trim($_REQUEST['CategoryId']); $Nationality = trim($_REQUEST['Nationality']); $rowperpage = 9; $sql = "select a.* from members a "; if ($SearchString!="") { $sql .= " and (a.FirstName like '".mysqli_real_escape_string($con,$SearchString)."%' or a.LastName like '".mysqli_real_escape_string($con,$SearchString)."%' or a.Designation like '".mysqli_real_escape_string($con,$SearchString)."%' ) "; } if ($CategoryId!="") { $sql .= " and a.CategoryId='".mysqli_real_escape_string($con,$CategoryId)."' "; } if ($Nationality!="") { $sql .= " and a.Nationality='".mysqli_real_escape_string($con,$Nationality)."' "; } $sql .= "order by a.UpdatedOn asc limit 0, $rowperpage "; $rsq = mysqli_query($con,$sql); $allcount_query = "select count(*) as allcount from members a "; if ($SearchString!="") { $allcount_query .= " and (a.FirstName like '".mysqli_real_escape_string($con,$SearchString)."%' or a.LastName like '".mysqli_real_escape_string($con,$SearchString)."%' or a.Designation like '".mysqli_real_escape_string($con,$SearchString)."%' ) "; } if ($CategoryId!="") { $allcount_query .= " and a.CategoryId='".mysqli_real_escape_string($con,$CategoryId)."' "; } if ($Nationality!="") { $allcount_query .= " and a.Nationality='".mysqli_real_escape_string($con,$Nationality)."' "; } $allcount_result = mysqli_query($con,$allcount_query); $allcount_fetch = mysqli_fetch_array($allcount_result); $allcount = $allcount_fetch['allcount']; ?>