[ Milan M. Radovic @ 05.12.2009. 00:19 ] @
Kad pozivam proceduru preko PHP-a dobijam : command out of sync. Evo Coda moje klase za povezivanje sa MySQL bazom. Code: //----------------------------------- // 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! |