Пишет:
Warning: mysql_query() expects parameter 2 to be resource, null given in Z:\home\localhost\www\1\config\db.php on line 20
error3
config/config.php
<?php
class config {
var $BASE_URL = "localhost";
var $DB_HOST = "localhost";
var $DB_USER = "andr";
var $DB_PASS = "1111";
var $DB_NAME = "and";
}
?>
config/db.php
<?php
require_once "config.php";
class db extends config {
private $connection;
function __construct(){
$this->open_connection;}
private function open_connection(){
$this->connection=mysql_connect($this->DB_HOST,$this->DB_USER,$this->DB_PASS);
if(!$this->connection){
die ("error1".mysql_error());
} else {
$db_select=mysql_select_db($this->DB_NAME);
if(!$db_select){
die("error2".mysql_error());
}
}
mysql_query("set names utf8") or die ("set names utf8 failed");
}
public function sql($query){
$result=mysql_query($query,$this->connection);
if(!$result){
die ("error3".mysql_error());}
return $result;}
}
$db= new db();
?>
models/mmenu.php
<?php
require_once "../config/db.php";
class mmenu extends db{
function return_menu(){
$sql="select id, menu_name from pages";
$res=$this->sql($sql);
return $res;
}
}
controllers/cmenu.php
<?php
require_once "../models/mmenu.php";
class cmenu extends mmenu{
function print_menu(){
$res=$this->return_menu();
while ($row=mysql_fetch_array($res)){
$mname[$row['id']]=$row['menu_name'];
}
return $mname;
}
}
?>
?>
views/vmenu.php
<?php
require_once "../controllers/cmenu.php";
$menu=new cmenu();
$aux=$menu->print_menu();
foreach($aux as $uri => $link){
echo "<a href=\"{menu->BASE_URL}/index.php?id={$uri}\">{$link}</a><br>";
}
?>