PdoApi.php

<?php
/**
 * File:        PdoApi.php
 * 
 * Using this you can write PDO related code only one line.
 * Example
 * (new PdoApi('db', 'name', 'pass', 'host'))->exec('select * from table');
 *
 * @author takayuki.tamura
 * @version 1.0.0
 */

class PdoApi
{

	public $dbh;

	function __construct($dbName, $dbUser, $pass, $host) {
		$dsn = 'mysql:dbname='.$dbName.';host='.$host;
		try {
			$this->dbh = new PDO($dsn, $dbUser, $pass);
			$this->dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		} catch (PDOException $e){
		    print('Error:'.$e->getMessage());
		    die();
		}
	}

	public function exec($sql) {
		try {
			$this->dbh->beginTransaction();
			$sth = $this->dbh->query($sql);
			$this->dbh->commit();
			return $sth;
		} catch (PDOException $e){
			$this->dbh->rollBack();
		    print('Error:'.$e->getMessage());
		    die();
		}
	}
}