PHP学习（三）PHP PDO 连接MySQL

<?php
header("Content-Type:text/html;charset=utf-8");
$dbms = "mysql";
$host = "localhost";
$dbName = "phplesson";
$user = "root";
$pass = "";
$dsn = "$dbms:host=$host;dbname=$dbName";

try {
    $dbh = new PDO($dsn, $user, $pass);
    $dbh->query('set names utf8;');
    echo "连接成功！" . "<br/>";
    // 增
    $addSql="INSERT INTO `news`(`news_id`, `news_title`, `news_img`, `news_content`, `addtime`) VALUES ('花花','花花','花花','花花','2020-10-20')";
    $res=$dbh->exec($addSql);
    echo "数据库添加成功！受影响的函数".$res;

    $delSql="SELECT * FROM `news`";
    $changeSql="SELECT * FROM `news`";
    // 查
    $viewSql="SELECT * FROM `news`";
    foreach ($dbh->query($viewSql) as $row) {
        print_r($row);
    };


    // 断开连接
    $dbh = null;
} catch (PDOException $e) {
    die("ERR:" . $e . getMessage() . "<br/>");
}

?>