mysql连接代码_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 . '
' . $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);

?>