php连接数据库用的一些方法

xiaui520

<?php
class ConnectionMySQL{
//主机
private $host="localhost";
//数据库的username
private $name="root";
//数据库的password
private $pass="11111111";
//数据库名称
private $table="table";
//编码形式
private $ut="utf8";

//构造函数
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 'utf8'");
mysql_query("set character_set_client=utf8");
mysql_query("set character_set_results=utf8");
//中文乱码问题
}
function query($sql, $type = '') {
if(!($query = mysql_query($sql))) $query=null;
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 table_rows($table){
$query=mysql_query("select * from $table") or die(mysql_error());
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) values ($value)");
}
//根据$id值删除表$table中的一条记录
function fn_delete($table,$id,$value){
$this->query("delete from $table where $id=$value");
echo "id为". $id." 的记录被成功删除!";
}
//根据$id值查询表中的记录
function fn_select($table,$id){
$fileinfo=$this->query("select * from $table where id=$id");
return $fileinfo;
}
}

?>