沙诺 / php-database-manager
Mysql 数据库连接和操作库
v1.0.0
2021-08-29 21:08 UTC
Requires
- php: >=7.0
README
这是一个简单的PHP数据库连接和查询管理库。
安装
要执行此依赖项,只需运行以下命令
composer require sandro/php-database-manager
使用方法
要使用此库,只需参考以下示例
数据库
<?php require 'vendor/autoload.php'; use SandroAmancio\DatabaseManager\Database; //DATABASE CREDENTIALS $dbHost = 'localhost'; $dbName = 'database'; $dbUser = 'root'; $dbPass = 'pass'; $dbPort = 3306; //Configuração da classe de banco de dados DataBase::config($dbHost,$dbName,$dbUser,$dbPass,$dbPort); //Instancinado um tabela $obDatabase = new Database('table_name'); //SELECT (return a PDOStatement object) $results = $obDatabase->select('id > 10','name ASC','1','*'); //INSERT (return inserted id) $id = $obDatabase->insert([ 'name' => 'Meu Nome' ]); //UPDATE (return a bool) $success = $obDatabase->update('id = 1',[ 'name' => 'meu nome2' ]); //DELETE (return a bool) $success = $obDatabase->delete('id = 1');
要求
- PHP >= 7.0