รบกวนหน่อยครับ PHP insert checkbox ผู้รู้ๆๆ ลองหมดแล้ว
ขอโจทย์เครียหน่อยครับ ตอนนี้งงกับคำถาม -.- มองไม่เห็นภาพ
Date :
2013-09-16 15:27:51By :
Ex-[S]i[L]e[N]t
Code (PHP) <html>
<head>
<title>ThaiCreate.Com PHP & MySQL Tutorial</title>
</head>
<body>
<script language="JavaScript">
function onSave()
{
if(confirm('Do you want to save ?')==true)
{
return true;
}
else
{
return false;
}
}
</script>
<form name="frmMain" action="save.php" method="post" OnSubmit="return onSave();">
<?
$conn=mysql_connect("localhost","root","root");
mysql_select_db("test",$conn);
$strSQL = "SELECT * FROM Norent";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
<table width="600" border="1">
<tr>
<th width="91"> <div align="center">NoRentID </div></th>
<th width="98"> <div align="center">EmpID</div></th>
<th width="198"> <div align="center">CustID</div></th>
<th width="97"> <div align="center">RentDate</div></th>
<th width="59"> <div align="center">ReturnDate</div></th>
<th width="30"> <div align="center">Select </div></th>
</tr>
<?
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr>
<td><div align="center"><?=$objResult["NoRentID"];?></div></td>
<td><div align="center"><?=$objResult["EmpID"];?></div></td>
<td><div align="center"><?=$objResult["CustID"];?></div></td>
<td><div align="center"><?=$objResult["RentDate"];?></div></td>
<td><div align="center"><?=$objResult["ReturnDate"];?></div></td>
<td align="center"><input type="checkbox" name="chk1[]";?></td>
</tr>
<?
}
?>
</table>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>
Date :
2013-09-16 15:35:18By :
saskiller8
กด เลือก check box แล้ว กด save
Date :
2013-09-16 15:38:03By :
saskiller8
Code (PHP) <html>
<head>
<title>ThaiCreate.Com PHP & MySQL Tutorial</title>
</head>
<body>
<script language="JavaScript">
function onSave()
{
if(confirm('Do you want to save ?')==true)
{
return true;
}
else
{
return false;
}
}
</script>
<form name="frmMain" action="save.php" method="post" OnSubmit="return onSave();">
<?
$conn=mysql_connect("localhost","root","root");
mysql_select_db("test",$conn);
$strSQL = "SELECT * FROM Norent";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
<table width="600" border="1">
<tr>
<th width="91"> <div align="center">NoRentID </div></th>
<th width="98"> <div align="center">EmpID</div></th>
<th width="198"> <div align="center">CustID</div></th>
<th width="97"> <div align="center">RentDate</div></th>
<th width="59"> <div align="center">ReturnDate</div></th>
<th width="30"> <div align="center">Select </div></th>
</tr>
<?
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr>
<td><div align="center"><?=$objResult["NoRentID"];?></div></td>
<td><div align="center"><?=$objResult["EmpID"];?></div></td>
<td><div align="center"><?=$objResult["CustID"];?></div></td>
<td><div align="center"><?=$objResult["RentDate"];?></div></td>
<td><div align="center"><?=$objResult["ReturnDate"];?></div></td>
<td align="center"><input type="checkbox" name="chk[]" value="<?=$objResult["NoRentID"];?>" /></td>
</tr>
<?
}
?>
</table>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>
Code (PHP) <?
$chk=$_POST['chk'];
for($i=0;$i<count($chk);$i++){
$strSQL = "SELECT * FROM Norent WHERE NoRentID='".$chk[$i]."'";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysql_fetch_array($objQuery);
$insert="Insert INTO FROM tb_example (NoRentID,EmpID,CustID) VALUES ('".$objResult["NoRentID"]."','".$objResult["EmpID"]."','".$objResult["CustID"]."')";
$objQuery = mysql_query($insert) or die ("Error Query [".$strSQL."]");
}
?>
ประวัติการแก้ไข
Date :
2013-09-16 15:44:14By :
Ex-[S]i[L]e[N]t
Error Query [SELECT * FROM Norent WHERE NoRentID='222222']
Date :
2013-09-16 22:09:50By :
saskiller8
Error Query [SELECT * FROM Norent WHERE NoRentID=222222]
Date :
2013-09-16 22:19:40By :
saskiller8
ขอดู table structure หน่อยครับ
Date :
2013-09-16 22:42:26By :
itpcc
Server 00
Load balance : Server 00
