komalbarun/pdosqlwrapper

Simple wrapper for mysql with PDO

0.1.0 2017-05-13 21:12 UTC

Requires

• php: >=7.0

MIT

• Rambarun Komaljeet

• Simple Mysql Pdo Wrapper

README

Simple wrapper for mysql with PDO

Installation

composer require komalbarun\pdosqlwrapper

Dependencies

• php >= 7.0

Usage

<?php

require_once './vendor/autoload.php';

use Komalbarun\PdoSqlWrapper;

//config assoc
$config = [
    'host' => '',
    'dbname' => '',
    'user' => '',
    'password' => '',
    'charset' => ''
    'port' => ''
];

$db = new PdoSqlWrapper($config);

// no user input fetch
// $results is a generator object.
$results = $db->fetch_simple_sql($sql);

// user input fetch (uses prepared statement).
// $results is a generator object.
// $data is an array 
$results = $db->fetch_prepared_sql($sql, $data);

// no user input CUD
$db->simple_execute_sql($sql);

// User input CUD (uses prepared statement)
// // $data is an array 
$db->prepared_execute_sql($sql, $data)

//PDO::fetchAll()
$db->fetch_simple_sql_all($sql)

//PDO::fetchAll()
$db->fetch_prepared_sql_all($sql, $data)