ugo/simpleorm

让数据库调用变得轻松

1.0 2021-04-15 17:43 UTC

This package is auto-updated.

Last update: 2024-09-29 05:43:12 UTC


README

SimpleORM

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);