PHP下的mysqli封装

<?php
class mysql{
    /*
     *连接数据库
     *@return resource
     */
    function connect(){
        //创建连接
        $conn = mysqli_connect(HOST,USERNAME,PASSWORD) or die("Failed opening database".mysqli_connect_errno().mysqli_connect_error());
        mysqli_set_charset($conn, CHARSER);
        mysqli_select_db($conn, DATABASENAME) or die("Can't open the database");
        
        return $conn;
    }
          
    /*
     *插入记录
     *@param array $array
     *@param string $table
     *@return boolean
     */    
    function insert($link,$data,$table){
        $key = join(',', array_keys($data));
        $values = "'".join("','",array_values($data))."'";
        $query = "INSERT INTO {$table} ({$key}) VALUES ({$values})";
        $result = mysqli_query($link, $query) or die("From insert error".mysqli_errno($link).':'.mysqli_error($link)) ;