2017 © Pedro Peláez
 

library pdo

PHP 7.2 Compatible Fork of PDO database library for Slim Framework

image

kimoslim/pdo

PHP 7.2 Compatible Fork of PDO database library for Slim Framework

  • Thursday, May 3, 2018
  • by kimosabi77
  • Repository
  • 1 Watchers
  • 0 Stars
  • 40 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 80 Forks
  • 0 Open issues
  • 21 Versions
  • 186 % Grown

The README.md

Slim-PDO

PDO database library for Slim Framework, (*1)

This is a fork of Fabien's project with support for PHP 7.2., (*2)

Please refer to the main package at https://github.com/faaPz/Slim-PDO for pull requests, support and documentation., (*3)

Installation

Use Composer, (*4)

"require": {
    "kimoslim/pdo": "~1.10"
}

Usage

Examples selecting, inserting, updating and deleting data from or into users table., (*5)

require_once 'vendor/autoload.php';

$dsn = 'mysql:host=your_db_host;dbname=your_db_name;charset=utf8';
$usr = 'your_db_username';
$pwd = 'your_db_password';

$pdo = new \Slim\PDO\Database($dsn, $usr, $pwd);

// SELECT * FROM users WHERE id = ?
$selectStatement = $pdo->select()
                       ->from('users')
                       ->where('id', '=', 1234);

$stmt = $selectStatement->execute();
$data = $stmt->fetch();

// INSERT INTO users ( id , usr , pwd ) VALUES ( ? , ? , ? )
$insertStatement = $pdo->insert(array('id', 'usr', 'pwd'))
                       ->into('users')
                       ->values(array(1234, 'your_username', 'your_password'));

$insertId = $insertStatement->execute(false);

// UPDATE users SET pwd = ? WHERE id = ?
$updateStatement = $pdo->update(array('pwd' => 'your_new_password'))
                       ->table('users')
                       ->where('id', '=', 1234);

$affectedRows = $updateStatement->execute();

// DELETE FROM users WHERE id = ?
$deleteStatement = $pdo->delete()
                       ->from('users')
                       ->where('id', '=', 1234);

$affectedRows = $deleteStatement->execute();

The sqlsrv extension will fail to connect when using error mode PDO::ERRMODE_EXCEPTION (default). To connect, you will need to explicitly pass array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING) (or PDO::ERRMODE_SILENT) into the constructor, or override the getDefaultOptions() method when using sqlsrv., (*6)

Documentation

See DOCUMENTATION, (*7)

Changelog

See CHANGELOG, (*8)

License

See LICENSE, (*9)

The Versions

03/05 2018

dev-master

9999999-dev https://github.com/FaaPz/Slim-PDO

PHP 7.2 Compatible Fork of PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender
by Kim Richardson

database framework pdo slim

03/05 2018

1.10.2

1.10.2.0 https://github.com/FaaPz/Slim-PDO

PHP 7.2 Compatible Fork of PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender
by Kim Richardson

database framework pdo slim

21/03 2018

dev-v2-dev

dev-v2-dev https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.6.0
  • ext-pdo *

 

The Development Requires

by Fabian de Laender
by Alexander Barker

database framework pdo slim

15/08 2017

1.10.1

1.10.1.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

14/08 2016

1.10.0

1.10.0.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

29/05 2016

1.9.9

1.9.9.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

27/02 2016

1.9.8

1.9.8.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

27/02 2016

1.9.7

1.9.7.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

03/02 2016

1.9.6

1.9.6.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

23/01 2016

1.9.5

1.9.5.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

20/01 2016

1.9.4

1.9.4.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

12/01 2016

1.9.3

1.9.3.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

28/12 2015

1.9.2

1.9.2.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

02/12 2015

1.9.1

1.9.1.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

30/11 2015

1.9.0

1.9.0.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

22/11 2015

1.8.2

1.8.2.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

07/10 2015

1.8.1

1.8.1.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

14/09 2015

1.8.0

1.8.0.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

08/08 2015

1.7.2

1.7.2.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

08/08 2015

1.7.1

1.7.1.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim

25/07 2015

1.7.0

1.7.0.0 https://github.com/FaaPz/Slim-PDO

PDO database library for Slim Framework

  Sources   Download

MIT

The Requires

  • php >=5.3.0
  • ext-pdo *

 

by Fabian de Laender

database framework pdo slim