OOP PHP with MySQLi
- From: "Citrus" <info@xxxxxxxxx>
- Date: Tue, 31 Jan 2006 15:04:17 +0100
Hey, i'm looking for the best possible way for connecting to my database
without too much of an effort.
The example works fine and fast. What i need to know is if it's safe, stable
and the way to go. If anyone has a better way for connecting side-wide to
something i'd like you to show me. I've had it working before using 'global'
but people told me 'global' is bad programming.
One of the possibilities would be to make the link and pass it on to every
function and object but this is NOT an option because it makes my script
less transparant and easy to read.
<?php
class My {
private static $connection;
function SQL() {
if(empty(self::$connection)) {
self::$connection = new mysqli("localhost", "user", "password", "db");
}
return self::$connection;
}
}
class User {
function __construct() {
echo "user init<p>";
}
public function show() {
$query = My::SQL()->query("SELECT * FROM user");
while($row = $query->fetch_object()) {
echo $row->login."<p>";
}
}
}
$user = new User();
$user->show();
//Works here too
$query = My::SQL()->query("SELECT * FROM user");
while($row = $query->fetch_object()) {
echo $row->login."<p>";
}
?>
.
- Follow-Ups:
- Re: OOP PHP with MySQLi
- From: Erwin Moller
- Re: OOP PHP with MySQLi
- Prev by Date: Re: php as cgi
- Next by Date: Re: OOP PHP with MySQLi
- Previous by thread: Big Integers ?
- Next by thread: Re: OOP PHP with MySQLi
- Index(es):
Relevant Pages
|
