网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索
php吧 关注：280,717贴子：1,320,616
  • 2回复贴，共1页

新手求大神 教我CHECKBOX插入数据库

<form method="post" action="cha.php">
<P>请选择预约时间:<input type="date" name="time" value=""/>时间</P>
<p>内科:</p>
<label><input type="checkbox" name="keshi[]" value="神经内科" />神经内科</label>
<label><input type="checkbox" name="keshi[]" value="呼吸内科" />呼吸内科</label>
<label><input type="checkbox" name="keshi[]" value="小儿科" />小儿科</label>
<label><input type="checkbox" name="keshi[]" value="中医科" />中医科</label>
<label><input type="checkbox" name="keshi[]" value="血液内科" />血液内科</label>
<label><input type="checkbox" name="keshi[]" value="消化内科" />消化内科</label>
<label><input type="checkbox" name="keshi[]" value="心血内科" />心血内科</label>
<p>外科:</p>
<label><input type="checkbox" name="keshi[]" value="普外科" />普外科</label>
<label><input type="checkbox" name="keshi[]" value="骨科" />骨科</label>
<label><input type="checkbox" name="keshi[]" value="神经外科" />神经外科</label>
<label><input type="checkbox" name="keshi[]" value="泌尿外科" />泌尿外科</label>
<label><input type="checkbox" name="keshi[]" value="眼科" />眼科</label>
<label><input type="checkbox" name="keshi[]" value="烧伤整形科" />烧伤整形科</label>
<label><input type="checkbox" name="keshi[]" value="产科" />产科</label>
<input style="width:50px; height:30px; margin-left:20%; margin-top:10%;" type="submit" value="提交" />
<input style="width:50px; height:30px; margin-left:30%; margin-top:10%;" type="reset" value="重置" />
</form>
</div>
</div>


<?php
$host='127.1.1.1';
$user_name='root';
$pass_word='123';
$conn=mysql_connect($host,$user_name,$pass_word);
mysql_select_db('test',$conn) or die ("失败");
mysql_query("set names utf8");
$time=$_POST["time"];
$array = $_POST["keshi"];
$keshi =implode(',',$array);
session_start();
$username=$_SESSION['username'];
if (empty($time)||empty($keshi)){
echo "<script>alert('信息不能为空!');history.back() </script>";
echo "<script>location.href='zhuce.php';</script>";
exit;}
//if ($password!=$password2){
// echo "<script>alert('两次密码不一致!');history.back() </script>";
// echo "<script>location.href='zhuce.php';</script>";
//exit;
//}
$sql2 = mysql_query("select * from q2 where keshi='$keshi' and username='$username'");
$result2=mysql_num_rows($sql2);
if($result2 > 0)
{
echo "<script>alert('你已经预约过了~');history.back() </script>";
exit;
}
$sql="insert into q2(username,time,keshi)
values('$username','$time','$keshi')";
$result = @mysql_query($sql);
if($result)
{
echo "<script>alert('恭喜您，注册成功!'); </script>";
echo "<script>location.href='denglu.php';</script>";
exit;
}
?>


怎么改？


扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频！
  • 2回复贴，共1页
分享到: