PDO.如何将连接放在外部文件中 [英] PDO. How to put the connection in an external file

问题描述

如果我想将连接放在一个外部文件中，那么这段代码的哪一部分应该在该外部文件中?

If I want to put the connection in an external file, what part of this code should be in that external file?

$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "podcast";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql = "UPDATE bookmarks
            SET podcast=122, text='some text'
            WHERE id = 152";

    $stmt = $conn->prepare($sql);
    $stmt->execute();
    echo $stmt->rowCount() . " records UPDATED successfully";
}

catch(PDOException $e){
    echo $sql . "<br>" . $e->getMessage();
}

$conn = null;

推荐答案

此部分将放入外部文件，例如connection.php

This part will go in external file e.g connection.php

<?php
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "podcast";
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
?>

然后您的代码将如下所示

and then your code will look like

require("connection.php");

try {

    $sql = "UPDATE bookmarks
            SET podcast=122, text='some text'
            WHERE id = 152";

    $stmt = $conn->prepare($sql);
    $stmt->execute();
    echo $stmt->rowCount() . " records UPDATED successfully";
}

catch(PDOException $e){
    echo $sql . "<br>" . $e->getMessage();
}

$conn = null;

这篇关于PDO.如何将连接放在外部文件中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！