<? ids = array(1, 2, 5, 7, 10, 21, 33); foreach($ids as $val){ mysql_query("UPDATE ..... } ?>
<?php $con_db=mysql_pconnect("localhost","root","")or die("ไม่สามารถติดต่อฐานข้อมูลได้"); $db = mysql_select_db("it_system")or die ("ไม่สามารถเลือกฐานข้อมูลได้"); $student_id = trim($_POST["se_id"]); $first_name = trim($_POST["se_fn"]); $last_name = trim($_POST["se_la"]); $tb = "select * from time_table where student_id like '%$student_id%' AND first_name like '%$first_name%' AND last_name like '%$last_name%' "; $tbquery=mysql_query($tb); $num = mysql_num_rows($tbquery) ; $result=mysql_fetch_array($tbquery); if($num==0){ echo "ไม่พบคำที่ต้องการค้นหา" ; } else { ?> <style type="text/css"> <!-- .style5 {font-family: "Microsoft Sans Serif"; font-size: 14; } .style9 {font-family: "Microsoft Sans Serif"; font-size: 14px; } --> </style> <table width="591" border="1"> <tr> <td width="88"><span class="style9">ปีการศึกษา</span></td> <td width="9"><span class="style9">:</span></td> <td width="88"><span class="style9"> <?=$result['school_year'];?> </span></td> <td width="88"><span class="style9">ภาคเรียนที่</span></td> <td width="8"><span class="style9">:</span></td> <td width="58"><span class="style9"> <?=$result['term'];?> </span></td> <td width="101"><span class="style9">รหัสนักศึกษา</span></td> <td width="8"><span class="style9">:</span></td> <td width="85"><span class="style9"> <?=$result['student_id'];?> </span></td> </tr> </table> <table width="641" border="1"> <tr> <td width="83"><span class="style9">คำนำหน้า</span></td> <td width="8"><span class="style9">:</span></td> <td width="68"><span class="style9"> <?=$result['title'];?> </span></td> <td width="42"><span class="style9">ชื่อ</span></td> <td width="7"><span class="style9">:</span></td> <td width="137"><span class="style9"> <?=$result['first_name'];?> </span></td> <td width="77"><span class="style9">นามสกุล</span></td> <td width="6"><span class="style9">:</span></td> <td width="159"><span class="style9"> <?=$result['last_name'];?> </span></td> </tr> </table> <p> </p> <p> </p> <table width="678" border="1" align="center"> <tr> <td width="106" class="style5"><div align="center"><span class="style5">รหัสวิชา</span></div></td> <td width="123" class="style5"><div align="center"><span class="style5">ชื่อวิชา</span></div></td> <td width="59" class="style5"><div align="center"><span class="style5">วัน</span></div></td> <td width="118" class="style5"><div align="center"><span class="style5">เวลา</span></div></td> <td width="74" class="style5"><div align="center"><span class="style5">ห้องเรียน</span></div></td> <td width="158" class="style5"><div align="center"> <table width="200" border="1"> <tr> <td class="style5"><div align="center">อาจารย์ผู้สอน</div></td> </tr> </table> <table width="204" border="1"> <tr> <td width="85" class="style5"><div align="center">ชื่อ</div></td> <td width="103" class="style5"><div align="center">นามสกุล</div></td> </tr> </table> </div></td> </tr> <? while($result=mysql_fetch_array($tbquery)) { ?> <tr> <td class="style5"><div align="center"><span class="style5"> <?=$result['subject_code'];?> </span></div></td> <td class="style5"><div align="center"><span class="style5"> <?=$result['subject_name'];?> </span></div></td> <td class="style5"><div align="center"><span class="style5"> <?=$result['learn_day'];?> </span></div></td> <td class="style5"><div align="center"><span class="style5"> <?=$result['learn_time'];?> </span></div></td> <td class="style5"><div align="center"><span class="style5"> <?=$result['class_room'];?> </span></div></td> <td class="style5"><div align="center"> <table width="200" border="1"> <tr> <td width="83" class="style5"><div align="center"> <?=$result['teacher_first_name'];?> </div></td> <td width="101" class="style5"><div align="center"> <?=$result['teacher_last_name'];?> </div></td> </tr> </table> </div></td> </tr> <? } } //} //} ?> </table> <table width="678" border="1" align="center"> <tr> <td>จัดการข้อมูล</td> <td><div align="center"><a href="from_update_time_table.php?id=<?=$result['id'];?>"><img src="../image/Config-Tools.jpg" width="25" height="25" border="0" /></a></div></td> <td><div align="center"><img src="../image/delete.jpg" width="25" height="25" /></div></td> </tr> </table>
<? for($i=0;$i<=count($_POST['id']);$i++) { $con_db=mysql_pconnect("localhost","root","")or die("ไม่สามารถติดต่อฐานข้อมูลได้"); $db = mysql_select_db("it_system")or die("ไม่สามารถเลือกฐานข้อมูลได้"); $tb = "SELECT * FROM time_table WHERE id ='$id' "; $tbquery=mysql_query($tb); $result = mysql_fetch_array($tbquery); ?><style type="text/css"> <!-- .style5 {font-family: "Microsoft Sans Serif"; font-size: 14px; } --> </style> <form name="form1" method="post" action=""> <table width="782" border="1"> <tr> <td width="88"><span class="style5">ปีการศึกษา</span></td> <td width="7"><span class="style5">:</span></td> <td width="149"><span class="style5"> <label> <input name="school_year" type="text" id="school_year"value="<?=$result['school_year'];?>"/> </label> </span></td> <td width="76"><span class="style5">ภาคเรียนที่</span></td> <td width="7"><span class="style5">:</span></td> <td width="144"><span class="style5"> <label> <input name="term" type="text" id="term"value="<?=$result['term'];?>"> </label> </span></td> <td width="80"><span class="style5">รหัสนักศึกษา </span></td> <td width="8"><span class="style5">:</span></td> <td width="165"><span class="style5"> <label> <input name="student_id" type="text" id="student_id"value="<?=$result['student_id'];?>"> </label> </span></td> </tr> </table> <table width="689" border="1"> <tr> <td width="67"><span class="style5">คำหน้านาม</span></td> <td width="4"><span class="style5">:</span></td> <td width="144"><span class="style5"> <label> <input name="title" type="text" id="title"value="<?=$result['title'];?>"> </label> </span></td> <td width="17"><span class="style5">ชื่อ</span></td> <td width="4"><span class="style5">:</span></td> <td width="144"><span class="style5"> <label> <input name="first_name" type="text" id="first_name"value="<?=$result['first_name'];?>"> </label> </span></td> <td width="51"><span class="style5">นามสกุล</span></td> <td width="4"><span class="style5">:</span></td> <td width="196"><span class="style5"> <label> <input name="last_name" type="text" id="last_name"value="<?=$result['last_name'];?>"> </label> </span></td> </tr> </table> <p> </p> <table width="1090" border="1" align="center"> <tr> <td width="61"><div align="center"><span class="style5">รหัสวิชา</span></div></td> <td width="53"><div align="center"><span class="style5">ชื่อวิชา</span></div></td> <td width="51"><span class="style5">หน่วยกิต</span></td> <td width="51"><div align="center"><span class="style5">วัน</span></div></td> <td width="145"><div align="center"><span class="style5">เวลา</span></div></td> <td width="120"><div align="center"><span class="style5">ห้องเรียน</span></div></td> <td width="218"><div align="center"> <table width="327" border="1" align="center"> <tr> <td><div align="center"><span class="style5">ผู้สอน</span></div></td> </tr> </table> <table width="327" border="1" align="center"> <tr> <td width="164"><div align="center"><span class="style5">ชื่อ</span></div></td> <td width="147"><div align="center"><span class="style5">นามสกุล</span></div></td> </tr> </table> </div></td> </tr> <tr> <td><label> <input name="subject_code[]" type="text" id="subject_code[]"value="<?=$result['subject_code']['$i'];?>" size="9"> </label></td> <td><label> <input name="subject_name" type="text" id="subject_name"value="<?=$result['subject_name'];?>" size="30"> </label></td> <td><label> <input name="credit" type="text" id="credit"value="<?=$result['credit'];?>" size="2"> </label></td> <td><label> <input name="learn_day" type="text" id="learn_day"value="<?=$result['learn_day'];?>" size="5"> </label></td> <td><label> <input name="learn_time" type="text" id="learn_time"value="<?=$result['learn_time'];?>" size="10"> </label></td> <td><label> <input name="class_room" type="text" id="class_room"value="<?=$result['class_room'];?>" size="5"> </label></td> <td><div align="center"> <table width="331" border="1" align="center"> <tr> <td width="162"><span class="style5"> <label> <input name="teacher_first_name" type="text" id="teacher_first_name"value="<?=$result['teacher_first_name'];?>"> </label> </span></td> <td width="154"><span class="style5"> <label> <input name="teacher_last_name" type="text" id="teacher_last_name"value="<?=$result['teacher_last_name'];?>"> </label> </span></td> </tr> </table> </div> <label></label></td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> </table> <table width="924" border="1" align="center"> <tr> <td width="509"><label> <div align="center"> <input name="Id" type="hidden" id="Id" value="<?=$result['id']?>" /> <input type="submit" name="Submit" value="บันทึก"> </div> </label></td> <td width="399"><label> <div align="center"> <input type="submit" name="Submit2" value="ยกเลิก"> </div> </label></td> </tr> </table> <p> </p> <p> </p> <? } ?> </form>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
