یک کلاس جالب برای اتصال به بانک داده ها
<?php
// Using OOP PHP to select, update, and insert data in a mysql database
class database
{
private $dbhost;
private $dbuser;
private $dbpass;
private $dbname;
private static $instance;
private $connection;
private $results;
private $numRows;
private function __construct() {}
static function getInstance()
{
if(!self::$instance)
{
self::$instance = new self();
}
return self::$instance;
}
// Create Connection to MySQL
function connect($dbhost, $dbuser, $dbpass, $dbname)
{
$this -> dbhost = $dbhost;
$this -> dbuser = $dbuser;
$this -> dbpass = $dbpass;
$this -> dbname = $dbname;
$this -> connection = mysqli_connect($this->dbhost, $this->dbuser, $this->dbpass, $this->dbname);
}
// Run Query
public function doQuery ($sql)
{
$this -> results = mysqli_query($this -> connection, $sql);
$this -> numRows = $this -> results -> num_rows;
}
// Load the list of data in database
public function loadObjectList()
{
$obj = 'No Results';
if ($this -> results)
{
$obj = mysqli_fetch_assoc($this -> results);
}
return $obj;
}
}
?>
پاسخ با نقل قول
