2017 © Pedro Peláez
 

library easy-sql

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

image

m1ke/easy-sql

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  • Monday, September 5, 2016
  • by m1ke
  • Repository
  • 2 Watchers
  • 0 Stars
  • 293 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 1 Forks
  • 0 Open issues
  • 11 Versions
  • 0 % Grown

The README.md

Easy SQL

An extension to Aura.Sql which simplifies object creation, adds extra database manipulation methods, extra fetch methods and a PersistendPdo class for long-lived connections as part of event driven applications., (*1)

Use

use M1ke\Sql\ExtendedPdo;

$pdo = new ExtendedPdo('database', 'user', 'pass');

$user_id = $pdo->insert('users', ['name'=>'Foo', 'email'=>'foo@bar.com']);
// user created, returns ID

$affected_rows = $pdo->update('users', "SET :params WHERE user_id={$user_id}", ['name'=>'Bar']);
// user name changed to "Bar", returns number of rows affected

For real time applications simply run methods on the static PersistPdo object:, (*2)

use M1ke\Sql\PersistPdo;

PersistPdo::setConfig('database', 'user', 'pass');
PersistPdo::fetchOne("SELECT * FROM users WHERE user_id = 1");
// returns ['user_id'=>1, name'=>'Bar', 'email'=>'foo@bar.com']

The Versions

05/09 2016

dev-x1.6

dev-x1.6

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires

22/03 2016

dev-x1.5

dev-x1.5

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires

11/03 2016

dev-master

9999999-dev

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires

16/02 2016

dev-x1.4

dev-x1.4

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires

02/02 2016

dev-x1.3

dev-x1.3

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires

07/01 2016

dev-x1.2

dev-x1.2

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires

09/11 2015

dev-x1.1

dev-x1.1

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires

08/10 2015

dev-x1.0

dev-x1.0

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires

27/07 2015

dev-x0.6

dev-x0.6

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires

27/07 2015

dev-x0.7

dev-x0.7

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires

07/07 2015

dev-x0.5

dev-x0.5

Builds on Aura's ExtendedPdo to add database manipulation helpers and persistent connections

  Sources   Download

BSD-2-Clause

The Requires

 

The Development Requires