see_all_visitors.php

<?php
require_once("init.php");
require_once("config_db.php");
require_once("config.php");
if ($fetch_u['user_status'] != 1) {
    header("Location: login.php");
}
// Config. for pagination //
$page = $_GET['page'];    // get variable for page
$perpage = '15';      // Show per page
$tabl = "users";
$item = 'Visitors';    // table name for query
$namep = "see_all_visitors.php";     // Page name
//Get stcom value
$stcom = stcom($page, $perpage);
$sql_visit = "select * from $tabl where user_status='1' AND status='1' ";

$sql_visit = "select visiter_id, timestamp
from who_visit_myprofile
where user_id='" . $_SESSION['user'] . "' AND visiter_id!='" . $_SESSION['user'] . "' GROUP BY who_visit_myprofile.visiter_id";

$sqlq = $sql_visit;
$sql2 = $sql_visit . " order by timestamp DESC LIMIT $stcom , $perpage"; //echo $sql2;
// pagination file include
include "include/pagination.php";
$exec_visit = mysql_query($sql2);
$num = mysql_num_rows($exec_visit);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE8" >
        </meta>
        <title><?php echo $site_name; ?></title>
        <link href="css/style.css" rel="stylesheet" type="text/css" />
        <style type="text/css">
            .highlightit img {
                filter:progid:DXImageTransform.Microsoft.Alpha(opacity=70);
                -moz-opacity: 0.5;
                opacity: 0.5;
            }
            .highlightit:hover img {
                filter:progid:DXImageTransform.Microsoft.Alpha(opacity=100);
                -moz-opacity: 1;
                opacity: 1;
            }
        </style>
        <style type="text/css">
            div.pagination {
                padding: 3px;
                margin: 3px;
            }
            div.pagination a {
                padding: 2px 5px 2px 5px;
                margin: 2px;
                border: 1px solid #AAAADD;
                text-decoration: none; /* no underline */
                color: #000099;
            }
            div.pagination a:hover, div.pagination a:active {
                border: 1px solid #000099;
                color: #000;
            }
            div.pagination span.current {
                padding: 2px 5px 2px 5px;
                margin: 2px;
                border: 1px solid #000099;
                font-weight: bold;
                background-color: #000099;
                color: #FFF;
            }
            div.pagination span.disabled {
                padding: 2px 5px 2px 5px;
                margin: 2px;
                border: 1px solid #EEE;
                color: #DDD;
            }
        </style>
    </head>

    <body>
        <div id="fb-root"></div>
        <div id="wrapper">
            <?php include "include/header.php"; ?>
            <div class="clear"></div>
            <div class="spaceThirty">&nbsp;</div>
            <div class="clear"></div>
            <div id="content" class="red">
                <?php include "include/home_menu.php"; ?>
                <div class="clear"></div>
                <div id="leftareainner" style="padding-left:30px;">
                    <div id="form_leftArea">
                        <p class="headingRed" style="color:#998; float:left; padding-left:25px;">All Visitors(<?php echo $num; ?>)</p>
                        <div class="form_area">
                            <?php
                            while ($fetch_visit = mysql_fetch_assoc($exec_visit)) { //if($fetch_visit['uniq'] != $user_uniq){
                                $sql = "select * from users where uniq='" . $fetch_visit['visiter_id'] . "' AND status='1'";
                                $exec = mysql_query($sql);
                                $fetch = mysql_fetch_assoc($exec);
                                ?>
                                <div class="detailcatblock">
                                    <div class="likebox">
                                        <div class="likeboxcontent"> <a href="profile_details_log.php?id=<?php echo $fetch['uniq']; ?>"><img src="<?php
                            if ($fetch['thumb'] != '') {
                                echo 'thumb/' . $fetch['thumb'];
                            } else {
                                echo 'images/no_image.jpg';
                            }
                                ?>" height="50" width="60" /></a></div>
                                        <div class="float-left" style="margin-left:20px; width:250px;">
                                            <a href="profile_details_log.php?<?php echo $fetch['uniq']; ?>"><span class="form_heading"> <?php echo $fetch['first_name']; ?></span></a> <br/>
                                            <span class="form_heading">
                                                <?php
                                                //if ($fetch['age'] != '' || $fetch['age'] != 0) {
                                                if (($fetch['birth_month'] != "" && $fetch['birth_month'] != "0" ) && ($fetch['birth_day'] != "" && $fetch['birth_day'] != "0" ) && ($fetch['birth_year'] != '' && $fetch['birth_year'] != "0")) {
                                                    //echo $fetch['age'] . " &nbsp;years old";
                                                    echo age_counter($fetch['birth_month'], $fetch['birth_day'], $fetch['birth_year']) . " &nbsp;years old";
                                                } else {
                                                    echo age_counter($fetch['birth_month'], $fetch['birth_day'], $fetch['birth_year']) . " &nbsp;years old";
                                                }
                                                ?>
                                            </span> <br/>
                                            <span class="form_heading"><?php echo $fetch['city']; ?> </span><br />
                                           <!-- <span class="form_heading" style="font-size:12px"><?php echo date("j M Y, h:i:s A", $fetch_visit['timestamp']); ?></span>-->
                                        </div>
                                    </div>
                                </div>
                                <div class="clear"></div>
                            <?php } //}    ?>
                            <div style="float:left; margin-left:20px;">
                                <?php require("include/pagination_show.php"); ?>
                            </div>
                            <br />
                        </div>
                        <div class="clear"></div>
                        <div class="clear"></div>
                        <div class="float-left" style="width:100%; margin-bottom:20px;"> </div>
                        <div class="clear"></div>
                    </div>
                </div>
            </div>
            <?php include "include/footer.php"; ?>
        </div>
    </body>
</html>