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