PHP-登录页面

链接数据库：
$conn=new mysqli('127.0.0.1','root','root','ccc');


数据库语句
$sql="insert into admin (user,pasd)values ('admin','".md5(123456)."')";

数据库操作
 $conn->query($sql);

if($_POST){
    $use=trim($_POST['user']);
    $pass=md5($_POST['pasd']);
    $conn=new mysqli('127.0.0.1','root','root','ccc');
    $sql="select * from admin where user='$use' and pasd='$pass'";
    $res=$conn->query($sql);
    if($res->num_rows>0){
        setcookie('admin',1);
        header('location:index.php');
    }else{
        echo '<script>alert("用户名或者密码错误")</script>';
    };

}