Home > Backend Development > PHP Tutorial > Simple encapsulation of some functions of the mysql module in php

Simple encapsulation of some functions of the mysql module in php

高洛峰
Release: 2023-03-01 13:10:02
Original
1129 people have browsed it

The code is as follows:

class mysql 
{ 
private $db; // datebase connect 
private $result; // mysql result 
static private $mysql; // mysql object 
private function __construct() 
{ // The work before Create an object 
$this->db = mysql_connect('localhost','root',''); 
mysql_select_db('hello', $this->db ); 
} 
public static function getObject() 
{ //if have a object,return that object,Not create 
if(! self::$mysql instanceof self) 
self::$mysql = new self; 
return self::$mysql; 
} 
public function query($sql) 
{ 
$this->result = mysql_query($sql, $this->db); 
return $this->result; 
} 
public function fetch() 
{ 
if( isset($this->result ) ) 
return mysql_fetch_assoc( $this->result ); 
} 
public function error() 
{ 
return 'error:'.mysql_error(); 
} 
public function num() // for sql select result 
{ 
return mysql_num_rows( $this->result ); 
} 
public function close() 
{ // return true or false 
return mysql_close( $this->db ); 
} 
}
Copy after login


Related labels:
php
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template