我有一个包含我的连接详细信息的包含文件。我正试图连接到数据库,但我得到了这个错误:
<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);
}
我在这里做错了什么?
- 删除所有全局声明。数据库连接参数不需要全局声明
- 将所有数据库连接代码放在一个文件中。将连接字符串从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文件。