我的数据库连接(简单的 需要的功能还要继续添加)
<?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'"); ?>