代码之家 › 专栏 › 技术社区 › Nrc

PDO。如何将连接放入外部文件

pdo php

Nrc · 技术社区 · 10 年前

如果我想把连接放在一个外部文件中,这个代码的什么部分应该放在这个外部文件中?

$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;

2 回复 | 直到 10 年前

Shehary 10 年前

这部分将放在外部文件中,例如 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);
?>

然后你的代码看起来像

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;

user4628565 user4628565 10 年前

$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);

}

直到该部分可以转到外部文件,并且可以在需要时用于打开连接。

推荐文章

Karlo · PHP Sqlite PDO最新版本

7 月前

Paul Slater · PHP PDO fetchObject返回2个实例

9 月前