Multidimensional array retriving (OOP)

Question

Hello, i have two classes (Database for queries over database) and News for manipulating articles. On index.php (could be any other page) i call News class, which calls Database class. Everything goes ok, until i have to display result on index.php.

Let's say, i save result in $news in News class. How should i retrieve that array in index.php (like return $this->news or something else??). And how to display?

Could someone help.

Answer 1

On index.php (could be any other page) i call News class, which calls Database class.

You don't "call classes". You call methods of classes.

Let's say, i save result in $news in News class.

I suppose you mean you have a field (also property in PHP) names news, as in:

class News {
    private $news;
    /* ... */
}

How should i retrieve that array in index.php (like return $this->news or something else??)

You could add a method in News that returned this array:

class News {
    private $news;
    function retrieveNews() {
        /* query the DB and store the result in $this->news */
    }
    function getData() { return $this->news; }
}

Or you could make it public and access it directly through $newsObject->news (not recommended).

And how to display?

That depends on the structure of the data and how you want to display it.

Answer 2

class Database{ // database.php function news($user_id){ $q="select all from news where author id='$id'"; $result=$db->query($q); for($i=0; $inum_rows; $i++){
$arr[]=$result->fetch_array;
} return $arr; }}

class News{              //  news.php
function get_news($user_id){
$news=$db->news($user_id);
return $news;
}}

index.php  // problem how to display
$post=new News;
$post->get_news($user_id);
for($i=0; $i<5; $i++){
    foreach($post[$i] as $k=>$v){
       echo $v;         //get error: "Cannot use object of type News as array in ..."
}}