CONEXAO.PHP

<?php
    class Conexao {
        private $data = array();
        //variavel da classe Base
        protected $pdo = null;

        public function __set($name, $value){
            $this->data[$name] = $value;
        }

        public function __get($name){
            if (array_key_exists($name, $this->data)) {
                return $this->data[$name];
            }

            $trace = debug_backtrace();
            trigger_error(
                'Undefined property via __get(): ' . $name .
                ' in ' . $trace[0]['file'] .
                ' on line ' . $trace[0]['line'],
                E_USER_NOTICE);
            return null;
        }

        //método que retorna a variável $pdo
        public function getPdo() {
            return $this->pdo;
        }

        //método construtor da classe
        function __construct($pdo = null) {
            $this->pdo = $pdo;
            if ($this->pdo == null)
                $this->conectar();
        }

        //método que conecta com o banco de dados
        public function conectar() {
            $local = "localhost";
            $user = "root";
            $pass = "";
            $basename = "diner";

            try {
                $this->pdo = new PDO("mysql:host=$local;dbname=$basename",
                                "$user",
                                "$pass",
                                array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
            } catch (PDOException $e) {
                print "Error!: " . $e->getMessage() . "<br/>";
                die();
            }
        }

        //método que desconecta
        public function desconectar() {
            $this->pdo = null;
        }

        public function select($statement){
            $pdo = $this->getPdo();
            $sth = $pdo->prepare($statement);
            $sth->execute();
            $result = $sth->fetchAll();
            return $result;
        }
    }
?>