<?php

//mysql数据库类-mysqli版

//2014/6/13

class  mysqlidb{

     public $dbhost;

     public $dbuser;

     public $dbpasswd;

     public $dbname;

     public $dbport;

     public $dbobject;

     public function __contruct($host,$user,$pwd,$dbname,$port=3306){

         $this->dbhost = $host;

         $this->dbuser = $user;

         $this->dbpasswd = $pwd;

         $this->dbname = $dbname;

         $this->dbport = $port;

         $this->dbobject = new mysqli($this->dbhost,$this->dbuser,$this->dbpasswd,$this->dbname,$this->dbport);

           if ( $this->dbobject -> connect_error ) {

         die( 'Connect Error ('  .  $this->dbobject -> connect_errno  .  ') '

             .  $this->dbobject -> connect_error );

         }

     }

     public function executesql($sql,$param=array()){

         $dbstmt = $this->dbobject->prepare($sql);

         if(!empty($param)){

           foreach($param as $k => $v){

                $dbstmt -> bind_param($k,$v);

           }

         }

         $dbstmt -> execute();

         $dbresult = $dbstmt -> get_result();

         return  $dbresult->fetch_array();

     }

}

$db = new mysqlidb('127.0.0.1','root','','mysql');

$sql = 'select * from User';

$dbrs = $db->executesql($sql);

//Fatal error: Call to a member function prepare() on a non-object in C:\xampp\htdocs\tonglei\mysqli\demo2.php on line 28