PHP 连接MySQL 的单态类

最新推荐文章于 2021-03-10 18:37:31 发布

iteye_6233

最新推荐文章于 2021-03-10 18:37:31 发布

阅读量62

点赞数

文章标签： php 数据库

本文展示了如何使用PHP创建MySQL数据库连接、选择数据库、执行SQL查询并获取结果的基本步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?php
/**
 * author: xueming
 */
class MySQLConnFactory
{
	private $conn;
	static private $_mysqlconn;

	//Construct-->connect DB
	private function __construct($host,$username,$password)
	{
		$this->conn = mysql_connect($host,$username,$password);
		$this->query("SET NAMES 'utf8'");
		return $this->conn;
	}
	
    private function __clone(){}

	public static function getSingleMySQLConn($host,$username,$password)
	{
		if(FALSE==(self::$_mysqlconn instanceof self))
		{
			self::$_mysqlconn = new self($host,$username,$password);
		}
		return self::$_mysqlconn;
	}

	//select DB
	public function select_db($database)
	{
		$this->result = mysql_select_db($database);
		return $this->result;
	}
	
	//Query 
	public function query($query)
	{
		return $this->result = mysql_query($query, $this->conn);
	}
	
	//fetch result
	public function fetch_array($fetch_array)
	{
		return $this->result = mysql_fetch_array($fetch_array, MYSQL_ASSOC);
	}
	
	//close
	public function close()
	{
		return $this->result = mysql_close($this->conn);
	}
}
?>

调用方式如下

    $sql = "select * from test";
    $connector = MySQLConnFactory::getSingleMySQLConn($db_server,$db_user,$db_pwd);
    $connector -> select_db($db_name);
    $result = $connector -> query($sql);