001.<table align="center" cellpadding="0" cellspacing="1" id="content">
002.<tr>
003.<th width="2%" scope="col"><div align="center" class="style18">คำนำหน้า</div></th>
004.<th width="12%" scope="col"><div align="center" class="style18">ชื่อ</div></th>
005.<th width="16%" scope="col"><div align="center" class="style18">นามสกุล</div></th>
006.<th width="2%" scope="col"><div align="center" class="style18">เพศ</div></th>
007.<th width="4%" scope="col"><div align="center" class="style18">โทรศัพท์</div></th>
008.<th width="4%" scope="col"><div align="center" class="style18">มือถือ</div></th>
009.<th width="25%" scope="col"><div align="center" class="style18">ตำแหน่ง</div></th>
010.<th width="10%" scope="col"><div align="center" class="style18">สังกัด</div></th>
011.<th width="25%" scope="col"><div align="center" class="style18">หมายเหตุ</div></th>
012.</tr>';
013.
014.<?
015.$sql_show = "select * from story";
016.
017.$Per_Page = 10;
018.if($_REQUEST['Page']){
019.$Page = $_REQUEST['Page'];
020.}else{
021.$Page=1;
022.}
023.$Prev_Page = $Page-1;
024.$Next_Page = $Page+1;
025.
026.
027.$Page_start = ($Per_Page*$Page)-$Per_Page;
028.$Num_Rows = mysql_num_rows($result_show);
029.
030.if($Num_Rows<=$Per_Page)
031.$Num_Pages =1;
032.else if(($Num_Rows % $Per_Page)==0)
033.$Num_Pages =($Num_Rows/$Per_Page) ;
034.else
035.$Num_Pages =($Num_Rows/$Per_Page) +1;
036.
037.$Num_Pages = (int)$Num_Pages;
038.
039.if(($Page>$Num_Pages) || ($Page<0))
040.print "<center><b>จำนวน $Page มากกว่า $Num_Pages ยังไม่มีข้อความ<b></center>";
041.$sql_show = "SELECT * FROM story LIMIT $Page_start , $Per_Page";
042.
043.if($_POST['Search'])
044.{
045.$txt_search = $_POST['txt_search'];
046.$sql_show.=" where rank like '%$txt_search%' or name like '%$txt_search%' or surname like '%$txt_search%' or sex like '%$txt_search%' or tel like '%$txt_search%' or mobile like '%$txt_search%' or position like '%$txt_search%' or department like '%$txt_search%' or note like '%$txt_search%' ";
047.}
048.
049.$result_show = mysql_query($sql_show) or die(mysql_error());
050.
051.if(mysql_num_rows($result_show)) {
052.
053.echo "<script>alert('ไม่พบข้อมูลที่ท่านค้นหา')</script>";
054.
055.} else {
056.
057.while($row_show = mysql_fetch_array($result_show))
058.{
059.?>
060.
061.
062.<tr>
063. <tr>
064. <td><div align="center"><?=$row_show['rank']?></div></td>
065. <td><div align="center"><?=$row_show['name']?></div></td>
066. <td><div align="center"><?=$row_show['surname']?></div></td>
067. <td><div align="center"><?=$row_show['sex']?></div></td>
068. <td><div align="center"><?=$row_show['tel']?></div></td>
069. <td><div align="center"><?=$row_show['mobile']?></div></td>
070. <td><div align="center"><?=$row_show['position']?></div></td>
071. <td><div align="center"><?=$row_show['department']?></div></td>
072. <td><div align="center"><?=$row_show['note']?></div></td>
073. </tr>
074.
075.<?
076.}
077.}
078.?>
079. <table width="700" border="0" align="center" cellpadding="5" cellspacing="0">
080. <tr>
081. <td align="center" class="text"> จำนวนข้อมูลผู้ใช้บริการทั้งหมด <?php echo $Num_Rows;?> รายการ รวมทั้งหมด : <?php echo $Num_Pages;?> หน้า </td>
082. </tr>
083. <tr>
084. <td align="center" class="text"><?php
085. if($Prev_Page)
086. echo " <a href='show.php?Page=$Prev_Page'><< ย้อนกลับ </a>";
087. for($i=1; $i<$Num_Pages; $i++){
088. if($i != $Page)
089. echo "<a href='show.php? Page=$i '> $i </a>";
090. else
091. echo " $i ";
092. }
093.
094. if($Page!=$Num_Pages)
095. echo "<a href ='show.php?Page=$Next_Page'> หน้าถัดไป >> </a>";
096.mysql_close();
097.?></td>
098.</table>
099.
100.</table>
