Lora

class cmsMy_pdo extends cmsDatabase {
 
public function __construct(){
		$this->db_link   = self::initConnection();
}
 
private static function initConnection(){
   $ini = PATH.'/includes/config.ini' ;
        $parse = parse_ini_file ( $ini , true ) ;
 
        $driver = $parse [ "db_driver" ] ;
        $dsn = "${driver}:" ;
        $user = $parse [ "db_user" ] ;
        $password = $parse [ "db_password" ] ;
        $options = $parse [ "db_options" ] ;
        $attributes = $parse [ "db_attributes" ] ;
 
        foreach ( $parse [ "dsn" ] as $k => $v ) {
            $dsn .= "${k}=${v};" ;
        }
 
        $db_link = new PDO ( $dsn, $user, $password, $options ) ;
 
        $db_link->exec('SET NAMES utf8');
        foreach ( $attributes as $k => $v ) {
            $db_link -> setAttribute ( constant ( "PDO::{$k}" )
                , constant ( "PDO::{$v}" ) ) ;
        }
 
        return $db_link ;
}
 
//========================================================================//
	public function get_table($table, $where='', $fields='*'){
 
		$list = array();
 
                $sql = "SELECT $fields FROM $table";
		if ($where) { $sql .= ' WHERE '.$where; }
 
		$result = $this->db_link->query($sql);
 
			while($data = $result->fetch()){
				$list[] = $data;
			}
			return $list;
 
	}
//=====================================================================//
 
}