<? @session_start(); ob_start(); $useradmin = $_SESSION["useradmin"]; if(empty($useradmin)) { echo "<script>alert('หน้านี้จำกัดเฉพาะ Admin เท่านั้น');history.back();</script>"; exit(); } require_once "connectdb.php"; require_once "tdate.php"; $sql="select * from adminlogin where useradmin='$useradmin'"; $db_query=mysql_db_query($db,$sql); $result=mysql_fetch_array($db_query); $adminname=$result[adminname]; ?> <html> <head> <title>-:- wanornit -:-</title> <meta http-equiv="Content-Type" content="text/html; charset=tis-620"> <link href="style.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- .style1 {color: #FFFFFF} --> </style> </head> <body bgcolor="#5A697E" onLoad="javascript:document.getElementById('useradmin').focus();"> <table width="84%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td bgcolor="#003399"> <div align="center"><strong><font color="#FFFFFF" size="+1">ระบบบันทึกรายละเอียดครุภัณฑ์คอมพิวเตอร์</font></strong></div></td> </tr> <tr> <td bgcolor="#FFFFFF"><table width="100%" border="0" cellspacing="1" cellpadding="1"> <tr> <td><div align="right"><font color="#ff0000" size="2"><font color="#333333">ยินดีต้อนรับ :</font> <font color="#ff0000"><? echo "<u>$adminname</u>"; ?> <font color="#666666">เข้าสู่ระบบ </font></font></font></div></td> </tr> <tr> <td><div align="right"><font color="#666666" size="2"><a href="home.php">หน้าหลักระบบ</a> | <a href="logout.php">ออกจากระบบ</a></font></div></td> </tr> <tr> <td><div align="center"> <table width="861" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="164" valign="top"><a href="add.php"><font color="#FF0000" size="2">เพิ่มรายละเอียดคอมพิวเตอร์</font></a></td> <td width="697"><table width="100%" border="0" cellspacing="1" cellpadding="1"> <form method="post" action="search.php"> <tr> <td width="10%"><div align="right">ค้นหา : </div></td> <td width="21%"><input type=text name=txtsearch size=20 class=input></td> <td width="69%"> <input name="searchtype" type="radio" value="code" checked> เลขครุภัณฑ์ <input name="searchtype" type="radio" value="cpu"> CPU <input type="radio" name="searchtype" value="ram"> RAM <input type="radio" name="searchtype" value="year"> ปีที่ใช้ </td> </tr> <tr> <td><div align="right">ค้นหา : </div></td> <td><select id="select" name="select_depart" onChange="" > <option value="">- กรุณาเลือก -</option> <?php $query_list=mysql_query("Select * From department order by Dept_id"); while($sl < mysql_num_rows($query_list)){ $arrL= mysql_fetch_array($query_list); ?> <option value="<?php echo $arrL[Dept_name];?>"><?php echo $arrL[Dept_name];?></option> <?php $sl++; } ?> </select></td> <td> <input type="radio" name="searchtype" value="location"> สถานที่ติดตั้ง </td> </tr> <tr> <td> </td> <td><input name="Submit" type="submit" class="submitad" value="ค้นหา"></td> <td> </td> </tr> </form> </table></td> </tr> <tr> <td colspan="2"><font size="2">ข้อมูลที่ค้นหา : <font color="#000066"><? echo $_POST["txtsearch"]; ?><? echo $_POST["select_depart"]; ?></font></font></td> </tr> </table> <table width="98%" border="0" align="center" cellpadding="1" cellspacing="1"> <tr> <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr class="jobscss"> <td bgcolor="#FFFFFF"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#000000"><table width="100%" border="0" cellspacing="1" cellpadding="1"> <tr bgcolor="#006666"> <td width="41" height="24"> <div align="center"><font color="#FFFFFF" size="2">ลำดับ</font></div></td> <td width="150"> <div align="center"><font color="#FFFFFF" size="2">เลขครุภัณฑ์</font></div></td> <td width="90"><div align="center"><font color="#FFFFFF" size="2">cpu</font></div></td> <td width="80"><div align="center"><font color="#FFFFFF" size="2">ram</font></div></td> <td width="69"><div align="center"><span class="style1">HD</span></div></td> <td width="98"><div align="center" class="style1">Mainboard</div></td> <td width="79"><div align="center" class="style1">ราคา</div></td> <td width="115"><div align="center" class="style1">IP Address </div></td> <td width="79"><div align="center" class="style1">ชื่อผู้ใช้</div></td> <td width="110"><div align="center" class="style1">สถานที่ติดตั้ง</div></td> <td width="69"><div align="center" class="style1">ปีที่ใช้</div></td> <td width="66"> <div align="center"><font color="#FFFFFF" size="2">แก้ไข-ลบ</font></div></td> </tr> </table></td> </tr> </table> <? if($_POST["select_depart"] != "") { if($_POST["searchtype"] == "location") { $searchtype = $_POST["searchtype"]; $txtsearch = $_POST["select_depart"]; }else{ echo "<script>"; echo "alert('กรุณาเลือกสถานที่ตั้ง');"; echo "</script>"; echo "<meta http-equiv=\"refresh\" content=\"0;URL=search.php\" />"; exit; } }elseif($_POST["txtsearch"] != "") { $searchtype = $_POST["searchtype"]; $txtsearch = $_POST["txtsearch"]; }else { $strSQL_member = "select * from member"; $objQuery_member = mysql_query($strSQL_member); $objResult_member = mysql_fetch_array($objQuery_member); $searchtype = "code"; $txtsearch = ""; } $page = $_GET['page']; $num = 1; $select_type="select * from member where $searchtype LIKE '%$txtsearch%' order by id asc"; $query_select=mysql_query($select_type); $num_rows=mysql_num_rows($query_select); if($num_rows<1){ echo "<br><br><center><font color=#666666 face=tahoma size=2>ไม่พบข้อมูลทีี่ท่านค้นหาค่ะ</font></center>"; }else{ $select="select * from member where $searchtype LIKE '%$txtsearch%' order by id asc"; $q_ry = mysql_query($select); $num_rows=mysql_num_rows($q_ry); $pagesize=15; $rt=$num_rows%$pagesize; if($rt!=0) { $totalpage=floor($num_rows/$pagesize)+1; } else { $totalpage=floor($num_rows/$pagesize); $toppic_id=1; } if(empty($page)) { $page=1; } mysql_free_result($q_ry); $goto=($page-1)*$pagesize; $sql_select_mem="Select * From member where $searchtype LIKE '%$txtsearch%' order by id asc limit $goto,$pagesize"; $fect=mysql_query($sql_select_mem); if(!$fect) { ("ติดต่อฐานข้อมูลไม่ได้".mysql_error()); exit; } $bgcount=0; while($rows=mysql_fetch_array($fect)) { $idmember =$rows['id']; $code =$rows['code']; $cpu =$rows['cpu']; $ram =$rows['ram']; $HD =$rows['HD']; $Mainboard =$rows['Mainboard']; $account =$rows['account']; $ipadd =$rows['ipadd']; $price =$rows['price']; $location =$rows['location']; $year =$rows['year']; ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#000000"><table width="100%" border="0" cellspacing="1" cellpadding="1"> <tr bgcolor="#FFFFFF"> <td width="41" height="24"> <div align="center"><font color="#990000" size="2"><? echo "$num"; ?></font></div></td> <td width="150"><font color="#003366" size="2"><? echo "$code"; ?></font><br> <div align="left"></div></td> <td width="90"><font color="#003366" size="2"><? echo "$cpu"; ?></font></td> <td width="80"><font color="#003366" size="2"><? echo "$ram"; ?></font></td> <td width="69"><font color="#003366" size="2"><? echo "$HD"; ?></font></td> <td width="98"><font color="#003366" size="2"><? echo "$Mainboard"; ?></font></td> <td width="79"><div align="right"><font color="#003366" size="2"><? echo "$price"; ?></font></div></td> <td width="115"><font color="#003366" size="2"><? echo "$ipadd"; ?></font></td> <td width="79"><font color="#003366" size="2"><? echo "$account"; ?></font></td> <td width="110"><font color="#003366" size="2"><? echo "$location"; ?></font></td> <td width="69"><font color="#003366" size="2"><? echo "$year"; ?></font></td> <td width="66"><div align="center"><a href=edit.php?id=<? echo "$idmember"; ?>><img src="images/pencil.jpg" width="20" height="20" border="0"></a> <a href=del.php?id=<? echo "$idmember"; ?> onClick="return confirm ('คุณต้องการลบข้อมูลนี้? ')"><img src=images/delete.png width=22 height=22 border=0 alt=ลบข้อมูล></a></div></td> </tr> </table></td> </tr> </table> <? $num = $num+1; } echo "<div align=center><br> <font color=#999999 size=2><span class=cc> "; for($i=1;$i<$page;$i++) { echo"<a href='$PHP_SELF?page=$i'><font size=2 color='#000000' class=textborder>$i</font></a> "; } echo"<font size=2 color=#000000><b><font size=2 color='#FF00000' class=textborderok>$page</font></b></font> "; for($i=$page+1;$i<=$totalpage;$i++) { echo"<a href='$PHP_SELF?page=$i'><font size=2 color='#000000' class=textborder>$i</font></a> "; } echo "</span></font> </div>"; } ?> </td> </tr> <tr class="jobscss"> <td height="19"> </td> </tr> <tr> <td><div align="center"></div></td> </tr> </table></td> </tr> </table> </div></td> </tr> <tr> <td> </td> </tr> </table></td> </tr> <tr> <td><div align="center"><? echo "<font size=2 color=#ffffff>$footerweb</font>"; ?></div></td> </tr> </table> </body> </html>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
Load balance : Server 03
Load balance : Server 03
