<?php
class mysql{
private $host;
private $name;
private $pass;
private $db;
private $ut;
function __construct($host,$name,$pass,$db,$ut){ //注意function后边的空格
$this->host=$host;
$this->name=$name;
$this->pass=$pass;
$this->db=$db;
$this->ut=$ut;
}
function connect(){
$link=mysql_connect($this->host,$this->name,$this->pass)or die($this->error());
mysql_select_db($this->db,$link)or die("没有找到数据库".$this->db);
mysql_set_charset("$this->ut");
}
function error(){
return mysql_error();
}
function query($sql){
return $query=mysql_query($sql);
}
/*function affected_rows(){
return mysql_affected_rows();
}
function result($sql,$row){
return mysql_result($query, $row);
}
function free_result($query){
return mysql_free_result($query);
}
function num_rows($query){
return mysql_num_rows($query);
}
function num_fileds($query){
return mysql_num_fields($query);
}
function fetch_row($query){
return mysql_fetch_row($query);
}
function close(){
return mysql_close();
} */
//=======?函数类型分割?========//
function fn_insert($db,$name,$value){
//这个函数是sql语句函数,参数按顺序来
$this->query("insert into $db ($name) values ($value)");
}
}
$a=new mysql('localhost','root','123','madb','utf8');//创建对象
//这里的参数顺序是构造函数里面的顺序
$a->connect();//连接数据库
$a->fn_insert('admin','id,name,pwd',"null,'李健','12345'");
?>