我如何重新组织我的PHP代码以包含单独的数据库信息文件

Question

Can any of you guys help me to reorganize this code? I'll try to explain the problem below.

I have a db_connection.php wich includes the following (just my db info and don't worry, i am just using it locally):

<?php
try {
    $db = new PDO('mysql:host=localhost;dbname=webappeind;charset=utf8','root','');
}
catch(PDOException $e) {
    echo $e->getMessage();
}
?>

But the problem is i have the following file that also includes my db info, but i do not know how to reorganize my code to get it working with my separate php file.

<?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "webappeind";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    $sql = "SELECT * FROM zoekopdrachten ORDER BY titel DESC LIMIT 3";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        // output gegevens van elke rij
        while($row = $result->fetch_assoc()) {
            echo "<div class='recenttoegevoegd'>"."<a href='#'>".$row["titel"]."</a>"."</div>";
        }
    } else {
        echo "0 resultaten";
    }
?>

Answer 1

You can put the connection information in a separate file called, say, conn.php where you mention the code related to database opening, including credentials. Then, in the calling file, say putdata.php, you use the "require" or "require_once" command to include that conn.php. Let the conn.php file return a connection. Somewhat like this :

<?php
function GetMyConn() {
    $server_name = "localhost";
    $db_name = "db_name_goes_here";
    $db_user = "user_name_goes_here";
    $db_pass = "password_goes_here_muahhhaa";
    $db_full_addr = "mysql:host=" . $server_name . ";" . "dbname=" . $db_name;

    $MyConn = new PDO($db_full_addr, $db_user, $db_pass);
    $MyConn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);   
    return $MyConn;
}
?>

In the calling file, you would say, something like :

require_once "GetConn.php";

$MyConnHere = GetMyConn();
$SqlHere = "Sql Statemetn goes here...."
$SqlHere2 = $MyConnHere->prepare($SqlHere);
$SqlHere2->execute();

Also, I suggest you can download the source code of some open source PHP application, such as mantissa, and see how they have organized their code files, folders and settings.