【末世旅行之PHP】PHP用PDO连接MySQL数据库工具类-增删改查-优快云博客

本文介绍了一个用于简化 PHP 中 PDO 数据库操作的工具类。该工具类提供了连接数据库、查询数据、更新记录等功能，并附带了测试代码示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

工具类源码：

<?php

class PDOUtil{
    private static $dbms = "mysql";
    private static $host = '127.0.0.1';
    private static $port = '3306';
    private static $username = 'root';
    private static $password = 'root';
    private static $dbname = 'worktest';
    private static $charset = 'utf8';

    public function getConn(){
        try {
//            $pdo = new PDO("mysql:host=127.0.0.1;port=3306;dbname=test", "root", "root");
//            $pdo->exec("set names 'utf8'");
            $pdo = new PDO(self::$dbms.":host=".self::$host.";port=".self::$port.";dbname=".self::$dbname,  self::$username,self::$password);
            $pdo->exec("set names ".self::$charset);

            return $pdo;
        }
        catch(PDOException $e){
            die("数据库连接失败".$e->getMessage());
        }
    }

    public function queryOneRow($sql, $params){
        $result = self::queryRows($sql,$params);

        return $result[0];
    }

    public function queryRows($sql, $params){
        $stmt = self::getConn()->prepare($sql);
        $stmt->execute($params);
        $result = array();
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
            $result[] = $row;
        }

        return $result;

    }

    public function update($sql, $params){
        $stmt = self::getConn()->prepare($sql);
        $result = $stmt->execute($params);

        return $result;
    }

}

?>

测试代码：

<meta charset="utf-8">
<?php
include_once "PDOUtil.php";

$pdo = new PDOUtil();
//无条件查询多条数据
$sql = "SELECT * FROM testtable";
$result = $pdo->queryRows($sql,null);
var_dump($result);

////条件查询
//$sql = "SELECT * FROM testtable WHERE name != ? AND number != ? ";
//$params = array("张三","101");
//$result = $pdo->queryRows($sql,$params);
//var_dump($result);

//查询一条数据
//$sql = "SELECT * FROM testtable WHERE name = ? AND number = ? ";
//$params = array("张三","101");
//$result = $pdo->queryOneRow($sql,$params);
//var_dump($result);

////插入
//$sql = "INSERT INTO testtable (name, number) VALUES (?,?)";
//$params = array("赵六","106");
//$result = $pdo->update($sql,$params);
//var_dump($result);

////更新
//$sql = "UPDATE testtable SET number = ? WHERE name = ? ";
//$params = array("104","李四");
//$result = $pdo->update($sql,$params);
//var_dump($result);

////删除
//$sql = "DELETE FROM testtable  WHERE number = ? ";
//$params = array("106");
//$result = $pdo->update($sql,$params);
//var_dump($result);


?>