php - 数据库连接问题

Question

你好，任何人都可以帮助我连接数据库，我使用 xampp，phpmyadmin，当我打开浏览器时，DBConnection.class.php 它显示为空白并且数据库不起作用，谢谢

<?php 
    class DBConnection{
        public static function DbConn(){
            $servername = "mysql:host=localhost;dbname=test";
            $username = "root";
            $password = "";
        try{
            $conn = new PDO($servername, $username, $password);
            return $conn;
            echo"Connection succesful :)";
        }
        catch (PDOException $e) {
            echo "Connection failed :( :" . $e->getMessage();
        }
        }
    }
?>

标签： phpmysqlpdoxampp

Answer 1

修改后的代码。尝试这个：

class DBConnection{
    public static function DbConn(){
        $servername = "mysql:host=localhost;dbname=test";
        $username = "root";
        $password = "";
    try{
        $conn = new PDO($servername, $username, $password);
        return "Connection succesfull :)";
        //return $conn;

    }
    catch (PDOException $e) {
        echo "Connection failed :( :" . $e->getMessage();
    }
    }
}

然后像这样打电话

$Connection =  new DBConnection();
print_r($Connection->DbConn());