previewtechs/simple-pdo

Simple PDO library for PHP

Maintainers

Details

github.com/PreviewTechnologies/simple-pdo

Source

Issues

Installs: 11

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 3

Forks: 1

Open Issues: 0

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

Requires (Dev)

MIT e72d24b348a784c42c4eeb9e250e3b857f44d46d

  • Preview Technologies <info.woop@previewtechs.com>

This package is auto-updated.

Last update: 2024-04-06 08:19:45 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;