Evo Coda moje klase za povezivanje sa MySQL bazom.
//-----------------------------------
// Klasa MySQL
//-----------------------------------
class MySQL {
private $link;
public $requests;
public function __construct()
{
$this->Connect();
$this->requests=0;
}
public function __destruct()
{
$this->Disconnect();
}
public function Connect()
{
global $sql_hostname,$sql_port, $sql_username, $sql_password, $sql_database;
$this->link=mysql_connect($sql_hostname.":".$sql_port, $sql_username, $sql_password,TRUE, 131074) or $this->error();
mysql_select_db($sql_database,$this->link) or $this->error();
}
public function Disconnect()
{
mysql_close($this->link);
}
public function SelectQuery($str)
{
$results = mysql_query($str,$this->link) ;
$data = Array();
while($row = mysql_fetch_array($results))
{
$data[] = $row;
}
$this->requests++;
return $data;
}
public function Query($str)
{
mysql_query($str,$this->link) ;
$this->requests++;
}
public function Rows($str)
{
$ressult = mysql_query($str,$this->link);
$this->requests++; ;
return mysql_num_rows($ressult) ;
}
public function Error()
{
return "MySQL/PHP greska ". mysql_errno($this->link) ." : " . mysql_error($this->link);
}
public function LastId()
{
return mysql_insert_id($this->link);
}
};
HEEELP!