ugo / simpleorm
让数据库调用变得轻松
1.0
2021-04-15 17:43 UTC
Requires
- php: >=7.2.0
README
Simple-orm 是一个适用于 php >=7.0.0 的对象关系映射器。它允许您在一行代码中编写复杂的 SQL 查询
安装
composer require ugo/simpleorm
使用
<?php require_once __DIR__."/../vendor/autoload.php"; use DbObject\DbObject; $dbcnx = [YOUR DATABASE CONNECTION STRING]; $object = new DbObject($dbcnx); // to select 2 records from the table userdata $output = $object->doSelect('userdata')->limit('2')->run(); var_dump($output); // get all records but just the username and password fields from table userdata $output = $object->doSelect('userdata',['username','password'])->run(); var_dump($output); /// insert records to table userdata $output = $object->doInsert('userdata',['username'=>'joe@mail.com','password'=>'123456'],[]); var_dump($output);