<? session_start(); include "chksession.php"; ?> <!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> <meta http-equiv="Content-Type" content="text/html; charset=TIS-620" /> <title>Untitled Document</title> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; background-image: url(); background-repeat: no-repeat; } .style3 {color: #FFFFFF} .style4 { font-family: "Times New Roman", Times, serif; font-weight: bold; font-size: 18px; } .style6 {font-size: 14px} a:link { color: #0000FF; text-decoration: none; } a:visited { text-decoration: none; color: #0000FF; } a:hover { text-decoration: none; } a:active { text-decoration: none; } .style9 {color: #000000} .style10 { font-size: 26px; font-weight: bold; color: #0000FF; } .style14 {font-size: 18px} --> </style> <script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script> </head> <body> <? include("connect.php"); $sql="select * from type "; mysql_query("SET NAMES tis620"); $result=mysql_db_query($dbname,$sql); ?> <form id="form1" name="form1" method="post" action="ques_save.php"> <div align="center"> <table width="1024" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td height="235" colspan="6" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="312" height="234" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td height="234" colspan="2" valign="top"><img src="image/logo_zz.jpg" width="314" height="234" /></td> </tr> <tr> <td width="315" height="1"></td> <td width="315"></td> </tr> </table></td> <td width="769" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="773" height="235" valign="top"><img src="image/bgweb2.jpg" width="903" height="234" /></td> </tr> </table></td> </tr> </table></td> <td width="1"></td> </tr> <tr> <td height="80" colspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="311" height="80" valign="top" bgcolor="#000000"><span class="style3"> ค้นหา : <label> <input type="text" name="textfield3" id="textfield3" /> </label> <label> <input type="submit" name="button" id="button" value="GO" /> </label> </span></td> </tr> </table></td> <td colspan="4" valign="top" bgcolor="#000000"> <div align="center"> <a href="Homepage.php" target="_parent">หน้าแรก</a> |<a href="Member.php"> สมัครสมาชิก</a> | <a href="product1.php">สินค้า</a> | <a href="buy.php">วิธีการสั่งซื้อ</a> | <a href="shoppingcart.php">รถเข็นของคุณ</a> | <a href="payment.php">ชำระเงิน</a> | <a href="ques_view.php">กระดานคำถาม</a> | <a href="contact.php">ติดต่อเรา</a> |<a href="admin.php"> ผู้ดูแลระบบ</a></div></td> <td></td> </tr> <tr> <td width="250" rowspan="3" valign="top"><table width="55%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="251" height="187" valign="top"><table width="250" height="189" border="1" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="246" height="45" bgcolor="#0080FF"><div align="center">สมาชิก</div></td> </tr> <tr> <td height="45" valign="top" bgcolor="#A0A0A4"><strong>ยินดีต้อนรับคุณ</strong> <?=$sess_username?></td> </tr> <tr> <td height="45" valign="top" bgcolor="#A0A0A4">ท่านกำลังอยู่ในระบบ </td> </tr> <tr> <td height="23" bgcolor="#A0A0A4"><div align="center" class="style6"><a href="main.php">แก้ไขข้อมูลส่วนตัว</a> | <a href="logout.php">ออกจากระบบ</a> </a></div></td> </tr> <tr> <td height="29" bgcolor="#A0A0A4"><label> </label> <div align="center"> <input type="submit" name="button2" id="button2" value="Login" /> </div></td> </tr> </table></td> </tr> <tr> <td height="19"></td> </tr> </table></td> <td height="37" colspan="4" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="770" height="37" valign="top"><div align="center"> <p class="style4">ยินดีต้อนรับเข้าสู่ smileIT.com ....website เพื่อคน Like IT</p> </div></td> </tr> </table></td> <td width="197" rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="197" height="180" valign="top"><div align="right"><img src="image/pic1.jpg" width="159" height="180" align="middle" /></div></td> </tr> <tr> <td height="3"></td> </tr> </table></td> <td></td> </tr> <tr> <td colspan="3" rowspan="4" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="752" height="190" valign="top"><img src="image/pic3.jpg" alt="" width="751" height="190" /></td> </tr> </table></td> <td width="18" height="146"> </td> <td></td> </tr> <tr> <td height="40"> </td> <td> </td> <td></td> </tr> <tr> <td rowspan="7" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="250" height="394" valign="top"> <? $sql="select * from type "; mysql_query("SET NAMES tis620"); $result=mysql_db_query($dbname,$sql); print"<table width=100% border=1>"; print"<th bgcolor=#0080FF> ประเภทสินค้า </th>"; while($row=mysql_fetch_array($result)){ print"<tr>"; print"<td bgcolor=#A0A0A4 align=center><a href=show_pro_details.php?Type_id=$row[Pro_id]>$row[Type_name]</a></td>"; print"</tr>"; } print"</table>"; ?> </td> </tr> </table></td> <td height="2"></td> <td></td> <td></td> </tr> <tr> <td height="2"></td> <td rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="197" height="137" valign="top"><img src="image/cons-snb-gen2-core-i5-hero.png" width="197" height="137" /></td> </tr> </table></td> <td></td> </tr> <tr> <td colspan="4" rowspan="4" valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="770" height="397" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="770" height="397" valign="top"> <div align="center"> <? include "connect.php"; include "function.php"; // ปรับปรุงส่วนที่ 1 $page=$_GET[page]; if ($page=="") { $page=1; } $each=20; $sql="select * from web_board"; //แบ่งหน้า2 $result=mysql_db_query($dbname,$sql); $total=mysql_num_rows($result); $totalpage= ceil ($total/$each); $gotopage = ($page-1)*$each; $sql="select * from Web_board order by Web_id desc limit $goto,$each"; $result=mysql_db_query($dbname,$sql); echo " <h3> กระดานสนทนาถาม - ตอบ</h3> <a href='webboard.php'>ตั้งคำถามใหม่</a><p> <table width='80%' border='1'> <tr bgcolor='#D2E9FF'> <td width='1%'><center><b><font size='2' face='MS Sans Serif'>รหัส</font></b></center></td> <td width='61%'> <center><b><font size='2' face='MS Sans Serif'>หัวข้อคำถาม</font></b></center></td> <td width='15%'> <center><b><font size='2' face='MS Sans Serif'>ผู้ตั้งคำถาม</font></b></center></td> <td width='16%'> <center><b><font size='2' face='MS Sans Serif'>ตั้งเมื่อวันที่</font></b></center></td> </tr>"; while($record=mysql_fetch_array($result)) { $Web_id=$record[Web_id]; $Web_ques=$record[Web_ques]; $Web_detail=$record[Web_detail]; $Web_name=$record[Web_name]; $Web_email=$record[Web_email]; $Web_date= date ("Y-m-d"); $Web_ques=htmlspecialchars($Web_ques); $Web_name=htmlspecialchars($Web_name); $Web_detail=nl2br(htmlspecialchars($Web_ques)); $Web_date=displaydate($Web_date); echo " <tr bgcolor='#FFFFFF'> <td width='8%'><center><font size='2' face='MS Sans Serif'>$Web_id</font></center></td> <td width='61%'> <font size='2' face='MS Sans Serif'><a href='answer_view.php?Web_id=$Web_id'>". sensor($Web_detail) ."</a></font></td> <td width='15%'> <center><font size='2' face='MS Sans Serif'>$Web_name</font></center></td> <td width='16%'> <center><font size='2' face='MS Sans Serif'>$Web_date</font></center></td> </tr>"; } // end while echo "</table>"; if($totalpage>1){ echo "<b>หน้า $page</b><br>"; for ($i=1;$i<=$totalpage;$i++) { echo "| <a href='quse_view.php?page=$i '>$i </a>"; } } ?> </div></td> </tr> </table> </td> </tr> </table></td> <td height="135"></td> </tr> <tr> <td height="40"> </td> <td></td> </tr> <tr> <td height="137" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="197" height="137" valign="top"><img src="image/AMD.jpg" width="197" height="137" /></td> </tr> </table></td> <td></td> </tr> <tr> <td height="85"></td> <td></td> </tr> <tr> <td colspan="2" rowspan="2" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="747" height="177" valign="top"><img src="image/pic2.jpg" width="747" height="177" /></td> </tr> </table></td> <td width="5" height="6"></td> <td></td> <td></td> <td></td> </tr> <tr> <td height="171"></td> <td> </td> <td> </td> <td></td> <td></td> </tr> <tr> <td height="47" colspan="6" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0"> <!--DWLayoutTable--> <tr> <td width="1217" height="47" valign="top"><div align="center"><img src="image/logolow.jpg" width="934" height="47" /></div></td> </tr> </table></td> <td></td> </tr> <tr> <td height="521"> </td> <td width="61"></td> <td width="686"></td> <td> </td> <td> </td> <td> </td> <td></td> </tr> </table> </div> </form> </body> </html>
Quote:$sql="select * from Web_board order by Web_id desc limit $goto,$each"; $result=mysql_db_query($dbname,$sql);
$sql="select * from Web_board order by Web_id desc limit $goto,$each"; $result=mysql_query($sql) or die(mysql_error()." - SQL = ".$sql);
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง