PHP PAGING Beispiele

Beispiel #1

Datei: reply_accept.inc.php Projekt: OkyJ/findmyjodi

	

		

?>

<?php		

		//$select_new_msgs = "select express_interest.*, express_interest.id as exp_int_id from express_interest,members where express_interest.from_mem = '".$_SESSION['logged_user'][0]['member_id']."' AND members.member_id=express_interest.to_mem AND members.is_profile_active='Y' AND express_interest.is_accepted='Y'";

		$select_new_msgs = "select express_interest.*, express_interest.id as exp_int_id from express_interest right join members on express_interest.to_mem=members.member_id where express_interest.from_mem = '".$_SESSION['logged_user'][0]['member_id']."' AND members.is_profile_active='Y' AND express_interest.is_accepted='Y'";

		

		$PAGING=new PAGING($select_new_msgs,10);

		$sql=$PAGING->sql;

		$messages = $obj->select($sql);

		

		//$select_new_msgs = "select *, express_interest.id as exp_int_id from express_interest where to_mem = '".$_SESSION['logged_user'][0]['member_id']."'";								

		//$messages = $obj->select($select_new_msgs);

		if(!empty($messages)) { ?>

Beispiel #2

Datei: need_more_time.inc.php Projekt: OkyJ/findmyjodi

	$logged_in_member=$obj->select($sql_login);

	

		

?>

<?php		

		$select_new_msgs = "select express_interest.*, express_interest.id as exp_int_id from express_interest right join members on express_interest.from_mem=members.member_id where express_interest.to_mem = '".$_SESSION['logged_user'][0]['member_id']."' AND members.is_profile_active='Y' AND express_interest.is_accepted='N' AND is_more_time=1";

		

		$PAGING=new PAGING($select_new_msgs,10);

		$sql=$PAGING->sql;

		$messages = $obj->select($sql);

		

		//$select_new_msgs = "select *, express_interest.id as exp_int_id from express_interest where to_mem = '".$_SESSION['logged_user'][0]['member_id']."'";								

		//$messages = $obj->select($select_new_msgs);

		if(!empty($messages)) { ?>

Beispiel #3

Datei: photo_request_send.inc.php Projekt: OkyJ/findmyjodi

	$logged_in_member=$obj->select($sql_login);

	

		

?>

<?php		

		$select_new_msgs = "select photo_request.*, photo_request.Id as photo_request_id from photo_request right join members on photo_request.To_mem_id=members.id where photo_request.From_mem_id = '".$_SESSION['logged_user'][0]['id']."' AND members.is_profile_active='Y' order by photo_request.Id DESC";

		

		$PAGING=new PAGING($select_new_msgs,10);

		$sql=$PAGING->sql;

		$messages = $obj->select($sql);

		

		//$select_new_msgs = "select *, express_interest.id as exp_int_id from express_interest where to_mem = '".$_SESSION['logged_user'][0]['member_id']."'";								

		//$messages = $obj->select($select_new_msgs);

		if(!empty($messages)) { ?>

Beispiel #4

Datei: search_list.inc.php Projekt: OkyJ/findmyjodi

	}
}

if($_GET['clear']=='all' && !isset($_POST['refine_submit_btn']))
{
	//$_SESSION['SearchCookie'] = $_SESSION['ClearCookie'];
	$select_last = "select * from clear_search where session_id='".session_id()."'";
	$db_select_last = $obj->select($select_last);
	$sql=$db_select_last[0]['search'];
	$PAGING=new PAGING($sql,8);
	$sql=$PAGING->sql;
	$members = $obj->select($sql);
}
elseif(!empty($_POST) || count($search_coockie_data)>0)
{      
$PAGING=new PAGING($sql,8);
$sql=$PAGING->sql;
//echo $sql;
$members = $obj->select($sql);
}
?>
       
<div  class="mid col-md-12 col-sm-12 col-xs-12">
<?php
$select_banner = "select * from advertise where adv_position = 'Search Result Top (954 X 100)' AND status = 'Active'";
$db_banner = $obj->select($select_banner);
if(count($db_banner) > 0) 
{
	if($db_banner[0]['banner_file'] != '') 
	{
		if(file_exists('upload/banners/'.$db_banner[0]['banner_file'])) {

Beispiel #5

Datei: photo_request_received.inc.php Projekt: OkyJ/findmyjodi

	

		

?>

<?php			

		$select_new_msgs = "select photo_request.*, photo_request.Id as photo_request_id from photo_request right join members on photo_request.From_mem_id=members.id where photo_request.To_mem_id = '".$_SESSION['logged_user'][0]['id']."' AND members.is_profile_active='Y' order by photo_request.Id DESC";

		

		//$select_new_msgs = "select *, express_interest.id as exp_int_id from express_interest where to_mem = '".$_SESSION['logged_user'][0]['member_id']."'";								

		$PAGING=new PAGING($select_new_msgs,10);

		$sql=$PAGING->sql;

		$messages = $obj->select($sql);

		

		if(!empty($messages)) { ?>



<div class="content col-md-9 col-sm-12 col-xs-12">

  <?=$PAGING->show_paging("photo_request_received.php");?>

Beispiel #6

Datei: accepted_interest.inc.php Projekt: OkyJ/findmyjodi

	$logged_in_member=$obj->select($sql_login);

	

		

?>

<?php		

		$select_new_msgs = "select express_interest.*, express_interest.id as exp_int_id from express_interest,members where express_interest.to_mem = '".$_SESSION['logged_user'][0]['member_id']."' AND members.member_id=express_interest.to_mem AND members.is_profile_active='Y' AND express_interest.is_accepted='Y'";

		

		$PAGING=new PAGING($select_new_msgs,10);

		$sql=$PAGING->sql;

		$messages = $obj->select($sql);

		

		//$select_new_msgs = "select *, express_interest.id as exp_int_id from express_interest where to_mem = '".$_SESSION['logged_user'][0]['member_id']."'";								

		//$messages = $obj->select($select_new_msgs);

		if(!empty($messages)) { ?>

Beispiel #7

Datei: received_msgs.inc_before message like fb.php Projekt: OkyJ/findmyjodi

//LOGGED-IN USER'S DETAIL //
	$sql_login = "******".$_SESSION['logged_user'][0]['id']."'";	
	$logged_in_member=$obj->select($sql_login);
	
		
?>
<?php		$select_new_msgs = "select * from messages
								where
								to_mem = '".$_SESSION['logged_user'][0]['member_id']."' 
								group by from_mem order by id desc";
		//$messages = $obj->select($select_new_msgs);
		
		$PAGING=new PAGING($select_new_msgs,5);
		$sql=$PAGING->sql;
		$messages = $obj->select($sql);
		if(!empty($messages)) { ?>

<div class="content col-md-9 col-sm-12 col-xs-12">
  <?=$PAGING->show_paging("received_msgs.php")?>
  <!--<div class="title_select_all"></div>-->
    <?php
		 for($i=0;$i<count($messages);$i++)
									  {
										  
										  	$sql2 = "SELECT members.*,members.id as mem_id,member_photos.photo,messages.id as 
													msg_id,messages.* FROM messages,members 
								  					 LEFT JOIN member_photos ON members.id = member_photos.member_id
								                     where

Beispiel #8

Datei: reply_more_time.inc.php Projekt: OkyJ/findmyjodi

	$logged_in_member=$obj->select($sql_login);

	

		

?>

<?php		

		$select_new_msgs = "select express_interest.*, express_interest.id as exp_int_id from express_interest,members where express_interest.from_mem = '".$_SESSION['logged_user'][0]['member_id']."' AND members.member_id=express_interest.to_mem AND members.is_profile_active='Y' AND express_interest.is_accepted='N' AND is_more_time=1";

		

		$PAGING=new PAGING($select_new_msgs,10);

		$sql=$PAGING->sql;

		$messages = $obj->select($sql);

		

		//$select_new_msgs = "select *, express_interest.id as exp_int_id from express_interest where to_mem = '".$_SESSION['logged_user'][0]['member_id']."'";								

		//$messages = $obj->select($select_new_msgs);

		if(!empty($messages)) { ?>

Beispiel #9

Datei: reply_more_info.inc.php Projekt: OkyJ/findmyjodi

	session_destroy();
	echo "<script>window.location='logout.php'</script>";
}
//LOGGED-IN USER'S DETAIL //
	$sql_login = "******".$_SESSION['logged_user'][0]['id']."'";	
	$logged_in_member=$obj->select($sql_login);
	
		
?>
<?php		
		$select_new_msgs = "select express_interest.*, express_interest.id as exp_int_id from express_interest,members where express_interest.from_mem = '".$_SESSION['logged_user'][0]['member_id']."' AND members.member_id=express_interest.to_mem AND members.is_profile_active='Y' AND express_interest.is_accepted='N' AND is_more_info=1";
		
		$PAGING=new PAGING($select_new_msgs,10);
		$sql=$PAGING->sql;
		$messages = $obj->select($sql);
		
		//$select_new_msgs = "select *, express_interest.id as exp_int_id from express_interest where to_mem = '".$_SESSION['logged_user'][0]['member_id']."'";								
		//$messages = $obj->select($select_new_msgs);
		if(!empty($messages)) { ?>
<div class="content col-md-9 col-sm-12 col-xs-12">
  <?=$PAGING->show_paging("reply_more_info.php");?>
  <div class=""> <!-- title_select_all -->
    <div class="floatr">
      <?php
		 for($i=0;$i<count($messages);$i++)
									  {
										  
										  	$sql2 = "SELECT members.*,members.id as mem_id,member_photos.photo,messages.id as 

Beispiel #10

Datei: new_interest.inc.php Projekt: OkyJ/findmyjodi

	

		

?>

<?php		

		$select_new_msgs = "select express_interest.*, express_interest.id as exp_int_id from express_interest right join members on express_interest.from_mem=members.member_id where express_interest.to_mem = '".$_SESSION['logged_user'][0]['member_id']."' AND members.is_profile_active='Y' AND express_interest.is_accepted='N' AND is_more_time=0 AND is_more_info=0";

		//print_r($select_new_msgs);

		//$select_new_msgs = "select *, express_interest.id as exp_int_id from express_interest where to_mem = '".$_SESSION['logged_user'][0]['member_id']."'";								

		$PAGING=new PAGING($select_new_msgs,10);

		$sql=$PAGING->sql;

		$messages = $obj->select($sql);

		//echo $messages[2]['created_date'];



		

		

		if(!empty($messages)) { ?>

Beispiel #11

Datei: sent_reply_panding.inc.php Projekt: OkyJ/findmyjodi

	session_destroy();
	echo "<script>window.location='logout.php'</script>";
}
//LOGGED-IN USER'S DETAIL //
	$sql_login = "******".$_SESSION['logged_user'][0]['id']."'";	
	$logged_in_member=$obj->select($sql_login);
	
		
?>
<?php		
		$select_new_msgs = "select express_interest.*, express_interest.id as exp_int_id from express_interest right join members on express_interest.to_mem=members.member_id where express_interest.from_mem = '".$_SESSION['logged_user'][0]['member_id']."' AND members.is_profile_active='Y' AND express_interest.is_accepted='N' AND is_more_time=0 AND is_more_info=0";
		
		$PAGING=new PAGING($select_new_msgs,10);
		$sql=$PAGING->sql;
		$messages = $obj->select($sql);
		
		//$select_new_msgs = "select *, express_interest.id as exp_int_id from express_interest where to_mem = '".$_SESSION['logged_user'][0]['member_id']."'";								
		//$messages = $obj->select($select_new_msgs);
		if(!empty($messages)) { ?>
<div class="col-md-9 col-sm-12 col-xs-12">
  <?=$PAGING->show_paging("sent_reply_panding.php");?>
  <div class=""> <!-- title_select_all -->
    <div class="floatr">
      <?php
		 for($i=0;$i<count($messages);$i++)
									  {
										  
										  	$sql2 = "SELECT members.*,members.id as mem_id,member_photos.photo,messages.id as 

Beispiel #12

Datei: need_more_info.inc.php Projekt: OkyJ/findmyjodi

	$logged_in_member=$obj->select($sql_login);

	

		

?>

<?php		

		$select_new_msgs = "select express_interest.*, express_interest.id as exp_int_id from express_interest right join members on express_interest.from_mem=members.member_id where express_interest.to_mem = '".$_SESSION['logged_user'][0]['member_id']."' AND members.is_profile_active='Y' AND express_interest.is_accepted='N' AND is_more_info=1";

		

		$PAGING=new PAGING($select_new_msgs,10);

		$sql=$PAGING->sql;

		$messages = $obj->select($sql);

		

		//$select_new_msgs = "select *, express_interest.id as exp_int_id from express_interest where to_mem = '".$_SESSION['logged_user'][0]['member_id']."'";								

		//$messages = $obj->select($select_new_msgs);

		if(!empty($messages)) { ?>