|
Source of: /browse.php
<?
$INCLUDE_PATH = "include";
Header( "Last-Modified: ".gmdate( "D, d M Y H:i:s",getlastmod()). " GMT");
require("$INCLUDE_PATH/shared.inc");
require("$INCLUDE_PATH/config.inc");
commonHeader("Browsing Classified");
if ($cat) {
if (empty($offset) || $offset < 0) {
$offset=0;
}
$limit = "100";
include("$INCLUDE_PATH/cnav.inc");
?>
<!--start marketing talk -->
<div align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif" color="#66CCFF">.</font><br>
<table width="95%" border="0" cellspacing="0" cellpadding="1">
<tr bgcolor="#000000">
<td valign="top">
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr bgcolor="#4B6FAF">
<td colspan="2" height="13">
<div align="right"><span class=ewhite>Classified Posts </span></div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="2">
<div align="center"><font size="1" face="MS Sans Serif" color="#FFFFFF">. </font><br>
<center>
<table cellspacing=0 border=0 width=90%>
<tr>
<td align=left> <font class=tblack><p><B>หมวดหมู่ : <? echo $cat; ?></B></p>
<?
mysql_connect($host,$user,$pass);
$sql = "select pid from classified where pcat='$cat' order by pid desc";
// --------------------------------------- starts
$result = mysql_db_query($database , $sql);
$num = mysql_num_rows($result);
$begin =($offset+1);
$end = ($begin+($limit-1));
if ($end > $num) {
$end = $num;
}
$sql = "select * from classified where pcat='$cat' order by pid desc limit $offset, $limit ";
$result = mysql_db_query($database , $sql);
// --------------------------------------- ends
echo "<br>พบข้อมูลที่ท่านค้นหาจำนวน <font color='red'>$num</font> ข้อมูล</b><br><br>";
echo "<font color=red>[ Showing results <b>$begin</b> to <b>$end</b>. ]</font><br><br>\n";
while($row=mysql_fetch_object($result)) {
$qnum=$row->pid;
if ($row->pwant == "ต้องการซื้อ") { echo "<img src='/images/want1.gif' align='absmiddle'> "; }
if ($row->pwant == "ต้องการขาย") { echo "<img src='/images/want2.gif' align='absmiddle'> "; }
if ($row->pwant == "ให้เช่า") { echo "<img src='/images/want3.gif' align='absmiddle'> "; }
if ($row->pwant == "ให้ฟรี") { echo "<img src='/images/want4.gif' align='absmiddle'> "; }
if ($row->pwant == "แลกเปลี่ยน") { echo "<img src='/images/want5.gif' align='absmiddle'> "; }
if ($row->pwant == "อื่นๆ") { echo "<img src='/images/want6.gif' align='absmiddle'> "; }
echo " <font class=tblack><a href=\"/view.php?id=$row->pid\">$row->ptitle</a> ";
if ($row->pcondition == "สินค้ามือหนึ่ง") { echo "<img src='/images/1st.gif' align='absmiddle'> "; }
if ($row->pcondition == "สินค้ามือสอง") { echo "<img src='/images/2nd.gif' align='absmiddle'> "; }
if ($row->pcondition == "ของสะสม ของหายาก") { echo "<img src='/images/collectible.gif' align='absmiddle'> "; }
if ($row->pcondition == "อื่นๆ") { echo "<img src='/images/others.gif' align='absmiddle'> "; }
echo "[ <font color=red><b>$row->pprice</b> บาท</font> ] ";
if ($row->pimage == "Y") { echo "<img src='/images/glasses.gif' align='absmiddle'> "; }
if ($row->pread > "50") { echo "<img src='/images/pop.gif' align='absmiddle'> "; }
list($date,$time) = explode(" ",$row->pdate);
list($year,$month,$day) = explode("-",$date);
$here = date("Y-m-d H:i:s");
list($hdate,$htime) = explode(" ",$here);
if ($date == $hdate) { echo "<img src='/images/new.gif' border='0' align='absmiddle' alt='new topic'> \n"; }
echo "- อ่าน <font color=green>($row->pread)</font> - ตอบ <font color=green>($row->panswer)</font><br>\n";
}
// ---------------------------------------
$url = $PHP_SELF . '?cat=' . $cat;
$change_pages = generate_pagination($url, $num, $limit, $offset);
echo "<p align=center>";
echo $change_pages;
echo "</p>";
// ---------------------------------------
/*
echo "<p align=center>";
if ($offset!=0) {
$prevoffset=$offset-$limit;
echo " <b><a href=\"?offset=$prevoffset&cat=$cat\">PREV $limit</a></b> \n";
}
$pages = intval($num/$limit);
if ($num%$limit) {
$pages++;
}
for ($i=1;$i<=$pages;$i++) {
if (($offset/$limit) == ($i-1)) {
echo " <b>[ $i ]</b> \n";
} else {
$newoffset=$limit*($i-1);
echo " <b>[ <a href=\"?offset=$newoffset&cat=$cat\" class='red'>$i</a> ]</b> \n";
}
}
if (!((($offset/$limit)+1)==$pages) && $pages!=1) {
$newoffset=$offset+$limit;
echo " <b><a href=\"?offset=$newoffset&cat=$cat\" class='red'>NEXT $limit</a></b> \n";
}
echo "</p>";
*/
// ---------------------------------------
?>
<!--
<div align="center"><br>
<font class="tblack"><font color="red">*** พบข้อความไม่เหมาะสม กรุณาแจ้งที่ :
<span class=eblack><b><a href="mailto:ban@market.in.th">ban@market.in.th</a>
</b></span> ***</font></font> </div> -->
</font>
<br><br><br><br>
<p align="left"><a href="/go.php?to=/post.php" alt="post new item">
<img src="/images/postnew.gif" border="0"align="left">
</a>
</p>
<br><br>
<p align="left"><a href="http://my.market.in.th/register.php" alt="register free membership">
<img src="/images/register.gif" border="0" align="left">
</a>
</p>
<br>
<br><br>
</td>
</tr>
</table>
</center>
<br><br>
</div>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
<!--end marketing talk -->
<?
} else {
require("$INCLUDE_PATH/database.inc");
include("./cat.php");
}
if (!$cat) { include("./top30.php"); }
// include("./talk/top.php");
include("$INCLUDE_PATH/source.inc");
commonFooter();
?>
จัดทำโดยทีมงาน Market in Thailand
Website : http://www.market.in.th
กรุณาอ่านคำเตือนและลิขสิทธิ์การนำไปใช้ต่างๆจากเราอย่างรอบคอบ ก่อนนำไปใช้งานจริง
ถ้าท่านต้องการทราบรายละเอียดและข้อมูลอื่นๆเพิ่มเติม สามารถหาอ่านได้จากหน้า
.
.
|
|
= 
= 
= 
= 
= 
= 
= 
= 
= 
= 
=
=
=
