Home >Backend Development >PHP Tutorial >php与数据库相关重要有关问题求解答

php与数据库相关重要有关问题求解答

WBOY
WBOYOriginal
2016-06-13 10:23:491054browse

php与数据库相关重要问题求解答
各位前辈高人,我在login.html中点击登录后直接转向userController.php,并且不显示任何东西,我的目的是验证登录成功后直接跳到mian.html 不成功则跳到error.html中,可是不成功,请问我哪里错了,还有一个问题就是登录成功后怎么吧登录者的信息传给mian.html?谢谢了


PHP code
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> login.html    <title>用户系统登录</title>    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> 
角色 管理员 教师 学生
用户名
密码
新用户注册

PHP code
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->dbconn.class.php<?php class DBconn{        private static $db_host="localhost";        private static $db_user="root";        private static $db_password="linux";        private static $db_name="sharewebDb";        private static $connection;        static function getConn(){            $connection=new mysqli($db_host,$db_user,password,$db_name);            return $connection;        }        }?>

PHP code
<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->userModel.php<?php include("dbconn.class,php");class userModel{    function checklogin($userid,$userpwd,$useraccount){        $mysqli=DBconn::getConn();        $result='';        switch($useraccount){        case "teacher":{                $sql="select t_id,t_name,t_dep from ter_info where t_id=? and t_pwd=?";                $result=$mysqli->prepare($sql);:                $result->bind_param("ss",$user_id,$user_password);                $user_id=$userid;                $user_password=$userpwd;                $result->execute();break;                }        case "student":{                $sql="select s_id,s_name,s_dep from stu_info where s_id=? ands_pwd=?";                $result=$mysqli->prepare($sql);                $result->bind_param("ss",$user_id,$user_password);                $user_id=$userid;                $user_password=$userpwd;                $result->execute();break;                }        }        $result->bind_result($user_id,$user_name,$user_dep);        while($result->fetch()){            $userlist=array(                'user_id'=>$user_id,                'user_name'=>$user_name,                'user_dep'=>$user_dep            );                }        $result->close();        $mysqli->close();        return userlist;    }?><div class="clear">
                 
              
              
        
            </div>
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn