mysql连接操作类

[php]代码库

<?php
class ConnectionMySQL
{
    //主机
    private $host = "localhost";
    //数据库的username
    private $name = "root";
    //数据库的password
    private $pass = "";
    //数据库名称
    private $table = "phptest";
    //编码形式
    private $ut = "utf-8";
    
    
    //构造函数
    function __construct()
    {
        $this->ut = $ut;
        $this->connect();
        
    }
    
    //数据库的链接
    function connect()
    {
        $link = mysql_connect($this->host, $this->name, $this->pass) or die($this->error());
        mysql_select_db($this->table, $link) or die("没该数据库：" . $this->table);
        mysql_query("SET NAMES '$this->ut'");
    }
    
    function query($sql, $type = '')
    {
        if (!($query = mysql_query($sql)))
            $this->show('Say:', $sql);
        return $query;
    }
    
    function show($message = '', $sql = '')
    {
        if (!$sql)
            echo $message;
        else
            echo $message . '<br>' . $sql;
    }
    
    function affected_rows()
    {
        return mysql_affected_rows();
    }
    
    function result($query, $row)
    {
        return mysql_result($query, $row);
    }
    
    function num_rows($query)
    {
        return @mysql_num_rows($query);
    }
    
    function num_fields($query)
    {
        return mysql_num_fields($query);
    }
    
    function free_result($query)
    {
        return mysql_free_result($query);
    }
    
    function insert_id()
    {
        return mysql_insert_id();
    }
    
    function fetch_row($query)
    {
        return mysql_fetch_row($query);
    }
    
    function version()
    {
        return mysql_get_server_info();
    }
    
    function close()
    {
        return mysql_close();
    }
    
    //向$table表中插入值
    function fn_insert($table, $name, $value)
    {
        $this->query("insert into $table ($name) value ($value)");
    }
    //根据$id值删除表$table中的一条记录
    function fn_delete($table, $id, $value)
    {
        $this->query("delete from $table where $id=$value");
        echo "id为" . $id . " 的记录被成功删除!";
    }
}



$db = new ConnectionMySQL();

$db->fn_insert('test', 'id,name,sex', "'',神马,'M'");
$db->fn_delete('test', 'id', 1);

?>