-
Profile Found
$totalart
-
";
$perpg = '10';
$page = 1;
if(isset($_GET['page'])) {
$page = $_GET['page'];
if($page < 1) $page = 1;
}
//////echo "$totalart Rows\n";
$limitT = (($page * $perpg) - $perpg);
$pagination = $perpg;
$target = $totalart;
$items_per_page= $pagination;
$num_pages = ceil($target/$items_per_page);
if(($page>$num_pages)&&$page!=1)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
if($type=='grooms')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `gender` = 'm' AND `married` ='u' AND `status` = '1' AND `veri_fy` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}else if($type=='brides')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `gender` = 'f' AND `married` ='u' AND `status` = '1' AND `veri_fy` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}else if($type=='divorcee-grooms')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `gender` = 'm' AND `married` ='d' AND `status` = '1' AND `veri_fy` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}else if($type=='divorcee-brides')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `gender` = 'f' AND `married` ='d' AND `status` = '1' AND `veri_fy` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}else if($type=='widower-grooms')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `gender` = 'm' AND `married` ='w' AND `status` = '1' AND `veri_fy` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}else if($type=='widow-brides')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `gender` = 'f' AND `married` ='w' AND `status` = '1' AND `veri_fy` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}else if($type=='mangalik-grooms')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `gender` = 'm' AND `status` = '1' AND `veri_fy` = '1' AND `mangalik` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}else if($type=='mangalik-brides')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `gender` = 'f' AND `status` = '1' AND `veri_fy` = '1' AND `mangalik` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}else if($type=='handicapped-grooms')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `gender` = 'm' AND `phstatus` = '1' AND `status` = '1' AND `veri_fy` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}else if($type=='handicapped-brides')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `gender` = 'f' AND `phstatus` = '1' AND `status` = '1' AND `veri_fy` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}else if($type=='all')
{
$sql = "SELECT * FROM kk_usersinfo WHERE `status` = '1' AND `veri_fy` = '1' ORDER BY id DESC LIMIT $limitT, $pagination";
}
$result = mysqli_query($db, $sql);
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
$aid = $row["id"];
$mid = $row["mem_id"];
$lname = $row["lname"];
$gender = $row["gender"];
$myage = $row["myage"];
$myrel = $row["religion"];
$mycaste = $row["caste"];
$height = $row["height"];
$unchi = getMeasurements("$height");
$mystate = $row["my_state"];
$mydiv = $row["my_div"];
$mytaluka = $row["my_taluka"];
$mycity = $row["my_city"];
$mylang = $row["my_lang"];
$myedu = $row["education"];
$myoccu = $row["occupation"];
$myincome = $row["monthlyincome"];
echo "
![\"member-img\"](\"/images/$gender.png\")
";
}
} else {
echo "No results Found";
}
echo "
#$mid
$myrel - $mycaste
$myage Years | $unchi
$myedu [ $myoccu, $myincome/Monthly ]
$mycity ($mydiv, MH)
- ";
echo pagination($items_per_page,$page,'/' .$type. '-profiles/page/',$totalart);
echo "