WhiteSK 0 Odesláno: 9. Srpen, 2012 Share Odesláno: 9. Srpen, 2012 Predstavujem vám triedu MySQL pre zjednodušenie práce s MySQL. Zatiaľ je vo verzii Beta (1.0). Čoskoro urobím ďalšie verzie.. Chyby mi nahláste sem alebo do PM. Ďakujem. <?php Class MySQL_DB { private $conn; private $db; public $lasterror; public $lastquery; // Pripojeni public function MySQL_DB($hostitel,$uzivatel,$heslo,$databaze) { /* Pripojime se */ $this->conn = mysql_connect($hostitel,$uzivatel,$heslo); /* Overeni */ if($this->conn == false) { $this->error('Pripojenie zlyhalo. ('.mysql_error().')'); return false; } /* Vybereme DB */ $this->db = mysql_select_db($databaze, $this->conn); /* Overeni */ if($this->db == false) { $this->error('Vybratie databazy zlyhalo. ('.mysql_error().')'); return false; } /* Vsechno v poradku */ return true; } public function Disconnect() { mysql_close($this->conn); } private function error($msg) { $this->lasterror = $msg; die($msg); return false; } public function query($sql, $error = true) { $this->lastquery = mysql_query($sql, $this->conn); if($this->lastquery == false) { if($error == true) $this->error('Query neuspesne'); return false; } else { return $this->lastquery; } } public function num($query) { if($query == false) return false; else return mysql_num_rows($query); } public function fetch($query, $typ='array') { if($query == false) return false; else { switch($typ): case 'array': return mysql_fetch_array($query); break; case 'row': return mysql_fetch_row($query); break; case 'object': return mysql_fetch_object($query); break; default: return false; break; endswitch; } } } /* --------- POUZITI ----------- */ $db = new MySQL_DB('hostitel','uzivatel','heslo','databaze'); $query = $db->query("SELECT * FROM tabulka"); while($row = $db->fetch($query)) { echo $row['id'].PHP_EOL; } $db->Disconnect(); Link to comment Share on other sites More sharing options...
7.Host 3 Odesláno: 9. Srpen, 2012 Share Odesláno: 9. Srpen, 2012 A v čem je lepší než například mysqli? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now