5月13日 PDO封装

最新推荐文章于 2025-09-08 20:15:10 发布

转载最新推荐文章于 2025-09-08 20:15:10 发布 · 54 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/dongqiaozhi/p/5497717.html

文章标签：

#php

<?php
class PDOA
{
    public $host = "localhost";
    public $uid = "root";
    public $pwd = "";
    
    //执行SQL语句的方法，$type代表SQL语句的类型，0代表查询
    public function Prepare($sql,$typepdo = 0,$db = "mydb",$fwq = "mysql")
    {
        $dsn = "$fwq:dbname=$db;host=$this->host";
        $pdo = new PDO($dsn,$this->uid,$this->pwd);
        $stm = $pdo->prepare($sql);
        if($stm->execute())
        {
            if($typepdo == 0)
            {
                return $stm->fetchAll(PDO::FETCH_ASSOC);
            }
            else
            {
                echo "执行成功";
                return $stm->execute();
            }
        }
        else
        {
            echo "执行失败";
        }
    }
    
    
    
    
    
    
    
    
    }