PDO操作数据库类

<?php

    class mypdo{

        public $link;

       public $host;

        public $dbname;

        public $user;

        public $pwd;

        public $char;

        public function __construct($host,$dbname,$user,$pwd){

            $this->host=$host;

            $this->dbname=$dbname;

            $this->user=$user;

            $this->pwd=$pwd;

            $this->char='set names utf8';

            $this->link=new pdo("mysql:host={$this->host};dbname={$this->dbname}",$this->user,$this->pwd);

            $this->link->query($this->char);

        }

        public function query($sql){

            return $this->link->query($sql);

        }

        public function getAll($sql){

            return $this->query($sql)->fetchAll(PDO::FETCH_ASSOC);

        }

        public function getnum($sql){

            return $this->query($sql)->rowCount();

        }

    }

    $pdo=new mypdo("localhost","news","root","");

    $sql='select * from newstype';

    $rs=$pdo->getAll($sql);