Třída k připojení do mysql

class Db {
    var $global_link;

    public function connect($host, $user, $password, $database_name) {
        $link = mysql_connect($host,$user,$password) or die("<b>Nelze se připojit k MySQL:</b> " . mysql_error());
        mysql_select_db($database_name) or die("<b>Nelze vybrat databázi:</b> ". mysql_error());
        mysql_query("set names utf8");
        $this->global_link = $link;
    }

    public function close() {
        return mysql_close($this->global_link);
    }

    public function query($command) {
        return mysql_query($command, $this->global_link) or die('<b>MySQL chyba:</b> '.mysql_error());
    }

    public function fetch($command) {
        return mysql_fetch_array($command);
    }
    
    public function count($command) {
        return mysql_num_rows($command);
    }
}

$db = new Db;
$db->connect("localhost","root","root","remeslnici");
$obory = $db->query("SELECT * FROM remeslo_obory");
$obory_array = $db->fetch($obory);
echo $obory_array[0];
$db->close();