coffeebreaks/database

该组件连接、注册、读取、编辑和删除数据库中的记录

维护者

详细信息

github.com/Guilherme-fagundes/database

源代码

安装: 32

依赖项: 1

建议者: 0

安全: 0

星星: 1

关注者: 0

分支: 0

V1.1.5 2021-04-04 02:02 UTC

Requires

MIT 1265d7bc515186e3a93e95d865dff668aef7fcdf

  • Guilherme K. Fagundes

ormconnectupdateinsertdeletereadphp orm

This package is auto-updated.

Last update: 2024-09-04 09:51:03 UTC

README

Source Code PHP from Packagist Latest Stable Version License Total Downloads Build Quality Score

COFFEBREAKS/DATABASE

该组件连接、注册、读取、编辑和删除数据库中的记录。

安装
composer require coffeebreaks/database

配置

使用PDO连接

define('DB', [
    'host' => 'localhost',
    'user' => 'root',
    'pass' => '',
    'name' => 'dbdebug',
    'port' => 3306,
    'driver' => 'mysql', //default = mysql
    'options' => [
        PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ
    ]
]);

创建模型

在文件夹app/Models中创建名为Users的类

<?php


namespace App\Models;


use Database\Database;

class Users extends Database
{
protected $table = "users";
}

创建用户

use App\Models\Users;

$user = new Users();

$user->name = "Guilherme";
$user->age = 26;

$user->save();


var_dump($user);

更新用户

$user = new Users();
$user->id = 1;
$user->name = "Guilherme K.";
$user->age = 26;

$user->save();


var_dump($user);

列出所有数据

$user = new Users();

var_dump($user->all()->getGet());

通过ID查找

$user = new Users();
$user->findById(1);


var_dump($user->getGet());

通过电子邮件查找

$user = new Users();
$user->findByEmail("email@email.com");


var_dump($user->getGet());

排序

$user = new Users();

var_dump($user->all()->orderBy('collumn ASC'));