php - 如何在php中使用conf文件

Question

我试图通过仅包含 conf.php 来避免硬编码，它将包含我将要使用的变量/值需要。

我怎样才能实现这个目标？

这是我的 conf.php 代码

<?php
mysql_connect("localhost", "tiger","tiger") or die (mysql_error ());
mysql_select_db("theaterdb") or die(mysql_error());
?>

其他PHP页面的编码如下:

$q = strtolower(trim($_GET["q"]));

try {
    $dbh = new PDO('mysql:dbname=theaterdb;host=localhost','tiger','tiger');
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

$sql = 'SELECT address FROM theater WHERE LOWER(theater_name) = :q';

$sth = $dbh->prepare($sql);
$sth->bindValue(':q', $q);
$sth->execute();

而不是这一行:

dbh = new PDO('mysql:dbname=theaterdb;host=localhost','tiger','tiger');

我想使用 conf.php 文件。我怎样才能做到这一点？

Answer 1

//在所有其他页面中包含conf.php

conf.php

<?php
    try {
        $dbh = new PDO('mysql:dbname=theaterdb;host=localhost','tiger','tiger');
    } catch (PDOException $e) {
        echo 'Connection failed: ' . $e->getMessage();
    }
?>

other_page.php

<?php
    include("conf.php");

    $q = strtolower(trim($_GET["q"]));

    $sql = 'SELECT address FROM theater WHERE LOWER(theater_name) = :q';

    $sth = $dbh->prepare($sql);
    $sth->bindValue(':q', $q);
    $sth->execute();

?>