Ben OOP yeni ve ben bunun üzerine bir kavrayışa almak için çalışıyorum. Ne yapmaya çalışıyorum tablodaki verilerin tümünü geri olduğunu. Orada sadece 2 satır şu anda, ama ben bir dizideki tüm veri koymak ve daha sonra $ sonuçları değişken tüm yolu geri dönmek için nasıl emin değilim.

Lütfen yardım edin.

<?php
include('dates.php');

$events = new dates();
echo $events->getNumberEvents(); <-----returns the number of rows in the table (Works as expected)

$results = $events->getRows(); <------Doesn't work.

?>

Class Tarihler

<?php
/********************************************
* Class to connect and get dates from a database 
*********************************************/
require 'phpDatabaseClass.php';

class dates{

    private $db;
    private $arr2 = array();

    /****************************
    * Constructor which creates the $db variable
    ****************************/
    function __construct() 
    {
        $this->db = new phpDatabaseClass();
    }   

    /****************************
    * Function which calls the database class and returns the number of rows
    ****************************/
    public function getNumberEvents()
    {   
        $sql = "select count(*) from events";           
        return $this->db->queryNumber($sql);
    }

    /****************************
    * Function which calls the database class and returns the actual rows
    ****************************/
    public function getRows() 
    {
        $sql = "select * from events";

        $this->arr2 = $this->db->queryString($sql);

        foreach($this->arr2 as $key=>$val)
        {
            //$this->arr2 = $val;
            //echo $val;    
        }

    }
}
?>

phpDatabaseClass

<?php
/********************************************
* Class to connect and query a mysql database 
*********************************************/
require 'config.php';

class phpDatabaseClass {

    private $db;
    private $arr = array();

    /****************************
    * Constructor function which makes the connection to the database
    ****************************/
    public function __construct()
    {
        try 
        {
            $this->db = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME, DB_USERNAME, DB_PASSWORD);
        }
        catch(PDOexception $e)
        {
            echo 'Can\'t connect to database. Please contact the site administrator';
        }
    }

    /****************************
    * Function which returns the number of rows
    ****************************/
    public function queryNumber($sql)
    {                           
        $stmt = $this->db->prepare($sql);
        $stmt->execute();
        $resultsCount = $stmt->fetchColumn();

        return $resultsCount;
    }


    /****************************
    * Function which returns the data in the rows
    ****************************/
    public function queryString($sql)
    {                           
        $stmt = $this->db->prepare($sql);

        $stmt->execute();

        $results = $stmt->fetch(PDO::FETCH_ASSOC);

        foreach($results as $key=>$val)
        {
            $this->arr = $val;
            //echo $this->arr;
        }

        return array($this->arr);
    }
}
?>