Getting Started with PHP: A Class to Connect to MySQL Database_PHP Tutorial

Project structure:

Operation effect;

conn.php

Copy code The code is as follows:

class ConnectionMySQL{
//Host
private $host="localhost";
//Database username
private $name="root";
//Database password
private $pass="";
//Database name
private $table="phptest";
//Encoding form
private $ut="utf-8";
/ /Constructor
function __construct(){
$this->ut=$ut;
$this->connect();
}
//Database link
function connect(){
$link=mysql_connect($this->host,$this->name,$this->pass) or die ($this->error());
mysql_select_db($this->table,$link) or die("No such database: ".$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();
}
//Insert values ​​into the $table table
function fn_insert($table,$name,$ value){
$this->query("insert into $table ($name) value ($value)");
}
//Delete an entry in table $table based on $id value Record
function fn_delete($table,$id,$value){
$this->query("delete from $table where $id=$value");
echo "id is". The record of $id." was successfully deleted!";
}
}
$db = new ConnectionMySQL();
$db->fn_insert('test','id,name, sex',"'','hongtenzone','M'");
$db->fn_delete('test', 'id', 1);
?>

http://www.bkjia.com/PHPjc/325333.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/325333.htmlTechArticleProject structure: Running effect; conn.php copy code The code is as follows: ?php class ConnectionMySQL{ //Host private $ host="localhost"; //Database username private $name="root"; //Number...