แก้ code ไม่ได้ไม่รู้ว่าเป็นที่อะไร
ทำค้นหาจาก $searchemail ใช้ได้ปกติกดไปหน้าอื่นได้ แต่พอทำ
ค้นหาจาก $searchname ข้อมูลมาปกติ แต่พอกดไป page ที่ 2 ข้อมูลมันมาหมดเลยค่ะไม่ได้กรองเฉพราะที่เราทำไว้
<?PHP
include("../public_inc.php");
?>
<?PHP
connectdb();
charSetThai();
loadControl();
$page = "menu3";
$searchname = $_GET["txtSearchIntell1"];
$searchemail = $_GET[urlencode("txtSearchIntell2")];
$pro=$_GET["pro"];
$Search_Requ = trim($requ["Select"]);
if ($Search_Requ) {
$sqlWhere = " AND (IntelligenceID = $Search_Requ) ";
} else {
$sqlWhere = "";
}
if ($_SERVER['SCRIPT_NAME']) {
$scriptnamePT = $_SERVER['SCRIPT_NAME'];
}
if ($_SERVER['QUERY_STRING']) {
$scriptnamePT .= "?" . $_SERVER['QUERY_STRING'];
$scriptnameQureyPT = "?" . $_SERVER['QUERY_STRING'];
}
$PageReferT = "expert.php" . $scriptnameQureyPT;
//mustLoginMember('th', $PageReferT);
//$activelogin = $_SESSION["activelogin"];
$sqlM = "SELECT * FROM mc_tblmember WHERE Email='$activelogin'";
$queM = mysql_query($sqlM);
if ($queM) {
$rwM = mysql_fetch_array($queM);
$Referencenumber = convertToText(stripStr($rwM["Referencenumber"]));
$FirstName = convertToText(stripStr($rwM["FirstName"]));
$LastName = convertToText(stripStr($rwM["LastName"]));
}
$sqlTopMenu_Rev1 = "SELECT * FROM mc_tblstatusstaticmenu";
$queTopMenu_Rev1 = mysql_query($sqlTopMenu_Rev1);
if ($queTopMenu_Rev1) {
while ($rwTopMenu_Rev1 = mysql_fetch_array($queTopMenu_Rev1)) {
$StaticMenuID_Rev1 = convertToText(stripStr($rwTopMenu_Rev1["MenuID"]));
$TopMenuTitleThai_Rev1[$StaticMenuID_Rev1] = convertToText(stripStr($rwTopMenu_Rev1["MenuTitleThai"]));
$TopMenuTitleEng_Rev1[$StaticMenuID_Rev1] = convertToText(stripStr($rwTopMenu_Rev1["MenuTitleEng"]));
$TopMenuOnlineStatus_Rev1[$StaticMenuID_Rev1] = convertToText(stripStr($rwTopMenu_Rev1["OnlineStatus"]));
$TopMenuDescriptionThai_Rev1[$StaticMenuID_Rev1] = convertToText(stripStr($rwTopMenu_Rev1["DescriptionThai"]));
$TopMenuDescriptionEng_Rev1[$StaticMenuID_Rev1] = convertToText(stripStr($rwTopMenu_Rev1["DescriptionEng"]));
$TopMenuKeywordsThai_Rev1[$StaticMenuID_Rev1] = convertToText(stripStr($rwTopMenu_Rev1["KeywordsThai"]));
$TopMenuKeywordsEng_Rev1[$StaticMenuID_Rev1] = convertToText(stripStr($rwTopMenu_Rev1["KeywordsEng"]));
}
}
?>
<!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>
<title>
<?= $TopMenuTitleThai_Rev1[6] ?>
</title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<meta name="Description" id="Description" content="<?=$TopMenuDescriptionThai_Rev1[6]?>" />
<meta name="keywords" content="<?=$TopMenuKeywordsThai_Rev1[6]?>">
<link rel="stylesheet" href="css/styles.css">
<link rel="stylesheet" type="text/css" href="../css/menu_intelligence.css">
<script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"></script>
<script src="css/script.js"></script>
</head>
<body style="margin:0px; padding:0px; text-align:center; background-color:#fafafa;">
<div class="wrapper">
<?PHP include("include_header.php"); ?>
<table width="100%" bgcolor="#161616" border="0">
<tr>
<td align="center"><?PHP include("include_menu.php"); ?></td>
</tr>
</table>
<table width="1150px" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="300px" style="padding-top:50px" align="left" valign="top">
<div style="width:250px">
<strong style="font-size:20px; color:#000; text-decoration:none">
ประเภทหน่วยงาน
</strong>
<ul style="padding:0px 0px 0px 10px">
<li style="list-style:circle; font-weight:bold; padding:5px"><a href="provider.php?pro=CB" style="font-size:12px; <? if($pro == 'CB'){ echo "color:#03C;"; }else{ echo "color:#000;"; } ?> text-decoration:none;">หน่วยรับรองระบบ (CB)</a></li>
<li style="list-style:circle; font-weight:bold; padding:5px"><a href="provider.php?pro=IB" style="font-size:12px; <? if($pro == 'IB'){ echo "color:#03C;"; }else{ echo "color:#000;"; } ?> text-decoration:none;">หน่วยตรวจ (IB)</a></li>
<li style="list-style:circle; font-weight:bold; padding:5px"><a href="provider.php?pro=CBSA" style="font-size:12px; <? if($pro == 'CBSA'){ echo "color:#03C;"; }else{ echo "color:#000;"; } ?> text-decoration:none;">หน่วยตรวจ (IB) มาตรฐานแรงงานไทย</a></li>
<li style="list-style:circle; font-weight:bold; padding:5px"><a href="provider.php?pro=EX" style="font-size:12px; <? if($pro == 'EX'){ echo "color:#03C;"; }else{ echo "color:#000;"; } ?> text-decoration:none;">ห้องปฏิบัติการทดสอบ</a></li>
<li style="list-style:circle; font-weight:bold; padding:5px"><a href="provider.php?pro=TS" style="font-size:12px; <? if($pro == 'TS'){ echo "color:#03C;"; }else{ echo "color:#000;"; } ?> text-decoration:none;">ห้องปฏิบัติการสอบเทียบ</a></li>
</ul><br/>
<?PHP
include("../include_columnright_search_provider.php");
?>
</div>
</td>
<td align="left" style="padding-top:30px;" valign="top"><img src="../images/intelligence/header_provider.jpg" border="0"/><br/><br/>
<table width="100%" cellspacing="0" cellpadding="0" class="contentContainer">
<tbody>
<tr>
<td class="textContainter">
เป็นการรวบรวมหน่วยงานที่เกี่ยวข้องด้านมาตรฐานและกฎระเบียบทางการค้าเชิงเทคนิค (ทั้งในประเทศและต่างประเทศ) โดยจัดทำเป็นฐานข้อมูล (Database)<br/><br/>
</td>
</tr>
</tbody>
</table>
<table width="100%">
<?PHP
$ProviderPage = 10;
$currentPage = $_SERVER["PHP_SELF"];
$pageNum = 1;
if (isset($_GET['page'])) {
$pageNum = $_GET['page'];
}
$startRowQuery = ($pageNum - 1) * $ProviderPage;
$condition = '1';
if($searchname != ''){ $condition .= " AND ProviderName Like '%{$searchname}%'" ;}
if($searchemail != '') {$condition .= " AND Email Like '$searchemail' " ;}
if($pro != ''){$condition .= " AND ProviderType Like '%{$pro}%'" ;}
$sqlProvider = "SELECT * FROM mc_tblserviceprovider WHERE $condition";
$querylimit = sprintf("%s LIMIT %d, %d", $sqlProvider, $startRowQuery, $ProviderPage);
//$querylimit = sprintf("%s LIMIT %d", $sql, $startRowQuery);
$Query = mysql_query($querylimit);
if (isset($_GET['totalRows'])) {
$totalRows = $_GET['totalRows'];
} else {
$allQuery = mysql_query($sqlProvider);
if ($allQuery) {
$totalRows = mysql_num_rows($allQuery);
}
}
$totalPages = ceil($totalRows / $ProviderPage);
$queProvider = mysql_query($querylimit);
if ($queProvider) {
while ($rwProvider = mysql_fetch_array($queProvider)) {
$Provider_Name = convertToText(stripStr($rwProvider["ProviderName"]));
$Provider_Contact = convertToText(stripStr($rwProvider["Contact"]));
$Provider_Address = convertToText(stripStr($rwProvider["Address"]));
$Provider_Telephone = convertToText(stripStr($rwProvider["Telephone"]));
$Provider_Fax = convertToText(stripStr($rwProvider["Fax"]));
$Provider_Email = convertToText(stripStr($rwProvider["Email"]));
$Provider_Website = convertToText(stripStr($rwProvider["Website"]));
?>
<tr bgcolor="#F3F3F3">
<td width='150px' style="background-color:#333; padding:5px 5px 5px 10px; color:#FFF"><strong>หน่วยรับรอง</strong></td>
<td style="padding:5px 5px 5px 10px"><strong><?=$Provider_Name?></strong></td>
</tr>
<tr bgcolor="#F3F3F3">
<td width='150px' style="background-color:#333; padding:5px 5px 5px 10px; color:#FFF"><strong>ที่อยู่</strong></td>
<td style="padding-left:10px"><?=$Provider_Address?></td>
</tr>
<tr bgcolor="#F3F3F3">
<td width='150px' style="background-color:#333; padding:5px 5px 5px 10px; color:#FFF"><strong>ชื่อผู้ติดต่อ</strong></td>
<td style="padding-left:10px"><?=$Provider_Contact?></td>
</tr>
<tr bgcolor="#F3F3F3">
<td width='150px' style="background-color:#333; padding:5px 5px 5px 10px; color:#FFF"><strong>โทรศัพท์</strong></td>
<td style="padding-left:10px"><?=$Provider_Telephone?></td>
</tr>
<tr bgcolor="#F3F3F3">
<td width='150px' style="background-color:#333; padding:5px 5px 5px 10px; color:#FFF"><strong>แฟกซ์</strong></td>
<td style="padding-left:10px"><?=$Provider_Fax?></td>
</tr>
<tr bgcolor="#F3F3F3">
<td width='150px' style="background-color:#333; padding:5px 5px 5px 10px; color:#FFF"><strong>อีเมล์</strong></td>
<td style="padding-left:10px">
<? if ($Provider_Email != "-"){
echo "<a href='mailto:".$Provider_Email."'>";
}
?>
<?=$Provider_Email?>
<? if ($Provider_Email != ""){
echo "</a>";
}
?>
</td>
</tr>
<tr bgcolor="#F3F3F3">
<td width='150px' style="background-color:#333; padding:5px 5px 5px 10px; color:#FFF"><strong>เว็บไซต์</strong></td>
<td style="padding-left:10px">
<? if ($Provider_Website != "-"){
//echo "<a href='http://".$Provider_Website."'>".$Provider_Website;
echo "<a href='http://".$Provider_Website."'>";
}
?>
<?=$Provider_Website?>
<? if ($Provider_Website != ""){
echo "</a>";
}
?>
</td>
</tr>
<tr><td colspan="2" height="10"></td></tr>
<?PHP
}
}
?>
</table>
<br/>
<br/>
<br/>
<div align="center" style="width:840px; word-wrap: break-word;">
<?PHP
if ($totalPages > 1) {
?>
<?PHP
for ($count = 0; $count < $totalPages;) {
$num = $count 1;
if ($pageNum == $num) {
echo "| <strong><span style="color: #183E8D;">$num</span></strong> ";
} else {
echo "| <a href="provider.php?page=$num&ProviderScope=$scope&ptype=$pro" style='text-decoration:none'><span style="color: #333333;">$num</span></a> ";
// echo "| <a href="provider_search_list.php?page=$num&serviceprovider=$condition&pro=$pro" style='text-decoration:none'><span style="color: #333333;">$num</span></a> ";
//echo "| <a href="provider.php?page=$num&ProviderScope=$scope&ptype=$ptype" style='text-decoration:none'><span style="color: #333333;">$num</span></a> ";
}
$count ;
} //end count page
echo "|";
?>
<?PHP
}
?>
</div>
</td>
</tr>
</table>
</div>
<!--<div id="footer">Copyright 2014 © Management System Certification Institute (Thailand). All rights reserved.</div>
<!-- BEGIN GOOGLE ANALYTICS CODE -->
<script type="text/javascript">
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-16046740-2']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? '[url]https://ssl[/url]' : 'http://www') '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
</script>
<!-- END GOOGLE ANALYTICS CODE -->
</body>
</html>