โค๊ดแบ่งหน้า PHP+MySQL แก้ไขดัดแปลงและทดลองใช้งานโดย PlaKriM

<?php
$page = (isset($_GET['page']))? intval($_GET['page']) : 1;
$limit_end = 1;
$limit_start = ($page-1)*$limit_end;

$sql = "SELECT * FROM tb_user";
$query_id = mysql_query($sql . " LIMIT " . $limit_start. "," . $limit_end, $conn);
$count = mysql_num_rows($query_id);
$total = mysql_num_rows(mysql_query($sql, $conn));
if($total > 0){
while($rows = mysql_fetch_assoc($query_id)){
echo $rows['username']."<br>";
}
echo "\n<div style=\"float:left;\">Page : " . page_navi($page, $limit_end, 0, $total) . " </div><div style=\"float:right;\">[" . ($limit_start+1) . "-" . ($limit_start+$count) . "] of <strong>" . $total . "</strong></div>";
}
?>

<?php
if(isset($_GET["textSearch"]) and $_GET["textSearch"] != ""){
$send = "textSearch=" . $_GET["textSearch"];
$condition= " WHERE username LIKE '%" . $_GET["textSearch"] . "%'";
}
?>

<?php
echo "\n<div style=\"float:left;\">total : " . $total ." record | " . $page ."/" . $total ." " . page_navi($page, $limit_end, 0, $total, $send) . "</div>";
?>

<?php
function page_navi($page, $limit, $range, $count){
    $output = "";
    $total = ceil($count/$limit);
    $navi_start = $page-$range;
    $navi_end = $page+$range;
    
    if($navi_start <= 0) $navi_start = 1;
    if($navi_end >= $total) $navi_end = $total;
    
    if($page>1){
        $navi_back = $page-1;
        if($page > 2)
        $output .= "<a href=\"JavaScript:doCallAjax(document.getElementById('txtSearch').value,'" . $page . "');\" ><strong>&laquo;</strong></a> ";
        $output .= "<a href=\"JavaScript:doCallAjax(document.getElementById('txtSearch').value,'" . $navi_back . "');\" ><strong>&#8249;</strong></a> ";
    }
    for($i = $navi_start; $i <= $navi_end; $i++){
        if($i == $page)
        $output .= "<a href=\"JavaScript:doCallAjax(document.getElementById('txtSearch').value,'" . $i . "');\" ><strong><font color=\"" . $other_style . "\">$i</font></strong></a> ";
        else
        $output .= "<a href=\"JavaScript:doCallAjax(document.getElementById('txtSearch').value,'" . $i . "');\" >$i</a> ";
    }
    if($page < $total){
        $navi_next = $page+1;
        $output .= "<a href=\"JavaScript:doCallAjax(document.getElementById('txtSearch').value,'" . $navi_next . "');\" ><strong>&#8250;</strong></a> ";
        if(($page+1) < $total)
        $output .= "<a href=\"JavaScript:doCallAjax(document.getElementById('txtSearch').value,'" . $total . "');\" ><strong>&raquo;</strong></a>";
    }
    if($navi_start>$navi_end) 
        $output .= "<a href=\"JavaScript:doCallAjax(document.getElementById('txtSearch').value,'" . $page . "');\" ><strong>$page</strong></a> ";
    return $output;
}

/*** By Weerachai Nukitram ***/
/*** http://www.ThaiCreate.Com ***/
$objConnect = mysql_connect("localhost:3308","root","root") or die("Error Connect to Database");
$objDB = mysql_select_db("test");

$page = (isset($_POST['page']))? intval($_POST['page']) : 1;
$limit_end = 2;
$limit_start = ($page-1)*$limit_end;

if(isset($_POST["mySearch"]) and $_POST["mySearch"] != ""){
    $condition= " Name LIKE '%" . $_POST["mySearch"] ."%'";
} 

$sql = "SELECT * FROM customer " . $condition;
echo $sql . " LIMIT " . $limit_start. "," . $limit_end;
$query_id = mysql_query($sql . " LIMIT " . $limit_start. "," . $limit_end);
$count = mysql_num_rows($query_id);
$total = mysql_num_rows(mysql_query($sql)); 

?>
<table width="600" border="1">
<tr>
<th width="91"> <div align="center">CustomerID</div></th>
<th width="98"> <div align="center">Name</div></th>
<th width="198"> <div align="center">Email</div></th>
<th width="97"> <div align="center">CountryCode</div></th>
<th width="59"> <div align="center">Budget</div></th>
<th width="71"> <div align="center">Used</div></th>
</tr>
<?
while($objResult = mysql_fetch_array($query_id))
{
?>
<tr>
<td><div align="center"><?=$objResult["CustomerID"];?></div></td>
<td><?=$objResult["Name"];?></td>
<td><?=$objResult["Email"];?></td>
<td><div align="center"><?=$objResult["CountryCode"];?></div></td>
<td align="right"><?=$objResult["Budget"];?></td>
<td align="right"><?=$objResult["Used"];?></td>
</tr>
<?
}
?>
</table>
<br>
<?
echo page_navi($page, $limit_end, 4, $total);
mysql_close($objConnect);
?>

<?php


$sta=$_POST["sta"];
$detail=$_POST["detail"];

	
	  include 'connect.php';
      mysql_query('SET NAMES UTF8');
	
	 $sql="SELECT *FROM `ads` WHERE $sta LIKE '%$detail%'";
	
		$res=mysql_db_query($dbname,$sql);
		  $check=mysql_num_rows($res);
		
	if($check==0)
		{
		    echo "<font class=\"menulink\"><center>ไม่พบข้อมูล</center>";
   	   }
	  else
	  {
  
/*###################################################################################*/

function page_navi($page, $limit, $range, $count, $target="_self", $current_style="", $other_style="", $quetystring=""){ 
    $total = ceil($count/$limit); 
    $navi_start = $page-$range; 
    $navi_end = $page+$range; 
     
    $send = !empty($querystring)? "&". $querystring : ""; 
     
    if($navi_start <= 0) $navi_start = 1; 
    if($navi_end >= $total) $navi_end = $total; 
    if($page>1){ 
        $navi_back = $page-1; 
        if($page > 2) 
        echo "<a href=\"?page=1" . $send . "\" target=\"" . $target . "\">&laquo;</a> "; 
        echo "<a href=\"?page=$navi_back&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">&#8249;</a> "; 
    } 
    for($i = $navi_start; $i <= $navi_end; $i++){ 
        if($i == $page) 
        echo "<a href=\"?page=$i&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\"><strong>$i</strong></a> "; 
        else 
        echo "<a href=\"?page=$i&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">$i</a> "; 
    } 
    if($page < $total){ 
        $navi_next = $page+1; 
        echo "<a href=\"?page=$navi_next&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">&#8250;</a> "; 
        if(($page+1) < $total) 
        echo "<a href=\"?page=$total&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">&raquo;</a>"; 
    } 
} 
	$page = (isset($_GET['page']))? intval($_GET['page']) : 1; 
$limit_end = 1; 
$limit_start = ($page-1)*$limit_end; 

$send = ""; 
if(isset($_GET["detail"]) and $_GET["detail"] != ""){ 
    $send = "detail=" . $_GET["detail"]; 
    $condition= " WHERE $sta LIKE '%" . $_GET["detail"] . "%'"; 
} 

$sql1 = "SELECT * FROM ads". $condition; 
$query_id = mysql_query($sql1 . " LIMIT " . $limit_start. "," . $limit_end ); 
$count = mysql_num_rows($query_id); 
$total = mysql_num_rows(mysql_query($sql1)); 
if($total > 0){

/*##################################################################################*/
		  


  while($result=mysql_fetch_array($query_id))
{
$id=$result[id_ads];
$own_name=$result[own_name];
$own_tel=$result[own_tel];
$own_email=$result[own_email];
$min_price=$result[min_price];
$max_price=$result[max_price];
$horpak_name=$result[horpak_name];
$horpak_road=$result[horpak_road];
$horpak_tumboon=$result[horpak_tumboon];
$horpak_maung=$result[horpak_maung];
$horpak_zone=$result[horpak_zone];
$horpak_one=$result[horpak_one];
$province=$result[proviunce];
$univesity=$result[univesity];
$horpak_no=$reult[hopak_no];
$room_type=$result[room_type];
$horpak_type=$result[horpak_type];
$zip=$result[zip];
$air=$result[air];
$furniture=$result[furniture];
$horpak_website=$result[horpak_website];
$h_prakan=$result[h_prakan];
$h_klang=$result[h_klang];	
$pic1=$result[pic1];
$internet=$result[internet];
$air=$result[air];
$furniture=$result[furniture];
$horpak_website=$result[horpak_website];
$h_prakan=$result[h_prakan];
$h_klang=$result[h_klang];	
$pic1=$result[pic1];
 $ubc=$result[ubc];
$tel=$result[tel];
$bath=$result[bath];
$internet=$result[internet];
$sak_pa=$result[sakpa];
$bts=$result[bts];
$mrt=$result[mrt];
$internet=$result[internet];
$status=$result[status];
	if($status==1)
	{
	$status="1";
	$status="ไม่ว่าง";
	}
	else
	{
	$status="0";
	$status="<font class=menulink>ว่าง</font>";
	}

  ?>


<br />
		  
<table width="95%"  border="0" align="center" cellpadding="5" cellspacing="2">
 <tr valign="top">

 ชื่อหอพัก :&nbsp;&nbsp;<font class="menumanage"> <a href="show_detail_all.php?id=<?=$result[id_ads]?>"><?=$result[horpak_name]?></a> &nbsp;<img src="pic/new_05.gif" border="0"> &nbsp;<?=$status?></font><br>
ราคา:&nbsp;&nbsp; <font class="menulink"><?=$result[min_price]?>-<?=$result[max_price]?> </font><br>
 ประเภท:&nbsp;&nbsp;<font class="menudelete"><?=$result[horpak_type]?></font><br>
 
ที่อยู่:&nbsp;&nbsp; <font class="menumanage"> &nbsp;เลขที่<?=$result[horpak_no]?>ถนน.<?=$result[horpak_road]?>&nbsp;เขต.<?=$horpak_zone?>&nbsp;ต.<?=$result[horpak_tumboon]?> &nbsp;อ.<?=$result[horpak_maung]?>&nbsp;จ.<?=$result[province]?>&nbsp; <?=$result[zip]?></font><br><br>
 <?
 $atec="pic/air".$air.".gif";
 $fur="pic/furniture".$furniture.".gif";
 $ubc="pic/ubc".$ubc.".gif";
 $tel="pic/tel".$tel.".gif";
 $bath="pic/bath".$bath.".gif";
 $internet="pic/internet".$internet.".gif";
 $bts="pic/bts".$bts.".gif";
 $mrt="pic/mrt".$mrt.".gif";
 ?>
<img src="<?=$atec?>">&nbsp;<img src="<?=$fur?>">&nbsp;<img src="<?=$ubc?>"> &nbsp;<img src="<?=$tel?>">&nbsp;<img src="<?=$bath?>">&nbsp; <img src="<?=$internet?>">&nbsp;<img src="<?=$bts?>">&nbsp;<img src="<?=$mrt?>"> <br>
<hr>
<td width="75%" >
	  
</td>
</tr>
</table> 
<?

} }
echo "\n<div style=\"float:left;\">Page : " . page_navi($page, $limit_end, 4, $total, "current_page","other_page",$send) . " </div><div style=\"float:right;\">[" . ($limit_start+1) . "-" . ($limit_start+$count) . "] of <strong>" . $total . "</strong></div>"; 
}
?>

<?

	mysql_close();	
?>

<?php
<?php


$sta=$_REQUEST["sta"];
$detail=$_REQUEST["detail"];

    
      include 'connect.php';
      mysql_query('SET NAMES UTF8');
    
     $sql="SELECT *FROM `ads` WHERE $sta LIKE '%$detail%'";
    
        $res=mysql_db_query($dbname,$sql);
          $check=mysql_num_rows($res);
        
    if($check==0)
        {
            echo "<font class=\"menulink\"><center>ไม่พบข้อมูล</center>";
          }
      else
      {
  
/*###################################################################################*/

function page_navi($page, $limit, $range, $count, $target="_self", $current_style="", $other_style="", $quetystring=""){ 
    $total = ceil($count/$limit); 
    $navi_start = $page-$range; 
    $navi_end = $page+$range; 
     
    $send = !empty($querystring)? "&". $querystring : ""; 
     
    if($navi_start <= 0) $navi_start = 1; 
    if($navi_end >= $total) $navi_end = $total; 
    if($page>1){ 
        $navi_back = $page-1; 
        if($page > 2) 
        echo "<a href=\"?page=1" . $send . "\" target=\"" . $target . "\">&laquo;</a> "; 
        echo "<a href=\"?page=$navi_back&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">&#8249;</a> "; 
    } 
    for($i = $navi_start; $i <= $navi_end; $i++){ 
        if($i == $page) 
        echo "<a href=\"?page=$i&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\"><strong>$i</strong></a> "; 
        else 
        echo "<a href=\"?page=$i&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">$i</a> "; 
    } 
    if($page < $total){ 
        $navi_next = $page+1; 
        echo "<a href=\"?page=$navi_next&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">&#8250;</a> "; 
        if(($page+1) < $total) 
        echo "<a href=\"?page=$total&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">&raquo;</a>"; 
    } 
} 

$page = (isset($_REQUEST['page']))? intval($_REQUEST['page']) : 1; 
$limit_end = 1; 
$limit_start = ($page-1)*$limit_end; 

$send = ""; 
if($detail != "" and $sta != ""){ 
    $send = "sta=" . $sta . "&detail=" . $detail; 
    $condition= " WHERE " . $sta . " LIKE '%" . $detail . "%'"; 
} 

$sql1 = "SELECT * FROM ads". $condition; 
$query_id = mysql_query($sql1 . " LIMIT " . $limit_start. "," . $limit_end ); 
$count = mysql_num_rows($query_id); 
$total = mysql_num_rows(mysql_query($sql1)); 
if($total > 0){

/*##################################################################################*/
          


  while($result=mysql_fetch_array($query_id))
{
$id=$result[id_ads];
$own_name=$result[own_name];
$own_tel=$result[own_tel];
$own_email=$result[own_email];
$min_price=$result[min_price];
$max_price=$result[max_price];
$horpak_name=$result[horpak_name];
$horpak_road=$result[horpak_road];
$horpak_tumboon=$result[horpak_tumboon];
$horpak_maung=$result[horpak_maung];
$horpak_zone=$result[horpak_zone];
$horpak_one=$result[horpak_one];
$province=$result[proviunce];
$univesity=$result[univesity];
$horpak_no=$reult[hopak_no];
$room_type=$result[room_type];
$horpak_type=$result[horpak_type];
$zip=$result[zip];
$air=$result[air];
$furniture=$result[furniture];
$horpak_website=$result[horpak_website];
$h_prakan=$result[h_prakan];
$h_klang=$result[h_klang];    
$pic1=$result[pic1];
$internet=$result[internet];
$air=$result[air];
$furniture=$result[furniture];
$horpak_website=$result[horpak_website];
$h_prakan=$result[h_prakan];
$h_klang=$result[h_klang];    
$pic1=$result[pic1];
 $ubc=$result[ubc];
$tel=$result[tel];
$bath=$result[bath];
$internet=$result[internet];
$sak_pa=$result[sakpa];
$bts=$result[bts];
$mrt=$result[mrt];
$internet=$result[internet];
$status=$result[status];
    if($status==1)
    {
    $status="1";
    $status="ไม่ว่าง";
    }
    else
    {
    $status="0";
    $status="<font class=menulink>ว่าง</font>";
    }

  ?>



          
<table width="95%"  border="0" align="center" cellpadding="5" cellspacing="2">
 <tr valign="top">

 ชื่อหอพัก :&nbsp;&nbsp;<font class="menumanage"> <a href="show_detail_all.php?id=<?=$result[id_ads]?>"><?=$result[horpak_name]?></a> &nbsp;<img src="pic/new_05.gif" border="0">&nbsp;<?=$status?></font><br>
ราคา:&nbsp;&nbsp;<font class="menulink"> <?=$result[min_price]?>-<?=$result[max_price]?></font><br>
 ประเภท:&nbsp;&nbsp;<font class="menudelete"> <?=$result[horpak_type]?></font><br>
 
ที่อยู่:&nbsp;&nbsp; <font class="menumanage">&nbsp;เลขที่<?=$result[horpak_no]?> ถนน.<?=$result[horpak_road]?>&nbsp;เขต. <?=$horpak_zone?>&nbsp;ต.<?=$result[horpak_tumboon]?>&nbsp;อ. <?=$result[horpak_maung]?>&nbsp;จ.<?=$result[province]?> &nbsp;<?=$result[zip]?></font><br><br>
 <?
 $atec="pic/air".$air.".gif";
 $fur="pic/furniture".$furniture.".gif";
 $ubc="pic/ubc".$ubc.".gif";
 $tel="pic/tel".$tel.".gif";
 $bath="pic/bath".$bath.".gif";
 $internet="pic/internet".$internet.".gif";
 $bts="pic/bts".$bts.".gif";
 $mrt="pic/mrt".$mrt.".gif";
 ?>
<img src="<?=$atec?>">&nbsp;<img src="<?=$fur?>">&nbsp;<img src="<?=$ubc?>">&nbsp;<img src="<?=$tel?>">&nbsp;<img src="<?=$bath?>">&nbsp;<img src="<?=$internet?>">&nbsp;<img src="<?=$bts?>">&nbsp;<img src="<?=$mrt?>"> <br>
<hr>
<td width="75%" >
      
</td>
</tr>
</table> 
<?

} }
echo "\n<div style=\"float:left;\">Page : " . page_navi($page, $limit_end, 4, $total, "current_page","other_page",$send) . " </div><div style=\"float:right;\">[" . ($limit_start+1) . "-" . ($limit_start+$count) . "] of <strong>" . $total . "</strong></div>"; 
}
?>

<?

    mysql_close();    
?> 
?>

<?php
$sta=$_REQUEST["sta"]; 
$detail=$_REQUEST["detail"]; 

     
      include 'connect.php'; 
      mysql_query('SET NAMES UTF8'); 
     
   print  $sql1="SELECT * FROM `ads` WHERE $sta LIKE '%$detail%'"; 
     
        $res=mysql_db_query($dbname,$sql1); 
          $check=mysql_num_rows($res); 
         
    if($check==0) 
        { 
            echo "<font class=\"menulink\"><center>ไม่พบข้อมูล</center>"; 
          } 
      else 
      { 
   
/*###################################################################################*/ 

function page_navi($page, $limit, $range, $count, $target="_self", $current_style="", $other_style="", $quetystring=""){  
    $total = ceil($count/$limit);  
    $navi_start = $page-$range;  
    $navi_end = $page+$range;  
      
    $send = !empty($querystring)? "&". $querystring : "";  
      
    if($navi_start <= 0) $navi_start = 1;  
    if($navi_end >= $total) $navi_end = $total;  
    if($page>1){  
        $navi_back = $page-1;  
        if($page > 2)  
        echo "<a href=\"?page=1" . $send . "\" target=\"" . $target . "\">&laquo;</a> ";  
        echo "<a href=\"?page=$navi_back&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">&#8249;</a> ";  
    }  
    for($i = $navi_start; $i <= $navi_end; $i++){  
        if($i == $page)  
        echo "<a href=\"?page=$i&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\"><strong>$i</strong></a> ";  
        else  
        echo "<a href=\"?page=$i&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">$i</a> ";  
    }  
    if($page < $total){  
        $navi_next = $page+1;  
        echo "<a href=\"?page=$navi_next&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">&#8250;</a> ";  
        if(($page+1) < $total)  
        echo "<a href=\"?page=$total&sta=$sta&detail=$detail" . $send . "\" target=\"" . $target . "\">&raquo;</a>";  
    }  
}  

$page = (isset($_REQUEST['page']))? intval($_REQUEST['page']) : 1;  
$limit_end = 1;  
$limit_start = ($page-1)*$limit_end;  

$send = "";  
if($detail != "" and $sta != ""){  
    $send = "sta=" . $sta . "&detail=" . $detail;  
    $condition= " WHERE " . $sta . " LIKE '%" . $detail . "%'";  
}  

print $sql = "SELECT * FROM ads". $condition;  
$query_id = mysql_query($sql . " LIMIT " . $limit_start. "," . $limit_end );  
$count = mysql_num_rows($query_id);  
$total = mysql_num_rows(mysql_query($sql));  
if($total > 0){ 

/*##################################################################################*/ 
           


  while($result=mysql_fetch_array($query_id)) 
{ 
$id=$result[id_ads]; 
$own_name=$result[own_name]; 
$own_tel=$result[own_tel]; 
$own_email=$result[own_email]; 
$min_price=$result[min_price]; 
$max_price=$result[max_price]; 
$horpak_name=$result[horpak_name]; 
$horpak_road=$result[horpak_road]; 
$horpak_tumboon=$result[horpak_tumboon]; 
$horpak_maung=$result[horpak_maung]; 
$horpak_zone=$result[horpak_zone]; 
$horpak_one=$result[horpak_one]; 
$province=$result[province]; 
$univesity=$result[univesity]; 
$horpak_no=$reult[hopak_no]; 
$room_type=$result[room_type]; 
$horpak_type=$result[horpak_type]; 
$zip=$result[zip]; 
$air=$result[air]; 
$furniture=$result[furniture]; 
$horpak_website=$result[horpak_website]; 
$h_prakan=$result[h_prakan]; 
$h_klang=$result[h_klang];     
$pic1=$result[pic1]; 
$internet=$result[internet]; 
$air=$result[air]; 
$furniture=$result[furniture]; 
$horpak_website=$result[horpak_website]; 
$h_prakan=$result[h_prakan]; 
$h_klang=$result[h_klang];     
$pic1=$result[pic1]; 
 $ubc=$result[ubc]; 
$tel=$result[tel]; 
$bath=$result[bath]; 
$internet=$result[internet]; 
$sak_pa=$result[sakpa]; 
$bts=$result[bts]; 
$mrt=$result[mrt]; 
$internet=$result[internet]; 
$status=$result[status]; 
    if($status==1) 
    { 
    $status="1"; 
    $status="ไม่ว่าง"; 
    } 
    else 
    { 
    $status="0"; 
    $status="<font class=menulink>ว่าง</font>"; 
    } 

  ?> 



           
<table width="95%"  border="0" align="center" cellpadding="5" cellspacing="2"> 
 <tr valign="top"> 

 ชื่อหอพัก :&nbsp;&nbsp;<font class="menumanage"><a href="show_detail_all.php?id=<?=$result[id_ads]?>"><?=$result[horpak_name]?></a>&nbsp;<img src="pic/new_05.gif" border="0">&nbsp;<?=$status?></font><br> 
ราคา:&nbsp;&nbsp;<font class="menulink"><?=$result[min_price]?>-<?=$result[max_price]?></font><br> 
 ประเภท:&nbsp;&nbsp;<font class="menudelete"><?=$result[horpak_type]?></font><br> 
  
ที่อยู่:&nbsp;&nbsp; <font class="menumanage">&nbsp;เลขที่<?=$result[horpak_no]?>ถนน.<?=$result[horpak_road]?>&nbsp;เขต.<?=$horpak_zone?>&nbsp;ต.<?=$result[horpak_tumboon]?>&nbsp;อ.<?=$result[horpak_maung]?>&nbsp;จ.<?=$result[province]?>&nbsp;<?=$result[zip]?></font><br><br> 
 <? 
 $atec="pic/air".$air.".gif"; 
 $fur="pic/furniture".$furniture.".gif"; 
 $ubc="pic/ubc".$ubc.".gif"; 
 $tel="pic/tel".$tel.".gif"; 
 $bath="pic/bath".$bath.".gif"; 
 $internet="pic/internet".$internet.".gif"; 
 $bts="pic/bts".$bts.".gif"; 
 $mrt="pic/mrt".$mrt.".gif"; 
 ?> 
<img src="<?=$atec?>">&nbsp;<img src="<?=$fur?>">&nbsp;<img src="<?=$ubc?>">&nbsp;<img src="<?=$tel?>">&nbsp;<img src="<?=$bath?>">&nbsp;<img src="<?=$internet?>">&nbsp;<img src="<?=$bts?>">&nbsp;<img src="<?=$mrt?>"> <br> 
<hr> 
<td width="75%" > 
       
</td> 
</tr> 
</table>  
<? 

} } 
echo "\n<div style=\"float:left;\">Page : " . page_navi($page, $limit_end, 4, $total, "current_page","other_page",$send) . " </div><div style=\"float:right;\">[" . ($limit_start+1) . "-" . ($limit_start+$count) . "] of <strong>" . $total . "</strong></div>";  
} 
?> 

<? 

    mysql_close();     
?>  

<?php
function page_navi($page, $limit, $range, $count, $send=NULL, $current_style="navi_on", $other_style="navi_out", $target="_self"){
    $output = "";
    $total = ceil($count/$limit);
    $navi_start = $page-$range;
    $navi_end = $page+$range;
    
    $send .= (!empty($send))? "&" : NULL;
        
    if($navi_start <= 0) $navi_start = 1;
    if($navi_end >= $total) $navi_end = $total;
    
    if($page>1){
        $navi_back = $page-1;
        if($page > 2)
        $output .= "<a href=\"?" . $send . "page=1\" target=\"" . $target . "\" class=\"" . $other_style . "\"><strong>&laquo;</strong></a> ";
        $output .= "<a href=\"?" . $send . "page=" . $navi_back . "\" target=\"" . $target . "\" class=\"" . $other_style . "\"><strong>&#8249;</strong></a> ";
    }
    for($i = $navi_start; $i <= $navi_end; $i++){
        if($i == $page)
        $output .= "<a href=\"?" . $send . "page=" . $i . "\" target=\"" . $target . "\" class=\"" . $current_style . "\"><strong><font color=\"" . $other_style . "\">$i</font></strong></a> ";
        else
        $output .= "<a href=\"?" . $send . "page=" . $i . "\" target=\"" . $target . "\" class=\"" . $other_style . "\">" . $i . "</a> ";
    }
    if($page < $total){
        $navi_next = $page+1;
        $output .= "<a href=\"?" . $send . "page=" . $navi_next . "\" target=\"" . $target . "\" class=\"" . $other_style . "\"><strong>&#8250;</strong></a> ";
        if(($page+1) < $total)
        $output .= "<a href=\"?" . $send . "page=" . $total . "\" target=\"" . $target . "\" class=\"" . $other_style . "\"><strong>&raquo;</strong></a>";
    }
    if($navi_start>$navi_end) 
        $output .= "<a href=\"?" . $send . "page=" . $page . "\" target=\"" . $target . "\" class=\"" . $other_style . "\"><strong>$page</strong></a> ";
    return $output;
} 

mysql_connect("localhost:3308", "root", "root") or die(mysql_error());
mysql_select_db("xxx") or die(mysql_error());
mysql_query("set character_set_results = utf8") or die(mysql_error());
mysql_query("set names utf8") or die(mysql_error());

$sta=$_REQUEST["sta"]; 
$detail=$_REQUEST["detail"]; 


$page = (isset($_REQUEST['page']))? intval($_REQUEST['page']) : 1;  
$limit_end = 1;  
$limit_start = ($page-1)*$limit_end;  

$send = "";  
if($detail != "" and $sta != ""){  
    $send = "sta=" . $sta . "&detail=" . $detail;  
    $condition= " WHERE " . $sta . " LIKE '%" . $detail . "%'";  
}  

$sql = "SELECT * FROM ads". $condition;  
$query_id = mysql_query($sql . " LIMIT " . $limit_start. "," . $limit_end );  
$count = mysql_num_rows($query_id);  
$total = mysql_num_rows(mysql_query($sql));  
if($total > 0){ 
	while($result=mysql_fetch_array($query_id)){ 
		echo $result["horpak_name"]."<br>"; 
	}
echo "\n<div style=\"float:left;\">Page : " . page_navi($page, $limit_end, 4, $total, $send) . " </div><div style=\"float:right;\">[" . ($limit_start+1) . "-" . ($limit_start+$count) . "] of <strong>" . $total . "</strong></div>";   
}else{
echo "ไม่มีอะไรในกอไผ่";
}
?>

<?php
$horpak_zone=$_REQUEST["horpak_zone"];  
$type_zone=$_REQUEST["type_zone"];  
$price_zone = array('','<2000','BETWEEN 2001 AND 2999','BETWEEN 3001 AND 3999','BETWEEN 4001 AND 4999','>5000');
$price = $price_zone[$_REQUEST[price_zone]];

$page = (isset($_REQUEST['page']))? intval($_REQUEST['page']) : 1;   
$limit_end = 1;   
$limit_start = ($page-1)*$limit_end;   

$send = "";   
if($horpak_zone != "" and $type_zone != "" and $price !=""){   
    $send = "horpak_zone=" . $horpak_zone . "&type_zone=" . $type_zone."&price=" .$price;   
    $condition= " WHERE  horpak_zone = '$horpak_zone ' AND horpak_type= '$type_zone' OR min_price $price OR max_price $price OR h_klang $price ";   
} 
else
{
$send = "horpak_zone=" . $horpak_zone . "&type_zone=" . $type_zone."&price=" .$price;   
    $condition= " WHERE  horpak_zone = '$horpak_zone ' AND horpak_type= '$type_zone' OR min_price $price OR max_price $price OR h_klang $price ";   
}
?>

<?php 
$page = (isset($_GET['page']))? intval($_GET['page']) : 1; 
$limit_end = 2; 
$limit_start = ($page-1)*$limit_end; 

$send = ""; 
if(isset($_GET["id"]) and $_GET["id"] != ""){ 
    $send = "id=" . $_GET["id"]; 
    $condition= " WHERE id= '" . $_GET["id"] . "'"; 
}  
$host="localhost";
$user="root";
$pass="123456";
$conn=mysql_connect("localhost","root","123456");
$sql = "SELECT * FROM member" . $condition; 
$query_id = mysql_query($sql . " LIMIT " . $limit_start. "," . $limit_end, $connection_id); 
$count = mysql_num_rows($query_id); 
$total = mysql_num_rows(mysql_query($sql, $connection_id)); 
if($total > 0){ 
    while($rows = mysql_fetch_assoc($query_id)){ 
        echo $rows["name"]."<br>"; 
    } 
echo "\n<div style=\"float:left;\">Page : " . page_navi($page, $limit_end, 4, $total, $send) . " </div><div style=\"float:right;\">[" . ($limit_start+1) . "-" . ($limit_start+$count) . "] of <strong>" . $total . "</strong></div>"; 
} 
?> 

<?php
$page = (isset($_POST['myPage']))? intval($_POST['myPage']) : 1;
?>