<th align="center"><a id="View" class="various iframe" href='FormSelect_Material3.php?ID_Pack=<?php echo $Re_SQL["ID_Pack"];'>
<? $ID_Pack = $_GET["ID_Pack"]; <<<--------- ตอนนี้ $ID_Pack มีค่าครับ ?> <form name="frmSearch" method="get" action="<?=$_SERVER['SCRIPT_NAME'];?>"> <table width="599" border="1"> <tr> <th>พิมพ์สิ <input name="txtKeyword" type="text" id="txtKeyword" value="<?=$_GET["txtKeyword"];?>"> <input type="submit" value="Search"></th> </tr> </table> </form> <? if($_GET["txtKeyword"] != "") { include('config.inc.php'); $strSQL = "SELECT * FROM material_last WHERE (Name LIKE '%".$_GET["txtKeyword"]."%' or Code LIKE '%".$_GET["txtKeyword"]."%' or Type LIKE '%".$_GET["txtKeyword"]."%' or Class LIKE '%".$_GET["txtKeyword"]."%')"; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); ?> <form name="frmMain" action="Select_Material3.php?ID_Pack=<? echo $ID_Pack ?>" method="post" OnSubmit="return onSave();"> <table> <tr> <td width="5%"> <div align="center">ลำดับ </div></td> <td width="40%"> <div align="center">Name </div></td> <td width="15%"> <div align="center">Code </div></td> <td width="20%"> <div align="center">Quantity</div></td> <td width="7%"> <div align="center">Type </div></td> <td width="7%"> <div align="center">Class </div></td> <td width="6%"> <div align="center">Add </div></td> </tr> <?php #$num = mysql_num_rows($qrr); while($rs = mysql_fetch_array($objQuery)){ echo "<tr>"; echo "<td align='center'>"; echo $rs['ID_Material']; echo "</td>"; echo "<td align='center'>"; echo $rs['Name']; echo "</td>"; echo "<td align='center'>"; echo $rs['Code']; echo "</td>"; echo "<td><input type='text' name='Quantity[".$rs['ID_Material']."]'> "; echo "</td>"; echo "<td align='center'>"; echo $rs['Type']; echo "</td>"; echo "<td align='center'>"; echo $rs['Class']; echo "</td>"; echo "<td width='28' align='center'>"; echo "<input type='checkbox' name='checkGE[".$rs['ID_Material']."]' value='".$rs['ID_Material']."'>"; echo "</td>"; } ?> <td></td> </tr> <input type="submit" name="btnDelete" value="บันทึก" /> </table> <? mysql_close($objConnect); } ?> </form>
<? include('config.inc.php'); $ID_Pack = $_GET["ID_Pack"]; foreach($_POST["checkGE"] as $key => $value){ if($value != ''){ if($_POST['Quantity'][$key] != ''){ $unit = $_POST['Quantity'][$key]; }else{ $unit = '0'; } $sql = "insert into pack_material (ID_Pack,ID_Material,Quantity) values ('$ID_Pack ','".$key."','$unit')"; ตรงนี้อ่ะครับ $query = mysql_query($sql); } } echo $_SESSION["ID_Pack"] ; mysql_close($objConnect); ?>
<? $ID_Pack = $_GET["ID_Pack"]; // ตอนนี้ $ID_Pack มีค่าครับ ?> <form name="frmSearch" method="get" action="<?=$_SERVER['SCRIPT_NAME'];?>"> <table width="599" border="1"> <tr> <th>พิมพ์สิ <input name="txtKeyword" type="text" id="txtKeyword" value="<?=$_GET["txtKeyword"];?>"> <input type="submit" value="Search"></th> </tr> </table> </form> <? if($_GET["txtKeyword"] != "") { include('config.inc.php'); $strSQL = "SELECT * FROM material_last WHERE (Name LIKE '%".$_GET["txtKeyword"]."%' or Code LIKE '%".$_GET["txtKeyword"]."%' or Type LIKE '%".$_GET["txtKeyword"]."%' or Class LIKE '%".$_GET["txtKeyword"]."%')"; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); ?> <form name="frmMain" action="Select_Material3.php" method="post" OnSubmit="return onSave();"> <table> <tr> <td width="5%"> <div align="center">ลำดับ </div></td> <td width="40%"> <div align="center">Name </div></td> <td width="15%"> <div align="center">Code </div></td> <td width="20%"> <div align="center">Quantity</div></td> <td width="7%"> <div align="center">Type </div></td> <td width="7%"> <div align="center">Class </div></td> <td width="6%"> <div align="center">Add </div></td> </tr> <?php #$num = mysql_num_rows($qrr); while($rs = mysql_fetch_array($objQuery)){ echo "<tr>"; echo "<td align='center'>"; echo $rs['ID_Material']; echo "</td>"; echo "<td align='center'>"; echo $rs['Name']; echo "</td>"; echo "<td align='center'>"; echo $rs['Code']; echo "</td>"; echo "<td><input type='text' name='Quantity[".$rs['ID_Material']."]'> "; echo "</td>"; echo "<td align='center'>"; echo $rs['Type']; echo "</td>"; echo "<td align='center'>"; echo $rs['Class']; echo "</td>"; echo "<td width='28' align='center'>"; echo "<input type='checkbox' name='checkGE[".$rs['ID_Material']."]' value='".$rs['ID_Material']."'>"; echo "</td>"; } ?> <td></td> </tr> <input type="hidden" name="ID_Pack" value="<?php echo $ID_Pack ?>" /> <!-- คุณก็เพิ่มค่า hidden เข้าไป --> <input type="submit" name="btnDelete" value="บันทึก" /> </table> <? mysql_close($objConnect); } ?> </form>
<? include('config.inc.php'); $ID_Pack = $_POST["ID_Pack"]; //+ รับเป็นค่า POST เหมือนกัน foreach($_POST["checkGE"] as $key => $value){ if($value != ''){ if($_POST['Quantity'][$key] != ''){ $unit = $_POST['Quantity'][$key]; }else{ $unit = '0'; } $sql = "insert into pack_material (ID_Pack,ID_Material,Quantity) values ('$ID_Pack ','".$key."','$unit')"; // ตรงนี้อ่ะครับ $query = mysql_query($sql); } } echo $_SESSION["ID_Pack"] ; mysql_close($objConnect); ?>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง