Codeigniter กับ PDO Driver ตั้งค่าอย่างไรให้สามารถใช้ PDO ได้แบบเต็มๆ มาดูกัน

$db['default']['hostname'] = 'mysql:host=localhost;dbname=test';
$db['default']['username'] = 'root';
$db['default']['password'] = 'xxxxx';
$db['default']['database'] = 'test';
$db['default']['dbdriver'] = 'pdo';

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Test extends CI_Controller {
	public function __construct()
	{
		parent::__construct();
	}
	public function index()
	{
		$id = 4;
		$sql = "SELECT * FROM mytable WHERE id = ?";
		$q = $this->db->conn_id->prepare($sql);
		$q->bindValue(1, $id, PDO::PARAM_INT);
		$q->execute();
		print_r($q->fetch(PDO::FETCH_ASSOC));
	}
}

Array ( [id] => 4 [details] => Description [created] => 2014-09-04 14:19:30 [modified] => )