<?php require_once 'connectdb.php'; $qmanage = "SELECT * FROM machine_functional LEFT JOIN machine_tmec ON machine_functional.machine_id=machine_tmec.machine_id " . "LEFT JOIN machine_equipment ON machine_functional.equip_id=machine_equipment.equip_id WHERE func_equiptype='Drypump'ORDER BY machine_tmec.machine_id"; //$qmanage = "SELECT * FROM machine_tmec LEFT JOIN pump_status ON machine_tmec.machine_id=pump_status.machine_id" // . " RIGHT JOIN machine_functional ON pump_status.func_id=machine_functional.func_id" // . " RIGHT JOIN machine_equipment ON pump_status.equip_id=machine_equipment.equip_id WHERE func_equiptype='Drypump'AND equip_status=1 ORDER BY machine_tmec.machine_id"; //$qmanage = "SELECT * FROM machine_functional INNER JOIN machine_tmec ON machine_functional.machine_id=machine_tmec.machine_id" // . " LEFT JOIN "; $resmanage = mysqli_query($dbcon, $qmanage); $row= mysqli_fetch_array($resmanage); ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title></title> <style> table,th,td { border: 1px solid black; border-collapse: collapse; } </style> </head> <body> <h2><center>Drypump Management</center></h2> <form action="pumpmanage_update.php" name="frmpumpmange" method="POST" target="_blank"> <!--target="iframe_target">--> <!--<iframe id="iframe_target" name="iframe_target" src="#" style="width:0;height:0;border:0px solid #fff;"></iframe>--> <table style="" align="center"> <tr> <th width="120">Machine</th> <th width="200">Function</th> <th width="240">Process Gas</th> <th width="290">Pump</th> <th width="210">Start</th> <th width="210">Stop</th> </tr> <?php while($rowmanage = mysqli_fetch_array($resmanage)){ echo "<tr>"; echo "<td><center>".$rowmanage['machine_id']." ".$rowmanage['abbr_name']."</center></td>"; echo "<td> ".$rowmanage['func_id']." ".$rowmanage['func_name']." (".$rowmanage['func_fullname'].")</td>"; echo "<td> ".$rowmanage['process_gas']." ".$rowmanage['equip_id']."</td>"; /////////////// Select Pump //////////////////// if($rowmanage['equip_id'] == 0){ echo "<td> ".$rowmanage['func_id']; echo "<select name='equip_id_select' id='equip_id'>"; echo "<option value=''>---Select Pump---</option>"; $qequip = "SELECT * FROM machine_equipment WHERE equip_type='Drypump' AND equip_status=0"; $resequip = mysqli_query($dbcon, $qequip); while($rowequip = mysqli_fetch_array($resequip)){ echo "<option value=".$rowequip['equip_id'].">".$rowequip['brand']." ".$rowequip['model']." SN:".$rowequip['Serial_no']."</option>"; } echo "</select> "; //echo "<input type='hidden' name='func_id_select' value='$rowmanage[func_id]'>"; echo "<input style='background-color:lightgreen; width:55px; height:23px' name='submit1' type='submit' id='submit1' value='OK'>"; echo "</td>"; }else{ echo "<td> ".$rowmanage['brand']." ".$rowmanage['model']." SN:".$rowmanage['Serial_no']."</td>"; } /////////////// Start date ////////////////////// if($rowmanage['equip_id'] == 0){ echo "<td><center>-</center></td>"; }elseif($rowmanage['start_used'] == '0000-00-00' AND $rowmanage['equip_id'] != 0){ echo "<td><center>".$rowmanage['func_id']."<input name='start_used' type='date' id='start_used'> "; //echo "<input type='hidden' name='func_id_start' value='$rowmanage[func_id]'>"; //echo "<input type='hidden' name='equip_id_select' value='$rowmanage[equip_id]'>"; echo "<input style='background-color:lightgreen; width:55px; height:23px' name='submit2' type='submit' id='submit2' value='Start')></center></td>"; }else{ echo "<td><center>".$rowmanage['func_id']."".$rowmanage['start_used']."</center></td>"; } /////////////// Stop date ////////////////////// if($rowmanage['start_used'] == ''){ echo "<td><center>-".$rowmanage['func_id']."</center></td>"; }else{ echo "<td><center>".$rowmanage['func_id']."<input name='stop_used' type='date' id='stop_used'> "; //echo "<input type='hidden' name='func_id_stop' value='$rowmanage[func_id]'>"; echo "<input style='background-color:lightgreen; width:55px; height:23px' name='submit3' type='submit' id='submit3' value='Stop')></center></td>"; } echo "</tr>"; } ?> </table> </form> </body> </html>
<?php require_once 'connectdb.php'; $manage_func_id_select = $_POST['func_id_select']; $manage_func_id_start = $_POST['func_id_start']; $manage_func_id_stop = $_POST['func_id_stop]']; $manage_equip_id = $_POST['equip_id_select']; $manage_start_date = $_POST['start_date_select']; $manage_stop_date = $_POST['stop_date_select']; $manage_select = $_POST['select']; echo "func_id_select =".$manage_func_id_select."<br>"; echo "func_id_start =".$manage_func_id_start."<br>"; echo "func_id_stop =".$manage_func_id_stop."<br>"; echo "equip_id =".$manage_equip_id."<br>"; echo "start_date =".$manage_start_date."<br>"; echo "stop_date =".$manage_stop_date."<br>"; echo "select =".$manage_select."<br>";
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
ทำได้แล้วครับ
