develhopper/qbuilder

又一个PHP查询构建库

维护者

详情

github.com/develhopper/Qbuilder

源码

问题

安装: 39

依赖: 2

建议者: 0

安全: 0

星标: 0

关注者: 2

分支: 1

开放问题: 0

2.4.4 2021-12-13 08:26 UTC

Requires

Requires (Dev)

GPL-3.0-only 7c1d75e278a7dd38a95fb16d2e4d2ab1e9910328

  • develhoper <develhoper.0.woop@gmail.com>

This package is auto-updated.

Last update: 2024-09-13 14:31:59 UTC

README

又一个Query Builder PHP库

文档

安装

composer require develhopper/qbuilder

设置

在dotenv中设置以下变量

DB_DRIVER=mysql
DB_HOST=127.0.0.1
DB_NAME=[database name]
DB_USER=[database user]
DB_PASSWORD=[database password]

创建模型

<?php
namespace models;

use QB\QBuilder as Model;

class Customer extends Model{
    // table name
    protected $table="customers";
    
    // primary key
    protected $primary="customerNumber";

    // relations
    public function payments(){
        return $this->hasMany(Payment::class,false);
    }
}

创建迁移

<?php
use QB\Migration\Migration;
use QB\Migration\Column;
use Denver\Env;

Env::setup(__DIR__."/.env");

$users = Migration::create_table('users', Column::IntegerField('id', ['primary' => true]),
    Column::StringField('username',25,['unique' => true]),
    Column::StringField('email',255,['unique' => true]),
    Column::StringField('password',255)
);

$profile = Migration::create_table('profile', Column::IntegerField('id', ['primary']),
    Column::StringField('first_name', 30),
    Column::StringField('last_name', 30),
    Column::IntegerField('user_id', ['connect' => $users->id, 'on_delete' => 'cascade', 'on_update' => 'restrict'])
);

更多

... 读取代码