define('HOSTNAME', 'localhost');
define('USERNAME', 'root');
define('PASSWORD', '12321313213123');
define('DATABASE', 'gold');
class DB
{
private $dbLink;
private $result;
public function __construct()
{
$this->connect();
}
protected function connect()
{
$this->dbLink = mysqli_connect(HOSTNAME,USERNAME,PASSWORD,DATABASE);
}
public function query($sql)
{
$this->result = mysqli_query($this->dbLink, $sql);
}
public function fetch()
{
return mysqli_fetch_array($this->result);
}
public function close()
{
mysqli_close($this->dbLink);
}
}
$db = new DB();
$sql = "SELECT * FROM prices";
$db->query($sql);
while($x = $db->fetch())
{
print $x['buy'].',';
}
$db->close();
PHP ~ MySQL DB Class
訂閱:
發佈留言 (Atom)
沒有留言:
發佈留言