在php中包含显示错误的文件


Include file in php showing error

我有一个包含我的连接详细信息的包含文件。我正试图连接到数据库,但我得到了这个错误:

<b>Notice</b>:  Undefined variable: servername in <b>C:'xampp'htdocs'aditya'register.php</b> on line <b>5</b><br />
<b>Notice</b>:  Undefined variable: database in <b>C:'xampp'htdocs'aditya'register.php</b> on line <b>5</b><br />
<b>Notice</b>:  Undefined variable: username in <b>C:'xampp'htdocs'aditya'register.php</b> on line <b>5</b><br />
<b>Notice</b>:  Undefined variable: password in <b>C:'xampp'htdocs'aditya'register.php</b> on line <b>

db_info.php

 <?
    global $servername = "localhost";
    global $username="root";
    global $password="******";
    global $database="test";
    ?>

register.php

 <?php
require ('db_info.php');
try {
    $conn = new PDO("mysql:host=$servername;dbname=$database", $username, $password);
    }

我在这里做错了什么?

  1. 删除所有全局声明。数据库连接参数不需要全局声明
  2. 将所有数据库连接代码放在一个文件中。将连接字符串从register.php移到db_info.php中

所以你的db_info.php应该是这样的:

$servername = "localhost";
$username="root";
$password="******";
$database="test";
try {
    $conn = new PDO("mysql:host=$servername;dbname=$database", $username, $password);
    }catch(PDOException $pe){
//handle exception
}

在需要数据库连接的其他文件中包括db_info.php文件。