okay i trying to this to working in classes i have but i getting
Fatal error: Call to a member function show_naviBar() on a non-object in /home/content/j/m/c/jmcrews/html/animesite/index.php on line 6
Site
Click Here
Database Class:
<?
include("constants.php");
class MySQLDB
{
var $connection; //The MySQL database connection
var $num_active_users; //Number of active users viewing site
var $num_active_guests; //Number of active guests viewing site
var $num_members; //Number of signed-up users
/* Note: call getNumMembers() to access $num_members! */
/* Class constructor */
function MySQLDB(){
/* Make connection to database */
$this->connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die(mysql_error());
mysql_select_db(DB_NAME, $this->connection) or die(mysql_error());
/**
* Only query database to find out number of members
* when getNumMembers() is called for the first time,
* until then, default value set.
*/
$this->num_members = -1;
if(TRACK_VISITORS){
/* Calculate number of users at site */
$this->calcNumActiveUsers();
/* Calculate number of guests at site */
$this->calcNumActiveGuests();
}
}
function buildTNB() {
$q = "SELECT Title, Address FROM top_navibar";
$result = mysql_query($q, $this->connection);
$topnavibar = array();
while ($row = mysql_fetch_assoc($result)) {
$topnavibar[] = $row;
}
return $topnavibar;
}
//removed all working functions
};
/* Create database connection */
$database = new MySQLDB;
?>
New class:
<?
class display {
function display()
{
$this->display = new display();
}
function show_naviBar() {
echo "<div id='slatenav'>
<ul>";
foreach ($database->buildTNB() as $topnavibar) {
echo "<li><a href='" . htmlspecialchars($topnavibar['Address']) . "'> ". htmlspecialchars($topnavibar['Title']) . "</a></li>";
}
echo "</ul> </div>";
}
}
?>
Code on index.php:
<?php
require_once "header.php";
?>
<div id="wrapper">
<div id="header">This is the Header</div>
<div id="navigation"><? $display->show_naviBar();?></div>
<div id="leftcolumn"></div>
<div id="rightcolumn"></div>
<?php
require_once "footer.php";
?>