PHP Classes

PDO helper: Connect and access several database types with PDO

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 41%Total: 352 All time: 6,984 This week: 67Up
Version License PHP version Categories
pdohelper 1.28The PHP License5.4Databases
Description 

Author

Lukasz Józwiak

This class can connect and access several database types with PDO.

It provides a wrapper to access databases with PDO like MySQL, sqlsrv, sqlite, pgsql.

Currently it can means to execute functions like create and drop tables, insert and update with if exists key, execute queries with and without transactions.

Picture of Lukasz Józwiak
  Performance   Level  

Level 1 Star

 

Example

<?php

/*
 * is simple connector helper with few most used functions
 */

if (!defined('DS')) {
    define('DS', DIRECTORY_SEPARATOR);
}
if (!defined('ROOT')) {
    define('ROOT', realpath(dirname(__FILE__)));
}

$url = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') ? 'https://' . dirname($_SERVER['HTTP_HOST'] . $_SERVER['SCRIPT_NAME']) . '/' : 'http://' . dirname($_SERVER['HTTP_HOST'] . $_SERVER['SCRIPT_NAME']) . '/';
if (!defined('HOST')) {
    define('HOST', $url);
}
define('DBDEBUG',1);

require_once ROOT.DS.'Library'.DS.'db.php';

$d = new \Library\DB;
        // for sqlite "localhost" can be relaced with path to database
$d->Connect('mysql', 'database', 'user', 'password', 'localhost');

var_dump($d->db); // << PDO Object


$d->createTable('tested', array(
    'name VARCHAR(255)',
    'string VARCHAR(255)'

));

$d->TInsertIF('tested', ['name' => 'info', 'string' => 'text']);
        // same as
$d->Begin();
$d->InsertIF('tested', ['name' => 'info', 'string' => 'text']);
$d->Commit(); // or $d->Rollback(); on error

$a = $d->db->query('SELECT * FROM tested'); // call PDO fn
var_dump($a->fetchAll(\PDO::FETCH_NAMED));

$d->Tupdate('tested', ['string' => 'changed'], 'where name=?', ['info']);

$d->Tinsertupdate('tested', ['string' => 'other'], 'where name=?', ['none']); // insert if not found or update exists

$q = $d->Select('tested', ['*'], 'WHERE name = ?', ['info']);

var_dump($q);

$d->Query('SELECT * FROM tested'); // like prepare, exec is shotrcut to PDO fn

$d->dropTable('tested');
?>

  Files folder image Files (8)  
File Role Description
Files folder imagelibrary (2 files, 1 directory)
Accessible without login Plain text file test.php Example usage demo

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadpdohelper-2017-10-17.zip 10KB
Downloadpdohelper-2017-10-17.tar.gz 6KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:352
This week:0
All time:6,984
This week:67Up
User Ratings User Comments (1)
 All time
Utility:58%StarStarStar
Consistency:58%StarStarStar
Documentation:-
Examples:66%StarStarStarStar
Tests:-
Videos:-
Overall:41%StarStarStar
Rank:3725
  

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.