db/sql-packge

维护者

详细信息

github.com/yossef-ashraf/sql-packge

源代码

问题

安装: 4

依赖: 0

建议者: 0

安全: 0

星标: 2

关注者: 1

分支: 0

开放问题: 1

v1 2022-03-30 10:57 UTC

MIT 14d3e2d172447f923b23329fe5f78f170270ebd7

  • yossef-ashraf <yossefff2001.woop@gmail.com>

This package is auto-updated.

Last update: 2024-09-29 05:50:09 UTC

README

sql-packge 是一个用于 mysql 数据库的小型 PHP 包装器。

安装

使用 composer 一次性安装

composer require db/sql-packge

然后将以下内容添加到您的项目中

require __DIR__ . '/vendor/autoload.php';
use Db\SqlPackge\sql;
$db = new sql();

使用方法

/* connect to database */
$db = new sql('127.0.0.1', 'username', 'password', 'database', 3306);

/* exaples */

/* select */
var_dump( $db->select("users","*")->getAll());
var_dump( $db->select("users","*")->where("id","=","9")->getRow());
var_dump( $db->andWhere("id","LIKE","5")->getRow());
var_dump( $db->orWhere("id","BETWEEN","5")->getRow());
var_dump( $db->WhereNot("id","IN","5")->getRow());
var_dump( $db->notWhere("id","<","5")->getRow());



/* insert/update/delete */
var_dump( $db->insert("users",["name"=>"name","email"=>"email","pass"=>"pass"])->set());
var_dump( $db->delete("users","id","7")->set());
var_dump( $db->deleteTable("users")->set());
var_dump( $db->update("users",["name"=>"name","email"=>"email","pass"=>"pass"] , "id = 15")->set());;