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
This package is auto-updated.
Last update: 2024-11-06 09:26:20 UTC
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', "your@email.com"); $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;