ต้องการจะบันทึกข้อมูลแบบมีหลายบรรทัด และมีปุ่มเลือก radio ด้วย ลงในตารางครับ
รบกวนพี่ ๆ และขอขอบคุณล่วงหน้ามา ณ ที่นี้เลยครับCode (PHP) <body>
<form name="frm" id="frm" method="POST" action="surveySave.php">
<table width="46%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="15%" height="36" align="center">software</td>
<td width="41%" align="center">yes/no</td>
<td width="44%" align="center">remark</td>
</tr>
<tr>
<td><input name="txtName<?php echo $i;?>" type="text" size="15" value="MS-Office"></td>
<td align="center"><input type="radio" name="radiYN<?php echo $i;?>" id="radi-office" value="yes">yes <input type="radio" name="radiYN<?php echo $i;?>" id="radi-office" value="no">no</td>
<td><input name="txtRmk<?php echo $i;?>" type="text" id="rmk-office" size="50"></td>
</tr>
<tr>
<td><input name="txtName<?php echo $i;?>" type="text" size="15" value="Photoshop" ></td>
<td align="center"><input type="radio" name="radiYN<?php echo $i;?>" id="radi-Photoshop" value="yes">yes <input type="radio" name="radiYN<?php echo $i;?>" id="radi-Photoshop" value="no">no</td>
<td><input name="txtRmk<?php echo $i;?>" type="text" id="rmk-Photoshop" size="50"></td>
</tr>
<tr>
<td><input name="txtName<?php echo $i;?>r" type="text" size="15" value="Illustrator"></td>
<td align="center"><input type="radio" name="radiYN<?php echo $i;?>" id="radi-Illustrator" value="yes">yes <input type="radio" name="radiYN<?php echo $i;?>" id="radi-Illustrator" value="no">no</td>
<td><input name="txtRmk<?php echo $i;?>" type="text" id="rmk-Illustrator" size="50"></td>
</tr>
<tr>
<td><input name="txtName<?php echo $i;?>r" type="text" size="15" value="Dreamweaver"></td>
<td align="center"><input type="radio" name="radiYN<?php echo $i;?>" id="radi-Dreamweaver" value="yes">yes <input type="radio" name="radiYN<?php echo $i;?>" id="radi-Dreamweaver" value="no">no</td>
<td><input name="txtRmk<?php echo $i;?>" type="text" id="rmk-Dreamweaver" size="50"></td>
</tr>
<tr>
<td colspan="2"> </td>
<td><input type="submit" name="button" id="button" value="Submit"></td>
</tr>
</table>
</form>
</body>
</html>
Code (PHP) <?php
$hostName = "localhost";
$usrDB = "root";
$pwdDB = "root";
$nameDB = "db_computer";
$conDB = mysql_connect($hostName, $usrDB, $pwdDB) or die ("$SQL");
mysql_query("SET NAMES tis620", $conDB);
mysql_query("USE $nameDB");
// loop
for($i=1; $i <= $_POST["txtName"]; $i++){
if($_POST["txtName$i"] != ""){
$SQL = "INSERT INTO tbsoftware(ID, nameSft, ynSft, rmkSft) VALUES (NULL,'".$_POST["txtName$i"]."','".$_POST["radiYN$i"]."','".$_POST["txtRmk$i"]."')";
$res = mysql_query($SQL) or die ("$SQL") ;
}
}
echo $SQL;
?>
Tag PHP, HTML5
Date :
2017-07-03 12:39:46By :
pukmtecView :
1489Reply :
4
ลอง ค้นหาคีย์เวิร์ดคำว่า insert multi row
Date :
2017-07-03 13:12:58By :
Pong Thep
เรียน คุณ Pongthep
Date :
2017-07-03 13:40:40By :
pukmtec
Code (PHP) <form name="frm" id="frm" method="POST" action="surveySave.php">
<table width="46%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="15%" height="36" align="center">software</td>
<td width="41%" align="center">yes/no</td>
<td width="44%" align="center">remark</td>
</tr>
<tr>
<td><input name="txtName[]" type="text" size="15" value="MS-Office" readonly ></td>
<td align="center"><input type="radio" name="radiYN[MS-Office]" id="radi-office" value="yes">yes <input type="radio" name="radiYN[MS-Office]" id="radi-office" value="no">no</td>
<td><input name="txtRmk[]" type="text" id="rmk-office" size="50"></td>
</tr>
<tr>
<td><input name="txtName[]" type="text" size="15" value="Photoshop" readonly ></td>
<td align="center"><input type="radio" name="radiYN[Photoshop]" id="radi-Photoshop" value="yes">yes <input type="radio" name="radiYN[Photoshop]" id="radi-Photoshop" value="no">no</td>
<td><input name="txtRmk[]" type="text" id="rmk-Photoshop" size="50"></td>
</tr>
<tr>
<td><input name="txtName[]r" type="text" size="15" value="Illustrator" readonly ></td>
<td align="center"><input type="radio" name="radiYN[Illustrator]" id="radi-Illustrator" value="yes">yes <input type="radio" name="radiYN[Illustrator]" id="radi-Illustrator" value="no">no</td>
<td><input name="txtRmk[]" type="text" id="rmk-Illustrator" size="50"></td>
</tr>
<tr>
<td><input name="txtName[]r" type="text" size="15" value="Dreamweaver" readonly ></td>
<td align="center"><input type="radio" name="radiYN[Dreamweaver]" id="radi-Dreamweaver" value="yes">yes <input type="radio" name="radiYN[Dreamweaver]" id="radi-Dreamweaver" value="no">no</td>
<td><input name="txtRmk[]" type="text" id="rmk-Dreamweaver" size="50"></td>
</tr>
<tr>
<td colspan="2"> </td>
<td><input type="submit" name="button" id="button" value="Submit"></td>
</tr>
</table>
</form>
Code (PHP) foreach($_POST['txtName'] as $key=>$val){
echo 'software : '.$val;
echo '<br>';
echo 'radiYN : ';
echo (isset($_POST['radiYN'][$val]))?$_POST['radiYN'][$val]:'';
echo '<br>';
echo 'remark : '.$_POST['txtRmk'][$key];
echo '<hr>';
}
ประวัติการแก้ไข
Date :
2017-07-03 14:40:18By :
9nonameman
$IDs=$_POST['checkbox'];
Date :
2017-07-07 10:29:06By :
Bouasavanh HararRock
Server 02
Load balance : Server 02
