neyltonbenjamim/database

MySQL数据库管理，采用Record active标准

维护者

详细信息

github.com/neyltonbenjamim/database

源代码

问题

安装: 20

依赖: 0

建议者: 0

安全: 0

星标: 2

关注者: 1

分支: 0

开放性问题: 0

v1.0.2 2024-01-17 22:35 UTC

Requires

  • php: >=7.4

MIT 44aa5db402978b55bab45f3cba9b798d55c6a7cc

  • Neylton Benjamim <neylton.b.woop@hotmail.com>

This package is auto-updated.

Last update: 2024-09-18 00:16:10 UTC

README

MySQL数据库管理

安装database

composer require neyltonbenjamim/database

创建配置文件

config.php

define('DBS',array(

    'databasesv1' => array(
        'host'   => 'localhost',
        'user'   => 'root',
        'pass'   => '',
        'dbname' => 'databasesv1',
        'PREFIXTABLE' => 'tab'
    )
));

应用程序文件

index.php

//Puxando autoload do composer
require __DIR__.'/vendor/autoload.php';
//Puxando configuração do banco de dados
require __DIR__.'/config.php';

use Database\Transaction;
use Database\Record;
//Class user, para persistir user no banco de dados
class user extends Record
{
    const TABLENAME = 'tab_user';
    const PRIMARYKEY = 'user_id';
}
//Abrindo conexão com o banco de dados
Transaction::open();
//Puxando todos usuário do banco de dados
$users = user::all();

foreach ($users as $key => $user) {
	var_dump($user);
}