<?php
            namespace RccgPraiseCentreUser;


            class HomeMenu{
                public  $errorArray = array();

                private $db;

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



            //display all slider base on id
            public function bannerSlider($id){
                $query = $this->db->prepare("SELECT * FROM  slider_tbl WHERE id = ? LIMIT 1");
                $query->execute(array($id));
                if($query->rowCount()>0){
                $result = $query->fetch(PDO::FETCH_ASSOC);
                return $result;
                }else{
                    echo '<h2 style="color:white;">RCCG Praise Centre Area Headquater</h2>';
                }}

<?php
    include_once"includeFiles/dbconfig.php";

    require_once __DIR__.'/../vendor/autoload.php';
    use RccgPraiseCentreUserHomeMenu as HomeMenu;


    $object = new HomeMenu($db);
    echo $object->bannerSlider('1')['header_title'];

    ?>

<?php

    $DB_host = "localhost";
    $DB_user = "root";
    $DB_pass = "";
    $DB_name = "rccgpraisecentre";

    try
    {
        $db = new PDO("mysql:host={$DB_host};dbname={$DB_name}",$DB_user,$DB_pass);
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }
    catch(PDOException $e)
    {
        echo $e->getMessage();
    }