Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /**
- * Andmebaasi class.
- */
- class Database {
- private $user = 'aaa'; // Kasutajanimi
- private $pass = 'aaa'; // Parool
- private $server = 'localhost'; // MySQL server
- private $database = 'aaaa'; // Andmebaasi nimi
- private $con; // Ühendus andmebaasiga
- // Automaatselt connectib andmebaasiga peale objekti teket
- function __construct() {
- $this->con = mysql_connect($this->server, $this->user, $this->pass);
- if(!$this->con) {
- die('Mysql ühendus ebaõnnestus: ' . mysql_error());
- } else {
- $dbSelect = mysql_select_db($this->database, $this->con);
- if(!$dbSelect) {
- die('Andmebaasi valik ebaõnnestus: ' . mysql_error());
- }
- }
- }
- // Andmebaasi ühenduse sulgemine
- public function closeCon() {
- if(isset($this->con)) {
- mysql_close($this->con);
- unset($this->con);
- }
- }
- // Andmebaasi päringu tegemine
- public function query($sql) {
- $result = mysql_query($sql, $this->con);
- if(!$result) {
- die('Päring ebaõnnestus: ' . mysql_error());
- }
- return $result;
- }
- // Valmistab andmebaasi jaoks
- public function escVal($value) {
- $value = mysql_real_escape_string($value);
- return $value;
- }
- // Teeb andmebaasist tuleva data kasutatavaks
- public function fetchArray($result) {
- return mysql_fetch_array($result);
- }
- // Annab andmebaasi päringu ridade arvu
- public function numRows($result) {
- return mysql_num_rows($result);
- }
- }
- // Tekitab db objekti automaatselt, kui db_class.php kuhugi tiritakse
- $db = new Database();
Add Comment
Please, Sign In to add comment