<body><div data-role="page" id="page1"> <a href="index.php">หน้าแรก</a> <a href="SearchAndEdit.php">ย้อนกลับ </a> <p> </p> <form name="form" method="post" action="formsearchcontinues2.php"> <div data-theme="a" data-role="header" align="center"> <h1>Inpection Record </h1> </div> <fieldset><legend>ค้นหาเลข P/O</legend> <p>กรุณาใส่เลข P/O <label for="txtPO"></label> <input type="text" name="txtPO" id="txtPO" value="<?=$_POST['txtPO']?>"> <input type="submit" name="btnS" id="btnS" style=" width:120px; height:30px; font-size:16px " value="ค้นหา"> </p> <p> </p> </fieldset> <table width="200%" border="1"> <tr> <th scope="row">PO</th> <td>เลขPO</td> </tr> <? $sql_show = "select * from standardvalue,inspection_rec"; if(!isset ($_POST['btnS'])) { echo"กรุณาใส่ชื่อในการค้นหา"; exit(); } else { { $txtPO = $_POST['txtPO']; $sql_show.=" where Po like '$txtPO%' and Po = '$edit_id' "; $sql_show.=" LIMIT 0,20 "; } $result_show = mysql_query($sql_show) or die(mysql_error()); while($row_show = mysql_fetch_array($result_show)) { ?> <tr> <th scope="row"><div align="center"><?=$row_show['Po']?></a></div></th> <td><a href="aa.php?edit_id=<?=$row_show['Po']?>"><?=$row_show['Po']?></a></td> </tr> </table> </tr> </form> <p> <? } ?> </table> <? mysql_close(); ?> <? } ?> </p> <p><a href="logout.php"> ออกจากระบบ</a></p> </body> </html>
<form action="codeinsertSpec1.php" name="frmin" method="post" > <? include ('conn.php') ; $id_path=$edit_id; // คำสั่ง SQL และสั่งให้ทำงาน $str = "select * from inspection_rec,standardvalue where inspection_rec.Po = standardvalue.Po and inspection_rec. Po='$id_path'"; //ตรงนี้จะเป็นข้อกำหนดให้ดึงข้อมูลตามที่เรากำหนด $objQuery = mysql_query($str); echo $str ; while($objResult = mysql_fetch_array($objQuery)) { ?> <p><a href="index.php">หน้าแรก</a> <a href="SearchAndEdit.php">ย้อนกลับ </a></p> <div data-theme="a" data-role="header" align="center"> <h1> Inpection Record </h1> </div> <table width="97%" height="228" border="1"> <tr> <td width="8%" rowspan="2" bgcolor="#6666FF">หัวข้อ</td> <td width="8%" rowspan="2" bgcolor="#6666FF"><p>ความดัน</p> <p>ลม</p></td> <td width="7%" rowspan="2" bgcolor="#6666FF">น้ำหนัก</td> <td colspan="4" bgcolor="#6666FF">เส้นรอบวง</td> <td width="19%" rowspan="2" bgcolor="#6666FF"><p align="left">รูปทรงโดยโมลด์</p></td> <td width="14%" rowspan="2" bgcolor="#6666FF"><p>รูปทรงโดยห่วง</p></td> <td width="28%" rowspan="2" bgcolor="#99FF99">สภาพโดยทั่วไป</td> </tr> <tr> <td width="3%" height="39"><label for="textfield">a</label></td> <td width="3%"><label for="txtb">b</label></td> <td width="3%"><label for="txtc">c</label></td> <td width="7%">diff</td> </tr> <tr> <td height="32" bgcolor="#99FFCC">STD.</td> <? $id_path=$edit_id; $str = "select * from standardvalue,inspection_rec where inspection_rec.Po = standardvalue.Po and inspection_rec. Po='$id_path'"; $objQuery = mysql_query($str); while($objResult = mysql_fetch_array($objQuery)) { ?> <td><div align="center"><?=$objResult["AirPressure"]?></div></td> <td><div align="center"><?=$objResult["Weight"]?></div></td> <td colspan="4"><div align="center"><?=$objResult["Moldring"]?></div></td> <td> </td> <td> </td> <td> </td> </tr> <? }?> <tr> <td height="90" bgcolor="#009933"><input type="submit" style="width:50px; height:30px"" name="btnsubmit" id="btnsubmit" value="บันทึก "> <? if($_POST["btnsubmit"]){ include ('codeinsertSpec1.php'); } ?></td> <td bgcolor="#CCCCFF"><label for="txtairpess"></label> <input type="text" name="txtairpess" id="txtairpess" size="4" value="" maxlength="5" onKeyPress="return chkNumber4(this)"></td> <td bgcolor="#CCCCFF"><label for="txtweightball"></label> <input type="text" name="txtweightball" id="txtweightball" size="3" onKeyPress="return chkNumber5(this)"></td> <td bgcolor="#CCCCFF"><input type="text" name="txta" id="txta" size="3" value="" class="cal" OnKeyPress="return chkNumber1 (this)"></td> <td bgcolor="#CCCCFF"><input type="text" name="txtb" id="txtb" size="3" value="" class="cal" onKeyPress="return chkNumber2 (this)"></td> <td bgcolor="#CCCCFF"><input type="text" name="txtc" id="txtc" size="3" value="" class="cal" onKeyPress="return chkNumber3 (this)"></td> <td bgcolor="#CCCCFF"><input type="text" name="txtdiff" id="txtdiff" size="3" value=""></td> <td bgcolor="#CCCCFF"><p> <? $id_path=$edit_id; $str = "select * from standardvalue,inspection_rec where inspection_rec.Po = standardvalue.Po and inspection_rec. Po='$id_path'"; $objQuery = mysql_query($str); while($objResult = mysql_fetch_array($objQuery)) { ?> <label> <input type="radio" name="Rdomold" value="<?=$objResult["MoldS"]?>" id="RadioGroup1_0"> <?=$objResult["MoldS"]?> </label> <br> <label> <input type="radio" name="Rdomold" value="<?=$objResult["MoldM"]?>"id="RadioGroup1_1"> <?=$objResult["MoldM"]?> </label> <br> <label> <input type="radio" name="Rdomold" value="<?=$objResult["MoldL"]?>" id="RadioGroup1_2"> <?=$objResult["MoldL"]?> </label> </p></td> <td bgcolor="#CCCCFF"><label for="select"></label> <select name="selectring2" id="selectring2"> <option value="ปกติ">ปกติ </option> <option value="Big">Big</option> <option value="Small">Small</option> </select></td> <td bgcolor="#CCCCFF"><select name="selectcondition2" id="selectcondition2"> <option value="ปกติ">ปกติ </option> <option value="NG(โลโก้ไม่ตรงตามArtwork)">NG(โลโก้ไม่ตรงตามArtwork)" </option> <option value="NG(การติดบอลห่างเกินไป)">NG(การติดบอลห่างเกินไป)" </option> <option value="NG(ไม่สะอาด)">NG(ไม่สะอาด)" </option> <option value="NG(ไม่สะอาด)">NG(หนังขาด)" </option> </select></td> </tr> </table> <table width="200" border="1"> <tr id="tr"> <td width="7%">หัวข้อ</td> <td width="8%">ความดันลม</td> <td width="8%">น้ำหนัก</td> <td width="8%">a</td> <td width="9%">b</td> <td width="10%">c</td> <td width="8%">diff</td> <td width="11%"><p>รูปทรงโดยโมลด์</p></td> <td width="10%">รูปทรงโดยห่วง</td> <td width="21%">สภาพโดยทั่วไป</td> </tr> <? $id_path=$edit_id; $str = "select * from inspection_rec,standardvalue where inspection_rec.Po = standardvalue.Po and inspection_rec. Po='$id_path' "; echo $strSQL; $objQuery = mysql_query($str);?> <? $i=0; while($objResult = mysql_fetch_array($objQuery)) { $i++; if($i%2==0) { $bg = "#FFCC99"; } else { $bg = "#CCFF99"; } ?> <tr bgcolor="<?=$bg;?>"> <td><?=$objResult['ValueID']?></td> <td><?=$objResult['Pressureball']?></td> <td><?=$objResult['Weightball']?></td> <td><?=$objResult['Pera']?></td> <td><?=$objResult['PerB']?></td> <td><?=$objResult['PerC']?></td> <td><?=$objResult['Diff']?></td> <td><?=$objResult['MoldShape']?></td> <td><?=$objResult['MoldRing']?></td> <td><?=$objResult['Conditionball']?></td> </tr> <? } ?> <? } ?> <? } ?> </table>
$str = "select * from standardvalue,inspection_rec where inspection_rec.Po = standardvalue.Po and inspection_rec. Po='$id_path'"; $objQuery = mysql_query($str);
$objQuery = mysql_query($str);
<form action="codeinsertSpec1.php" name="frmin" method="post" > <? include ('conn.php') ; $id_path=$edit_id; // คำสั่ง SQL และสั่งให้ทำงาน $str = "select * from inspection_rec,standardvalue where inspection_rec.Po = standardvalue.Po and inspection_rec. Po='$id_path'"; //ตรงนี้จะเป็นข้อกำหนดให้ดึงข้อมูลตามที่เรากำหนด $objQuery = mysql_query($str); echo $str ; while($objResult = mysql_fetch_array($objQuery)) { ?> <p><a href="index.php">หน้าแรก</a> <a href="SearchAndEdit.php">ย้อนกลับ </a></p> <div data-theme="a" data-role="header" align="center"> <h1> Inpection Record </h1> </div> <table width="97%" height="228" border="1"> <tr> <td width="8%" rowspan="2" bgcolor="#6666FF">หัวข้อ</td> <td width="8%" rowspan="2" bgcolor="#6666FF"><p>ความดัน</p> <p>ลม</p></td> <td width="7%" rowspan="2" bgcolor="#6666FF">น้ำหนัก</td> <td colspan="4" bgcolor="#6666FF">เส้นรอบวง</td> <td width="19%" rowspan="2" bgcolor="#6666FF"><p align="left">รูปทรงโดยโมลด์</p></td> <td width="14%" rowspan="2" bgcolor="#6666FF"><p>รูปทรงโดยห่วง</p></td> <td width="28%" rowspan="2" bgcolor="#99FF99">สภาพโดยทั่วไป</td> </tr> <tr> <td width="3%" height="39"><label for="textfield">a</label></td> <td width="3%"><label for="txtb">b</label></td> <td width="3%"><label for="txtc">c</label></td> <td width="7%">diff</td> </tr> <tr> <td height="32" bgcolor="#99FFCC">STD.</td> <? $id_path=$edit_id; $str2 = "select * from standardvalue,inspection_rec where inspection_rec.Po = standardvalue.Po and inspection_rec. Po='$id_path'"; $objQuery2 = mysql_query($str2); while($objResult2 = mysql_fetch_array($objQuery2)) { ?> <td><div align="center"><?=$objResult2["AirPressure"]?></div></td> <td><div align="center"><?=$objResult2["Weight"]?></div></td> <td colspan="4"><div align="center"><?=$objResult2["Moldring"]?></div></td> <td> </td> <td> </td> <td> </td> </tr> <? }?> <tr> <td height="90" bgcolor="#009933"><input type="submit" style="width:50px; height:30px"" name="btnsubmit" id="btnsubmit" value="บันทึก "> <? if($_POST["btnsubmit"]){ include ('codeinsertSpec1.php'); } ?></td> <td bgcolor="#CCCCFF"><label for="txtairpess"></label> <input type="text" name="txtairpess" id="txtairpess" size="4" value="" maxlength="5" onKeyPress="return chkNumber4(this)"></td> <td bgcolor="#CCCCFF"><label for="txtweightball"></label> <input type="text" name="txtweightball" id="txtweightball" size="3" onKeyPress="return chkNumber5(this)"></td> <td bgcolor="#CCCCFF"><input type="text" name="txta" id="txta" size="3" value="" class="cal" OnKeyPress="return chkNumber1 (this)"></td> <td bgcolor="#CCCCFF"><input type="text" name="txtb" id="txtb" size="3" value="" class="cal" onKeyPress="return chkNumber2 (this)"></td> <td bgcolor="#CCCCFF"><input type="text" name="txtc" id="txtc" size="3" value="" class="cal" onKeyPress="return chkNumber3 (this)"></td> <td bgcolor="#CCCCFF"><input type="text" name="txtdiff" id="txtdiff" size="3" value=""></td> <td bgcolor="#CCCCFF"><p> <? $id_path=$edit_id; $str3 = "select * from standardvalue,inspection_rec where inspection_rec.Po = standardvalue.Po and inspection_rec. Po='$id_path'"; $objQuery3 = mysql_query($str3); while($objResult3 = mysql_fetch_array($objQuery3)) { ?> <label> <input type="radio" name="Rdomold" value="<?=$objResult3["MoldS"]?>" id="RadioGroup1_0"> <?=$objResult3["MoldS"]?> </label> <br> <label> <input type="radio" name="Rdomold" value="<?=$objResult3["MoldM"]?>"id="RadioGroup1_1"> <?=$objResult3["MoldM"]?> </label> <br> <label> <input type="radio" name="Rdomold" value="<?=$objResult3["MoldL"]?>" id="RadioGroup1_2"> <?=$objResult3["MoldL"]?> </label> </p></td> <td bgcolor="#CCCCFF"><label for="select"></label> <select name="selectring2" id="selectring2"> <option value="ปกติ">ปกติ </option> <option value="Big">Big</option> <option value="Small">Small</option> </select></td> <td bgcolor="#CCCCFF"><select name="selectcondition2" id="selectcondition2"> <option value="ปกติ">ปกติ </option> <option value="NG(โลโก้ไม่ตรงตามArtwork)">NG(โลโก้ไม่ตรงตามArtwork)" </option> <option value="NG(การติดบอลห่างเกินไป)">NG(การติดบอลห่างเกินไป)" </option> <option value="NG(ไม่สะอาด)">NG(ไม่สะอาด)" </option> <option value="NG(ไม่สะอาด)">NG(หนังขาด)" </option> </select></td> </tr> </table> <table width="200" border="1"> <tr id="tr"> <td width="7%">หัวข้อ</td> <td width="8%">ความดันลม</td> <td width="8%">น้ำหนัก</td> <td width="8%">a</td> <td width="9%">b</td> <td width="10%">c</td> <td width="8%">diff</td> <td width="11%"><p>รูปทรงโดยโมลด์</p></td> <td width="10%">รูปทรงโดยห่วง</td> <td width="21%">สภาพโดยทั่วไป</td> </tr> <? $id_path=$edit_id; $str4 = "select * from inspection_rec,standardvalue where inspection_rec.Po = standardvalue.Po and inspection_rec. Po='$id_path' "; $objQuery4 = mysql_query($str4);?> <? $i=0; while($objResult4 = mysql_fetch_array($objQuery4)) { $i++; if($i%2==0) { $bg = "#FFCC99"; } else { $bg = "#CCFF99"; } ?> <tr bgcolor="<?=$bg;?>"> <td><?=$objResult4['ValueID']?></td> <td><?=$objResult4['Pressureball']?></td> <td><?=$objResult4['Weightball']?></td> <td><?=$objResult4['Pera']?></td> <td><?=$objResult4['PerB']?></td> <td><?=$objResult4['PerC']?></td> <td><?=$objResult4['Diff']?></td> <td><?=$objResult4['MoldShape']?></td> <td><?=$objResult4['MoldRing']?></td> <td><?=$objResult4['Conditionball']?></td> </tr> <? } ?> <? } ?> <? } ?> </table>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
