会议室预约

alert('请登录！');self.location = 'index.php?act=login';"); } $mysqli = new mysqli($mysql_host,$mysql_user,$mysql_pwd,$mysql_db); if($mysqli->connect_errno){ //连接成功errno应该为0 die('Connect Error:'.$mysqli->connect_error); } $mysqli->set_charset('utf8'); if(@$_POST['submit'] == '提交'){ // exit(""); $department = $_POST['department']; $person = $_POST['person']; $tel_s = $_POST['tel']; //$email = $_POST['email']; $name = $_POST['name']; $room = $_POST['room']; $property = $_POST['property']; $date = $_POST['date']; //$reason = $_POST['reason']; $time = $_POST['start_hour']." - ".$_POST['end_hour']; $apparatus = ''; foreach($_POST['apparatus'] as $val){ if($apparatus == true){ $sign = ','; }else{ $sign = ''; } $apparatus = $apparatus.$sign.$val; } //$remark = $_POST['remark']; $sql = "insert into `boardroom` (`department`,`room`,`person`,`tel`,`name`,`property`,`date`,`time`,`apparatus`,`ybuid`)values(?,?,?,?,?,?,?,?,?,?)"; $mysqli_stmt=$mysqli->prepare($sql); //第一个参数表明变量类型，有i(int),d(double),s(string),b(blob) $mysqli_stmt->bind_param('ssssssssss',$department,$room,$person,$tel_s,$name,$property,$date,$time,$apparatus,$postArr['visit_user']['userid']); //执行预处理语句 if($mysqli_stmt->execute()){ $submail=new MESSAGEXsend($message_configs); $submail->setTo($tel); $submail->SetProject('kdkxz1'); $submail->AddVar('tissue',$department); $submail->AddVar('classroom',$room); $submail->AddVar('name',$person); $submail->AddVar('id',$mysqli->insert_id); $submail->AddVar('time',$date.' '.$time.'点'); $submail->AddVar('tel',$tel); $submail->AddVar('reason',$name); $xsend=$submail->xsend(); echo ""; // print_r($xsend); }else{ echo $mysqli_stmt->error; } //print_r($_POST); } ?> 会议室预约