ThaiSEOBoard.com

// รับค่าตัวแปล
	$gender = $_GET['tb_gender'];
	$age = $_GET['tb_age'];
	$province = $_GET['tb_province'];
	$photo = $_GET['tb_photo'];

// รับค่าตัวแปล ทำลิงค์ แบ่งหน้า
	$link_page =  "&gender=$gender&age=$age&province=$province&photo=$photo";

if (empty($page)){
		$page=1;
	}

	// กำหนดตัวแปล
	// ( 2 ) เพศ
	if ($gender=="0") {
		$gender_a = "";
	}
	else {
		$gender_a = "$gender";
	};

	// ( 3 ) อายุ
	if ($age=="0") {
		$age_a = "";
	}
	elseif ($age=="a1") {
		$age_a = "AND age < 18 ";
	}
	elseif ($age=="a2") {
		$age_a = "AND age between 18 and 20 ";
	}
	elseif ($age=="a3") {
		$age_a = "AND age between 21 and 30 ";
	}
	elseif ($age=="a4") {
		$age_a = "AND age between 31 and 40 ";
	}
	elseif ($age=="a5") {
		$age_a = "AND age > 41 ";
	}
	else {};

	// ( 4 ) จังหวัด
	if ($province=="0") {
		$province_a = "";
	}
	else {
		$province_a = "$province";
	};

	// ( 6 ) Picture
	if ($photo == "1") {
		$photo_a = "AND picture !='0'";
	}
	else {
		$photo_a = "";
	};


	// ติดต่อ database เพื่ออ่านข้อมูล	

	// หาจำนวนหน้าทั้งหมด
	mysql_connect($dbhost,$dbuname,$dbpass);
	$sql = "select * from $tblname WHERE (gender LIKE '%$gender_a%' or age LIKE '%$age_a%' or province LIKE '%$province_a%' or age LIKE '%$photo_a%')";
	//$sql = "SELECT * FROM $tblname WHERE (Name LIKE '%".$_GET["txtKeyword"]."%' or Email LIKE '%".$_GET["txtKeyword"]."%')";
	$result = mysql_db_query($dbname,$sql);
	$NRow = mysql_num_rows($result);


// แสดงผลของรายการทั้งหมด
$sql1 = "select * from $tblname WHERE (gender LIKE '%$gender_a%' or age LIKE '%$age_a%' or province LIKE '%$province_a%' or age LIKE '%$photo_a%')";
$result1 = mysql_db_query($dbname,$sql1);
$NRow1 = mysql_num_rows($result1);

<?

include "form_search1.php";
require_once ("config.inc.php");

// รับค่าตัวแปล
	$gender = $_GET['gender'];
	$age = $_GET['age'];
	$province = $_GET['province'];
	$photo = $_GET['photo'];

// รับค่าตัวแปล ทำลิงค์ แบ่งหน้า
	$link_page =  "&gender=$gender&age=$age&province=$province&photo=$photo";

if (empty($page)){
		$page=1;
	}

	// กำหนดตัวแปล
	// ( 1 ) เพศ
	if ($gender=="0") {
		$gender_key = "";
	}
	else {
		$gender_key = "$gender";
	};

	// ( 2 ) อายุ
	if ($age=="0") {
		$age_key = "";
	}
	elseif ($age=="1") {
		$age_key = "AND age < 18 ";
	}
	elseif ($age=="2") {
		$age_key = "AND age between 18 and 20 ";
	}
	elseif ($age=="3") {
		$age_key = "AND age between 21 and 30 ";
	}
	elseif ($age=="4") {
		$age_key = "AND age between 31 and 40 ";
	}
	elseif ($age=="5") {
		$age_key = "AND age > 41 ";
	}
	else {};

	// ( 3 ) จังหวัด
	if ($province=="0") {
		$province_key = "";
	}
	else {
		$province_key = "$province";
	};

	// ( 4 ) Picture
	if ($photo == "1") {
		$photo_key = "AND picture !='0'";
	}
	else {
		$photo_key = "";
	};


	// ติดต่อ database เพื่ออ่านข้อมูล	

	// หาจำนวนหน้าทั้งหมด
	mysql_connect($dbhost ,$dbuname,$dbpass);
	mysql_db_query($dbname,"SET NAMES utf8");

	//$sql = "select * from $tblname WHERE $pro $msn $icq $yahoo $qq sex LIKE '%$sex_a%' $age_a AND province LIKE '%$province_a%' AND cam LIKE '%$cam_a%' AND mic LIKE '%$mic_a%' $pic_a";
	//$sql = "SELECT * FROM $tblname WHERE gender LIKE '%$gender_a%' $age_a AND province LIKE '%$province_a%' AND $photo_a";
	$sql = "SELECT * FROM $tblname WHERE gender LIKE '%$gender_key%' OR age LIKE '%$age_key%' OR province LIKE '%$province_key%' OR photo LIKE '%$photo_key%' ;";
	$result = mysql_db_query($dbname,$sql);
	$NRow = mysql_num_rows($result);

	// แบ่งหน้าแสดง
	$per_page=$list_page;
		if (!$page) { 
			 $page = 1; 
		} 
	$prev_page = $page - 1; 
	$next_page = $page + 1; 
	$page_start = ($per_page * $page) - $per_page; 
	$result = mysql_db_query($dbname,$sql);
	$num_rows = $NRow ;
	if ($num_rows<= $per_page) { 
		 $num_pages = 1; 
	} else if (($num_rows % $per_page) == 0) { 
		 $num_pages = ($num_rows / $per_page); 
	} else { 
		 $num_pages = ($num_rows / $per_page) + 1; 
	} 
		$num_pages = (int) $num_pages; 

	if (($page > $num_pages) || ($page< 0)) { 
		 error("You have specified an invalid page number"); 
	}


// แสดงผลของรายการทั้งหมด
$sql1 = "SELECT * FROM $tblname WHERE gender LIKE '%$gender_key%' OR age LIKE '%$age_key%' OR province LIKE '%$province_key%' OR photo LIKE '%$photo_key%' order by id DESC LIMIT $page_start, $per_page";
$result1 = mysql_db_query($dbname,$sql1);
$NRow1 = mysql_num_rows($result1);

	if($NRow1==0) { 
		echo "<center>";
		echo "<br><br>";
		echo "<font size=2 face='MS Sans Serif'>ยังไม่มีข้อมูล</font><br><br><br>\n";
		echo "<center>";
	}

// แสดงข้อมูล
	else {

		echo "<table width=\"720\" cellpadding=\"2\" cellspacing=\"0\" align=\"center\">";
		echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"2\" width=\"100%\">
  <tbody>
    <tr align=\"center\" bgcolor=\"#4e4e4e\">
      <td class=\"pp_content\" width=\"163\" height=\"28\"><h6>Name</h6></td>
      <td class=\"pp_content\" width=\"269\"><h6>PIN. BB (Blackberry)</h6></td>
      <td class=\"pp_content\" width=\"522\"><h6>Message</h6></td>
      <td class=\"pp_content\" width=\"40\"><h6>Age</h6></td>
      <td class=\"pp_content\" width=\"64\"><h6>Gender</h6></td>
      <td class=\"pp_content\" width=\"142\"><h6>Province</h6></td>
    </tr>";

$i=0;
while( $arr = mysql_fetch_row( $result1 ) )
		{		
 // กำหนดสีของตาราง
		//$bgc = ($bgc==$rowColor1) ? $rowColor2 : $rowColor1; 
		if ($arr[4]=="0") {
			$bgc = "#ffffff";
			}
		elseif ($arr[4]=="M") {
			$bgc = "#feffc6";
			}
		elseif ($arr[4]=="F") {
			$bgc = "#ffebe1";
			}
		elseif ($arr[4]=="G") {
			$bgc = "#fae8fb";
			}
		elseif ($arr[4]=="L") {
			$bgc = "#f3f3f3";
			}
		else {};

		// กำหนดตัวแปล
		// For Admin Delete
		if ($admin_uid=$auid && $admin_pwd=$apwd) {
			$del = "<a href=delete.php?id=$arr[0]><img src=img/delete.gif border=0 alt=ลบ></a>";
			}
		else {};

		// เพศ
		if ($arr[4]=="0") {
			$sex = "ไม่ระบุ";
			}
		elseif ($arr[4]=="M") {
			$sex = "ชาย";
			}
		elseif ($arr[4]=="F") {
			$sex = "หญิง";
			}
		elseif ($arr[4]=="G") {
			$sex = "เกย์";
			}
		elseif ($arr[4]=="L") {
			$sex = "ทอม-ดี้";
			}
		else {};

		echo "<tr align=\"center\" bgcolor=$bgc>
      <td align=\"center\" height=\"28\">$arr[1]</td>
      <td align=\"left\" height=\"28\"><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"269\">
        <tbody>
          <tr>
            <td width=\"40\" height=\"40\"><table bgcolor=\"#ffdfbf\" border=\"0\" cellpadding=\"0\" cellspacing=\"1\" width=\"40\">
              <tbody>
                <tr>
                  <td align=\"center\" background=\"style_images/nolink.gif\" valign=\"middle\" height=\"40\"><img width=\"40\" height=\"40\" src=photo/$arr[8]></td>
                </tr>
              </tbody>
            </table></td>
            <td width=\"5\"></td>
            <td width=\"213\"><font size=\"2\" face=\"Tahoma\">PIN.BB - $arr[2]</font></td>
          </tr>
        </tbody>
      </table></td>
      <td align=\"left\">$arr[7]</td>
      <td><font size=\"2\" face=\"Tahoma\">$arr[5]</font></td>
      <td><font size=\"2\" face=\"Tahoma\">$sex</font></td>
      <td><font size=\"2\" face=\"Tahoma\">$arr[6]</font></td>
    </tr>";

		$i++;

		}
}

// ปิดการติดต่อฐานข้อมูล
mysql_close();

?>
<?

// แสดงหน้า link ไปยังหน้าอื่นๆ
echo "<tr align=\"center\" bgcolor=\"#f2f9ff\">";
echo "<td colspan=\"6\" align=\"center\" height=\"28\">";
for ($i = 1; $i<= $num_pages; $i++) { 
if ($i != $page) { 
echo " | <a href=showpin.php?page=$i>$i</a>"; } else { echo " | <B><font color=red>$i</font></B>"; }
 };
echo "</td></tr></tbody></table>";

// จบการแบ่งหน้า
?>