vanokk/singleton-pdo

此包的最新版本(1.1.0)没有提供许可证信息。

单例PDO

1.1.0 2016-03-22 19:55 UTC

This package is not auto-updated.

Last update: 2024-09-14 19:42:05 UTC


README

安装

composer require "vanokk/singleton-pdo"

用法

例如,创建数据库并从sql/users.sql导出备份。在example.php中设置主机、数据库名称、用户名和用户密码。

<?php
require_once 'src/autoload.php';

$host = 'localhost';
$dbName = 'users';
$userName = 'root';
$userPassword = 'root';

$db = SingletonPDO\DB::connect('mysql:host='.$host.';dbname='.$dbName, $userName, $userPassword);

$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$query = new SingletonPDO\DBQuery($db);

$sql = "SELECT * FROM users";
echo $query->queryAll($sql);