错误消息“mysql\u connect（）：mysql扩展已弃用，将在将来的第6行中删除。”我如何修复它？[副本]

Question

这是我的密码。我怎样才能修好它？错误消息如下所示

"已弃用：mysql_connect（）：mysql扩展已弃用，将来将被删除：在第6行的C：\wamp\www\test12345\db.php中改用mysqli或PDO"

如何创建没有错误的登录页面？我正在尝试创建一个具有安全登录会话？的网站？。我做得对吗？

db.php

<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "web";
$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Can't connect to database");
mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");

login.php

<?php
include("db.php");
session_start();
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // username and password sent from Form
    $username = mysql_real_escape_string($_POST['username']);
    $password = mysql_real_escape_string($_POST['password']);
    $password = md5($password); // Encrypted Password
    $sql = "SELECT id FROM admin WHERE username='$username' and passcode='$password'";
    $result = mysql_query($sql);
    $count = mysql_num_rows($result);

    // If result matched $username and $password, table row must be 1 row
    if ($count == 1) {
        session_register("username");
        $_SESSION['login_user'] = $username;

        header("location: welcome.php");
    } else {
        $error = "Your Login Name or Password is invalid";
    }
}
?>
<form action="login.php" method="post">
    <label>UserName :</label>
    <input type="text" name="username"/><br />
    <label>Password :</label>
    <input type="password" name="password"/><br/>
    <input type="submit" value=" Login "/><br />
</form>

Answer 1

我还没有测试过这个，但是如果你想要一个如何将它转换为PDO的例子

<?php
    //really basic connection wrapper class
    class DB{
        protected $_conn;

        public function __construct(){
            $mysql_hostname = "localhost";
            $mysql_user = "root";
            $mysql_password = "";
            $mysql_database = "web";
            //http://php.net/manual/en/pdo.construct.php
            $this->_conn = new PDO(
                'mysql:host=' . $mysql_hostname . ';' . 'dbname=' . $mysql_database,
                $mysql_user,
                $mysql_password
            );
        }

        public function getConn(){
            return $this->_conn;
        }
        /*
        $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Can't connect to database");
        mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");
        */
    }
?>

//any space or new lines here ( before the open PHP tag ) will prevent the redirect
<?php
ini_set('display_errors', 1); //turn on error reporting when developing
include("db.php");
session_start();
if($_SERVER["REQUEST_METHOD"] == "POST"){
    $DB = new DB();

    // username and password sent from Form
    $username = $_POST['username']; 
    $password = $_POST['password']; 
    $password = md5($password); // Encrypted Password - update this as others have stated
    $sql="SELECT id FROM admin WHERE username = ? and passcode = ?";
    //http://php.net/manual/en/pdo.prepare.php
    $stmt = $DB->getConn()->prepare($sql);
    //http://php.net/manual/en/pdostatement.execute.php
    $stmt->execute( array( $username, $password ) );
    //http://php.net/manual/en/pdostatement.fetchall.php
    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);

    // If result matched $username and $password, table row must be 1 row
    if(count( $results ) ){
        //session_register("username"); this is deprecated 
        $_SESSION['login_user']=$username;

        header("location: welcome.php");
        exit(); //add exit here
    }else {
        $error="Your Login Name or Password is invalid";
    }
}
?>
<form action="login.php" method="post">
<label>UserName :</label>
<input type="text" name="username"/><br />
<label>Password :</label>
<input type="password" name="password"/><br/>
<input type="submit" value=" Login "/><br />
</form>

对于重定向问题。不要使用session_register（）；如何修复session_register（）弃用的问题？