学生登记表 |
姓名: |
学号: |
电话: |
地址: |
if(isset($_POST['submit'])){
$errot=array();
if(empty($_POST['user_id'])){
$errot[]='学号不能为空';
}else{
$user_id=$_POST['user_id'];
}
if(empty($_POST['user_name'])){
$errot[]='名字不能为空';
}else{
$user_name=$_POST['user_name'];
}
if(empty($_POST['user_phone'])){
$errot[]='电话不能为空';
}else{
$user_phone=$_POST['user_phone'];
}
if(empty($_POST['user_address'])){
$errot[]='名字不能为空';
}else{
$user_address=$_POST['user_address'];
}
if(empty($errot)){
header('Content-Type:text/html;charset=utf-8');
//数据库的服务器类型是mysql
$dbms='mysql';
//数据库服务器主机名、端口号、选择的数据库
$host='localhost';
$port='3306';
$dbname='book';
//用户名和密码
$user='root';
$pwd=null;
$dsn="$dbms:host=$host;port=$port;dbname=$dbname";
$options=array(PDO::MYSQL_ATTR_INIT_COMMAND=>"set names utf8");
try{
//实例化PDO创建数据库服务器连接
$pdo=new PDO($dsn,$user,$pwd,$options);
$sql1='select * from user where id='.$user_id;
//判断重复数据
$rs=$pdo->query($sql1);
var_dump($rs);
if($rs){
die('此数据重复提交');
}else{
//if(isset($_post['tijao'])){
//执行SQL语句
$sql="insert into user values(null,:name,:id,:phone,:address)";
//生成预处理语
$stmt=$pdo->prepare($sql);
//$name=$_POST['user_name'];
//$id=$_POST['user_id'];
//$phone=$_POST['user_phone'];
//$address=$_POST['user_address'];
$stmt->bindParam(":name",$user_name);
$stmt->bindParam(":id",$user_id);
$stmt->bindParam(":phone",$user_phone);
$stmt->bindParam(":address",$user_address);
if($stmt->execute()){
echo "成功..";
}else{
echo "失败";
}
}
}catch(PDOExcption $e){
echo $e->getMessage().'
';
}
}else{
var_dump($errot);
die("未填完!");
}
}
?>