Dali mi neko može reći jel dobra ova klasa?
<?php
class database
{
private $link;
function __construct($host, $user, $password, $base_name, $character_set)
{
$this->link = @mysql_connect($host, $user, $password)
or die($this->error());
mysql_select_db($base_name, $this->link)
or die($this->error());
mysql_set_charset($character_set, $this->link);
}
function __destruct()
{
mysql_close($this->link);
}
private function error()
{
return mysql_error($this->link);
}
public function query($sql, $return_format = 0)
{
$query = mysql_query($sql, $this->link)
or die($this->error());
switch($return_format)
{
case 1:
$query = mysql_fetch_row($query);
return $query;
break;
case 2:
$query = mysql_fetch_array($query);
return $query;
break;
case 3:
$query = mysql_fetch_row($query);
$query = $query[0];
return $query;
break;
default:
return $query;
break;
}
}
}
?>
<?php
$db = new database('localhost', 'root', '', 'test', 'utf8');
$i = $db->query("SELECT `id_user` FROM `users` WHERE `id_user` = 1 ", 2);
echo $i['id_user'];
?>
sve radi kako treba, samo me zanima dali je ovo ispravno oop?
Hvala!