ugo/simpleorm

Making database call a breeze

1.0 2021-04-15 17:43 UTC

Requires

• php: >=7.2.0

MIT

• Ugochukwu

README

Simple-orm is an Object Relational Mapper for php >=7.0.0. It gives you the flexibility to write complex SQL queries in one line of code

Installation

composer require ugo/simpleorm

Usage

<?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'=>'[e-mail]','password'=>'123456'],[]);
var_dump($output);