001.<?
002.session_start();
003.include "checksession.php";
004.include "ConnectionDb.php";
005.?><?
006.
007.$page=$_GET['page'];
008.if($page==""){
009. $page=1;
010.}
011.$each=10;
012.
013.$sql_cat= "SELECT * FROM tbsection";
014.$result_cat = mysql_query($sql_cat);
015.$totals = mysql_num_rows($result_cat);
016.
017.$totalpages=ceil ($totals/$each);
018.$totals = ($page-1)*$each;
019.
020.$sql_cat = "SELECT * FROM tbsection ORDER BY sectioned DESC limit $goto,$each";
021.$result_cat = mysql_query ($sql_cat);
022.
023.$sq ="SELECT MAX (sectionid) AS sectioned FROM tbsection";
024.$result=mysql_query($sql);
025.$dbarr=mysql_fetch_array($result);
026. If ($dbarr) {
027. $total=$dbarr['sectionid' ]+1;
028. If (strLen($total)== "1" ) {
029. $total= "0" .$total;
030.} else {
031. $total= $total;
032. }
033.} else {
034. $total= $ectionid ;
035.}
036.?>
037.
038.<table width="700" border="0" align="center" cellpadding="1" cellspacing="1"
039.Bordercolordark="#FFFFFF">
040. <tr>
041. <td colspan="5" bgcolor="#FFCCCC" align="center"><b>รายการข้อมูลประเภทชุด</b></td>
042.</tr>
043.<tr bgcolor="#FFFFCC">
044. <td width="169" align="center">รหัสประเภทชุด</td>
045. <td width="320" align="center">ชื่อประเภท</td>
046. <td width="120" align="center">แก้ไข</td>
047. <td width="190" align="center">ลบ</td>
048.</tr>
049.<?
050.While ($dbarr_cat = mysql_fetch_array($result_cat)) {
051.?>
052. <tr bgcolor="#F4F4F4">
053.
054.<td align="center"><?=$dbarr_cat['sectionid'];?></td>
055.<td><?=$dbarr_cat['sectionname'];?></td>
056.<td align ="center">[ <a href="main.php?menu=1&do=edit&id=<?=$dbarr_cat['sectionid'];
057.?>">แก้ไข</a> ]</td>
058. <td align= "center">[ <a href="main.php?menu=1&do=delete&id=<?=$dbarr_cat
059.['sectionid'];?>">ลบ</a> ]</td>
060. </tr>
061.<?
062.}
063.?>
064. <tr bgcolor="#F4F4F4" >
065. <td colspan="4" align="right">มีทั้งหมด <?=$totals;?> รายการ :
066. <?
067. If ($totalpages>1) {
068. For ($i=1;$i<=$totalpages;$i++) {
069. If ($i == $page) {
070. echo "<b> หน้า$page</b>";
071. } else {
072. echo "I <a href =\"main.php?menu=1&do=add&page=$i\">$i</a> ";
073. }
074. }
075. }
076. ?>
077. </td>
078.</tr>
079.</table>
080.
081.<?
082.$sql= "SELECT * FROM tbsection WHERE sectioned ='$_REQUEST[id]'" ;
083.$result=mysql_query($sql);
084.$dbarr=mysql_fetch_array($result);
085.?>
086.
087.<form name="frmEdit" method="post" action="main.php?menu=1&do=edit&doding=edit">
088.<table width ="300" border="0" align="center" cellpadding="0" cellspacing="0"
089.Bordercolordark="#FFFFFF">
090. <tr>
091. <td bgcolor="#FFCCCC" align="center"><b>::แก้ไขประเภทชุด:: <?=$dbarr['sectionid'];?>
092.</b><td>
093. </tr>
094. <tr>
095. <td>
096. <table width="700" border="0" align="center" cellpadding="5" cellspacing="1">
097. <tr bgcolor="#F4F4F4">
098.<td width="25%" align="right">รหัสประเภทชุด</td>
099.<td width="25%" $=dbarr['sectionid'];?></td>
100.<td width="15%">ชื่อชุด</td>
101.<td width="35%"><input type="text" name="stypeName" value="<?=$dbarr['sectionname'];?>"></td>
102.</tr>
103.<tr bgcolor="#F4F4F4">
104.<td colspan="6" align=" center">
105.
106.<input type="hidden" name="id_edit" value="<?=$dbarr['sectiondi'];?>">
107.<input type="submit" name="button" value="แก้ไข">
108.<input type="reset"name="reset" value="ล้างข้อมูล">
109.</td>
110.</tr>
111.</table>
112.</td>
113.</tr>
114.</table>
115.</form>
