previewtechs/simple-pdo

Simple PDO library for PHP

v1.0 2017-02-25 15:40 UTC

Requires (Dev)

• mockery/mockery: ^0.9.8
• phpunit/phpunit: 4.8.*
• squizlabs/php_codesniffer: ~2.0

MIT

• Preview Technologies

README

###MySQL PDO Simple Library

####Installation

composer require previewtechs/pdo-simple

####Usage

<?php
require 'vendor/autoload.php';

$pdo = new \Previewtechs\Database\MySQL\PDO(MYSQL_DSN, MYSQL_USERNAME, MYSQL_PASSWORD);

$pdo->query("INSERT INTO users (id, name, email, created) VALUES (NULL , :name, :email, :created)");

$pdo->bind(':name', "Your Name");
$pdo->bind(':email', "[e-mail]");
$pdo->bind(':created', date("Y-m-d H:i:s"));

$pdo->execute();

echo $pdo->lastInsertedId();    //should return ID from database

####Sample Database

CREATE DATABASE IF NOT EXISTS test_db;

CREATE TABLE IF NOT EXISTS `test_db`.`users` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `email` varchar(64) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;