PHP Shopping Cart with PayPal, OOP & MVC video 12, Categories object: part 1

[Domagoj]

Hello im getting this error:

Fatal error: Uncaught Error: Call to a member function prepare() on null in D:\wamp\www\shop\app\models\m_categories.php on line 35

here is my code for m_categories.php

<?php
/*
    Categories
    Handles all tasks related to retrieving and displaying categories
*/

class Categories
{
    private $Database;
    private $db_table='categories';

    function __construct()
    {
        global $Database;
        $this->Database=$Database;
    }

    /*
        Settting/Getting categories from database
    */

    /**
     * Return an array with category information
     * 
     * @access public
     * @param   int(optional)
     * @return array
     */
    public function get_categories($id=NULL)
    {
        $data=array();
        if($id != NULL)
        {
            // get specific category
            if($stmt=$this->Database->prepare("SELECT id, name FROM" . $this->db_table . " WHERE id=? LIMIT 1"))
            {
                $stmt->bind_param("i", $id);
                $stmt->execute();
                $stmt->store_result();

                $stmt->bind_result($cat_id,$cat_name);
                $stmt->fetch();

                if($stmt->num_rows > 0)
                {
                    $data=array('id'=>$cat_id, 'name'=>$cat_name);
                }
                $stmt->close();

            }
        }
        else
        {
            // get all categories
            if($result=$this->Database->query("SELECT * FROM" . $this->db_table . "ORDER BY name"))
            {
                if($result->num_rows>0)
                {
                    while($row=$result->fetch_array())
                    {
                        $data[]=array('id'=>$row['id'], 'name'=>$row['name']);
                    }
                }
            }
        }
        return $data;
    }

}

?>

and init.php

<?php
/*

    INIT
    Basic configuration settings

*/

// connect to database
$server='localhost';
$user='root';
$pass='';
$db='shop';

$database=new mysqli($server,$user,$pass,$db);

// error reporting
mysqli_report(MYSQLI_REPORT_ERROR);
ini_set('display_errors', 1);

// setup constants
define('SITE_NAME', 'Online Store');
define('SITE_PATH','http://shop/');
define('IMAGE_PATH','http://shop/resources/images/');

// include objects
include('app/models/m_template.php');
include('app/models/m_categories.php');

// create objects

$template= new Template();
$categories= new Categories();


session_start();

and index.php:

<?php

include('app/init.php');

echo "<pre>";
print_r($categories->get_categories(3));
echo "</pre>";

/*$template->set_data('header','hello');
$template->set_alert('alert!');
$template->load('app/views/v_public_home.php', 'Welcome!');*/
 ?>

Thank you in advance.

[administrator]

Sounds like you are not properly declaring a variable.