><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-20|16:20|17:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-21|16:20|17:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-22|16:20|17:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-23|16:20|17:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-24|16:20|17:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-25|16:20|17:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-26|16:20|17:20"></td></tr><tr><td>17:20-18:20<br></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-20|17:20|18:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-21|17:20|18:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-22|17:20|18:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-23|17:20|18:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-24|17:20|18:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-25|17:20|18:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-26|17:20|18:20"></td></tr><tr><td>18:20-19:20<br></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-20|18:20|19:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-21|18:20|19:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-22|18:20|19:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-23|18:20|19:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-24|18:20|19:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-25|18:20|19:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-26|18:20|19:20"></td></tr><tr><td>19:20-20:20<br></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-20|19:20|20:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-21|19:20|20:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-22|19:20|20:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-23|19:20|20:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-24|19:20|20:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-25|19:20|20:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-26|19:20|20:20"></td></tr><tr><td>20:20-21:20<br></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-20|20:20|21:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-21|20:20|21:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-22|20:20|21:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-23|20:20|21:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-24|20:20|21:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-25|20:20|21:20"></td><td bgcolor="#AACCFF"><input type=checkbox name=selectedSlotIds value= "3|2004-11-26|20:20|21:20"></td></tr> </table>
<br><center><input type="button" name="Finished" value="確認預訂" onclick='CheckReco(this.form,event.srcElement)'><input type=reset name=reset value=從新選擇></center> </TD>
</TR>
</TBODY>
</TABLE>
</Form>
这个是和上面的结合在一块的,由于不能粘太多,所以分二个来粘!
每一个<input type=checkbox name=selectedSlotIds value= "3|2004-11-25|20:20|21:20">都有一个value值,可以多选!,value的值分别用|来隔开,怎么样才能分别放入到下面的这张表进去呢?谢谢!!
CREATE TABLE `orderdetail` (
`Id` int(11) NOT NULL auto_increment,
`OrderId` smallint(6) default NULL,
`FacId` varchar(10) default '''''',
`OrderDate` datetime default NULL,
`OrderTimeFrom` varchar(8) default NULL,
`OrderTimeTo` varchar(8) default NULL,
`IsExtra` tinyint(20) default '0',
`Num` smallint(6) NOT NULL default '0',
`LoginId` varchar(30) NOT NULL default '',
PRIMARY KEY (`Id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;--
-- 列出以下資料庫的數據: `orderdetail`
-- INSERT INTO `orderdetail` VALUES (17, 1, 'TC A', '2004-11-19 19:37:38', '11:00:00', '12:00:00', 0, 1, 'admin');
<br><center><input type="button" name="Finished" value="確認預訂" onclick='CheckReco(this.form,event.srcElement)'><input type=reset name=reset value=從新選擇></center> </TD>
</TR>
</TBODY>
</TABLE>
</Form>
这个是和上面的结合在一块的,由于不能粘太多,所以分二个来粘!
每一个<input type=checkbox name=selectedSlotIds value= "3|2004-11-25|20:20|21:20">都有一个value值,可以多选!,value的值分别用|来隔开,怎么样才能分别放入到下面的这张表进去呢?谢谢!!
CREATE TABLE `orderdetail` (
`Id` int(11) NOT NULL auto_increment,
`OrderId` smallint(6) default NULL,
`FacId` varchar(10) default '''''',
`OrderDate` datetime default NULL,
`OrderTimeFrom` varchar(8) default NULL,
`OrderTimeTo` varchar(8) default NULL,
`IsExtra` tinyint(20) default '0',
`Num` smallint(6) NOT NULL default '0',
`LoginId` varchar(30) NOT NULL default '',
PRIMARY KEY (`Id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;--
-- 列出以下資料庫的數據: `orderdetail`
-- INSERT INTO `orderdetail` VALUES (17, 1, 'TC A', '2004-11-19 19:37:38', '11:00:00', '12:00:00', 0, 1, 'admin');
INSERT INTO `orderdetail` VALUES (17, 1, 'TC A', '2004-11-19 19:37:38', '11:00:00', '12:00:00', 0, 1, 'admin');
就像这个insert语句一样,把3放到Id,2004-11-25放到OrderDate,20:20放到OrderTimeFrom,21:20放到OrderTimeTo 谢谢
2、php接受后在数组$_POST['selectedSlotIds']中存有所有选中项的value值
3、程序写法
foreach($_POST['selectedSlotIds'] as $v) {
$r = explode("|",$v);
$sql = "INSERT INTO `orderdetail` (Id,OrderDate,OrderTimeFrom,OrderTimeTo) VALUES ('$r[0]','$r[1]','$r[2]','$r[3]')";
//插入数据库操作
}
其他字段请自行书写,只要一一对应即可
受不了,怎么把html代码夹在一起,好难看阿