pullay/database

PHP的轻量级查询构建器

维护者

详细信息

github.com/Pullay/database

主页

源代码

问题

安装: 38

依赖项: 0

建议者: 0

安全: 0

星标: 0

关注者: 1

分支: 0

开放问题: 0

dev-master 2023-11-16 07:13 UTC

Requires

  • php: >=5.6
  • ext-pdo: *

MIT d2dee5046f214978c9c990ca77ff3585a45c95ea

databasequerypdo

This package is auto-updated.

Last update: 2024-09-16 09:11:47 UTC

README

PHP的轻量级查询构建器

Software License Packagist

安装

composer require pullay/database dev-master

开始使用

use Pullay\Database\Driver\Mysql;
use Pullay\Database\Connection;

$driver = Mysql::connect('localhost', 'test', 'user', 'password');
$connection = new Connection($driver);
$query = $connection->getQueryBuilder()
    ->select('user')
    ->where(['id' => 1])
    ->limit(1);

$row = $query->fethOne();

CRUD查询

插入

$values = ['username' => 'alex', 'password' => 'qwerty'];
$query = $connection->getQueryBuilder()
    ->into('user')
    ->values($values);
$lastInsertId = $query->execute();

选择

$query = $connection->getQueryBuilder()
    ->select('user')
    ->where(['id' => 1])
    ->limit(1);

// fetch
$row = $query->fetch();

// fetch all
$rows = $query->fetchAll();

// or
foreach ($query as $row) {
    echo $row['username'];
}

// count
$count = $query->count();

条件

联合表

更新

$query = $connection->getQueryBuilder()
    ->update('user')
    ->set('username', 'bob')
    ->where(['id' => 1]);
$rowCount = $query->execute();

删除

$query = $connection->getQueryBuilder()
    ->delete('user')
    ->where(['id' => 1]);
$rowCount = $query->execute();