Tu plik lrclass.php
<?php //----------------------------------------------------------- //- Klasa rotatora linków - //----------------------------------------------------------- class lr { private function db() { $this->dbhost = "localhost"; $this->dbname = "lr"; $this->dbuser = "lg"; $this->dbpass = "lgpass"; $conn = new mysqli($this->dbhost, $this->dbuser, $this->dbpass, $this->dbname); return $conn; } public function lr() { } public function GetConfig() { // funkcja pobiera i zwraca tabel? config $db = $this->db(); $query = $db->query("SELECT * FROM config"); $result = $query->fetch_assoc(); return $result; } public function GetLinks() { $db = $this->db(); $query = $db->query("SELECT * FROM links"); $result = $query->fetch_assoc(); return $result; } } ?>
adminclass.php
<?php //----------------------------------------------------------- //- Klasa panelu administracyjnego - //----------------------------------------------------------- require_once("lrclass.php"); class admin extends lr { var $admin; public function admin() { if(self::IsAdmin()) { if($_GET['action'] == 'logout') { self::StopAdminSession(); } }else{ if($_GET['login'] && $_GET['pass']) { if(self::login($_GET['login'], $_GET['pass'])) { }else{ } }else{ } } } public function login($login, $pass) { $this->adminlogin = self::GetAdminLogin(); $this->adminpass = self::GetAdminPass(); if($login == $this->adminlogin && $pass == $this->adminpass) { self::StartAdminSession(); return TRUE; }else{ return FALSE; } } public function StartAdminSession() { $_SESSION['login'] = TRUE; } public function StopAdminSession() { } public function GetAdminLogin() { $db = parent::db(); $query = $db->query("SELECT value FROM config where name='adminlogin'"); $result = $query->fetch_object(); $result = $result->value; return $result; } public function GetAdminPass() { $db = parent::db(); $query = $db->query("SELECT value FROM config where name='adminpass'"); $result = $query->fetch_object(); $result = $result->value;; return $result; } public function IsAdmin() { if($_SESSION['login']){ return TRUE; }else{ return FALSE; } } } ?>
W klasie lr jest funkcja db(), czy to jest dobry pomysł żeby ją tam umieszczać? Może lepszym wyjściem byłaby osobna klasa do łączenia z bazą? Naprawdę teoretycznie trochę wiem, ale w praktyce wymiękam hah
