<? session_start(); include "connect1.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=windows-874" /> <title>กำหนดคนแก้ปัญหา</title> <style type="text/css"> <!-- .font { font-family: Tahoma, Geneva, sans-serif; font-size: 12px; } --> body { margin: 0px; padding: 0px; font-size: 12px; } </style> <style type="text/css"> </style> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_openBrWindow(theURL,winName,features) { //v2.0 window.open(theURL,winName,features); } //--> </script> </head> <body> <form id="form2" name="form2" method="post" action="showproblem.php"> <table width="811" border="1" align="center" cellpadding="0" cellspacing="0"> <tr align="center"> <th align="center" scope="col">ลำดับ</th> <th align="center" scope="col">วันที่แจ้ง</th> <th align="center" scope="col">เรื่อง</th> <th align="center" scope="col">ชื่อ-นามสกุล</th> <th align="center" scope="col">สถานะ</th> </tr> <input name="id3" type="hidden" id="id3" value="<?=$_REQUEST['id3'];?>" /> <tr align="center"> <td> <input name="id3" type="text" disabled="disabled" id="id3" value="<?=$_REQUEST['id3'];?>" /></td> <td><input name="date" type="text" disabled="disabled" id="date" value="<?=$_REQUEST['date'];?>" /></td> <td><input name="title" type="text" disabled="disabled" id="title" value="<?=$_REQUEST['title'];?>" /></td> <td><input name="name" type="text" disabled="disabled" id="name" value="<?=$_REQUEST['name'];?>" /></td> <td><input name="status3" type="text" disabled="disabled" id="status3" value="<?=$_REQUEST['status3'];?>" /></td> </tr> </table> </form> <form id="form1" name="form1" method="post" action=""> <? $id3=$_REQUEST['id3']; $sql="select * from information i ,staff_user su where i.SU_ID=su.SU_ID and i.P_ID=$id3"; //echo $sql; $dbquery = mysql_db_query($database_c, $sql); $num_rows = mysql_num_rows($dbquery); if( $num_rows>0) { ?> <table width="314" border="1" align="center" cellpadding="0" cellspacing="0"> <tr align="center"> <th colspan="6" scope="col">ผู้แก้ไขปัญหา</th> </tr> <tr align="center"> <td scope="col">รหัสพนักงาน</td> <td scope="col">ชื่อ-นามสกุล</td> <td scope="col">วันที่รับงาน</td> <td scope="col">ลบ</td> </tr><? while ($row=mysql_fetch_array($dbquery)){ $pid=$row['P_ID']; $id2=$row['SU_ID']; $first2=$row['SU_firstname']; $last2=$row['SU_lastname']; $name2=$first2." ".$last2; $date2=$row['I_date']; if( $date2=='') { $d='<a href=delstaffs.php?SU_ID='.$id2.'&P_ID='.$pid.'><img src="images/user_red.png" width="16" height="16" border="0"/></a>'; } else { $d=' '; } ?> <tr align="center"> <td scope="col"><? echo $id2;?></td> <td scope="col"><? echo $name2;?></td> <td scope="col"><? echo $date2; ?> </td> <td scope="col"><?=$d?> </td> </tr> <? }} ?> </table> </form> <form id="form3" name="form3" method="post" action=""> <table width="408" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td align="center" scope="col">ค้นหาผู้แก้ปัญหา <select name="search" id="search"> <option value="0" selected>กรุณาเลือก</option> <option value="SU_ID" >รหัสพนักงาน</option> <option value="SU_firstname">ชื่อ</option> </select></td> <th align="center" scope="col"><input type="text" name="box" id="box" /></th> <th align="center" scope="col"><input type="submit" name="submit" id="submit" value="ค้นหา" /></th> </tr> <tr> <td width="156" align="center" scope="col"> </td> <th width="144" align="center" style="" scope="col"> </th> <th width="50" align="center" scope="col"> </th> </tr> </table> </form> <form id="form1" name="form1" method="post" action="edithistory.php"> <table width="524" border="1" align="center" cellpadding="0" cellspacing="0"> <th width="77" align="center">รหัสพนักงาน</th> <th width="116" align="center">ชื่อ-นามสกุล</th> <th width="68" align="center">แผนก</th> <th width="55" align="center">ตำแหน่ง</th> <th width="73" align="center">สถานะ</th> <th width="82" align="center">บริษัท</th> <th align="center">เลือก</th> <? include "function.php"; if($_REQUEST['submit']) { $box=$_REQUEST['box']; $search=$_REQUEST['search']; $id3=$_REQUEST['id3']; echo $id3; //echo "$box"; //echo "$search"; $sql="select * from staff_user where $search like '%$box%' and Type_of_potential ='1'"; echo $sql; } else { $sql="select * from staff_user where Type_of_potential ='1'"; } //echo $sql; $dbquery = mysql_db_query($database_c, $sql); $num_rows = mysql_num_rows($dbquery); //echo $num_rows; if( $num_rows>0) { while ($row=mysql_fetch_array($dbquery)){ $subject=$row['SU_ID']; $subject1=$row['SU_firstname']; $subject2=$row['SU_lastname']; $subject3=$row['D_ID']; $subject4=$row['POS_ID']; $subject5=$row['Type_of_potential']; $subject6= getidc($row['C_ID']); $name=$subject1." ".$subject2; //echo $subject5; if($subject5=="0") { $a="user"; } else if($subject5=="1") { $a="staff"; } else if($subject5=="2") { $a="superviser"; } else if($subject5=="3") { $a="admin"; } // $id=$_REQUEST['edit_id']; ?> <tr> <td align="center" scope="col"><? echo $subject?></td> <td align="center" scope="col"><? echo $name?></td> <td align="center" scope="col"><? echo $subject3?></td> <td align="center" scope="col"><? echo $subject4?></td> <td align="center" scope="col"><? echo $a?></td> <td align="center" scope="col"><? echo $subject6?></td> <td width="35" align="center" scope="col"><a href=checkaddstaff.php?P_ID=<?=$id3?>&SU_ID=<?=$subject?>><img src="images/user_red.png" width="16" height="16" border="0"/></td> </tr> <? } } ?> </table> </form> </body> </html>
$sql = "select * from table1"; $query = mysql_query($sql); while($res = mysql_fetch_array($query)){ $res1 = $res["field_1"];//ถ้ามีหลายฟิลด์ก็สร้างตัวแปรขึ้นมาอีก $sqlI = "insert into table2 value('$res1')"; $queryI = mysql_query($sqlI); $sqlD = "delete table1 set field_1 = '$res1'"; $queryD = mysql_query($sqlD); }
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
