2017 © Pedro Peláez
 

library database

Simple PDO helper to perform most common database operations

image

mac/database

Simple PDO helper to perform most common database operations

  • Sunday, March 16, 2014
  • by mac2000
  • Repository
  • 1 Watchers
  • 0 Stars
  • 23 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 6 Versions
  • 0 % Grown

The README.md

Database PDO Helper

Build Status, (*1)

PDO Helper implements some common database operations, (*2)

Installation

Here is composer.json example:, (*3)

{
    "require": {
        "mac/database": "x"
    },
    "repositories": [
        {
            "type": "vcs",
            "url": "https://github.com/mac2000/database"
        }
    ]
}

Usage example

First of all you need some database connection:, (*4)

$db = new Database(new PDO('mysql:host=localhost;dbname=example', 'root', 'root'));
// or for test purposes
$db = new Database(new PDO('sqlite::memory:'));

Retrieve all/one row(s):, (*5)

$users = $db->all("SELECT * FROM users");
$user = $db->one("SELECT * FROM users WHERE user_id = :user_id", array('user_id' => 1));

Retrieve computed value:, (*6)

$count = $db->cell("SELECT COUNT(*) FROM users");

Modify data:, (*7)

$lastInsertId = $db->execute(
    "INSERT INTO users (first_name, last_name, age) VALUES(:first_name, :last_name, :age)",
    array('first_name' => 'Hello', 'last_name' => 'World', 'age' => 9)
);

$rowsAffectedCount = $db->execute(
    "DELETE FROM users WHERE user_id = :user_id",
    array('user_id' => 2)
);

Run tests

Look at .travis.yml there is few tests that are runned:, (*8)

vendor/bin/phpunit
vendor/bin/phpcpd src tests
vendor/bin/phpmd src,tests text cleancode, codesize, controversial, design, naming, unusedcode
vendor/bin/phpcs --standard=psr2 src tests

The Versions

16/03 2014

dev-master

9999999-dev

Simple PDO helper to perform most common database operations

  Sources   Download

MIT

The Development Requires

by Marchenko Alexandr

16/03 2014

1.2.2

1.2.2.0

Simple PDO helper to perform most common database operations

  Sources   Download

MIT

The Development Requires

by Marchenko Alexandr

12/03 2014

1.2.1

1.2.1.0

Simple PDO helper to perform most common database operations

  Sources   Download

MIT

The Development Requires

by Marchenko Alexandr

12/03 2014

1.2.0

1.2.0.0

Simple PDO helper to perform most common database operations

  Sources   Download

The Development Requires

by Marchenko Alexandr

09/03 2014

1.1.0

1.1.0.0

PDO helper

  Sources   Download

The Development Requires

by Marchenko Alexandr

08/11 2013

1.0.0

1.0.0.0

PDO helper

  Sources   Download

The Development Requires

by Marchenko Alexandr