功能中的多个数组不使用php mysql显示在结果中

Question

I need to print/show list of comments for articles using this PHP function:

function _is_comments_($id,$type){

    $db = mysqli_access::F("SELECT message FROM " . COMMENTS . " WHERE pid = ? AND type = ? AND approved = 1 ", $id, $type);

    foreach($db as $row){
      $commentdata['message'] = $row['message'];
    }
    return $commentdata;
}   

In action :

$comments_list = _is_comments_('125','article');
print_r($comments_list);

In result : Array ( [message] => this is a One comment )

But in MySQL database I have 18 comments for article id 125 and my result is false and show only One result!

how do fix This ?!

Answer 1

Your issue is the assignment in the loop here:

foreach($db as $row){
  $commentdata['message'] = $row['message'];
}

Even if you got multiple result $rows, each iteration would overwrite the same $commentdata['message'] key. Which is why you only get to see one entry when returned from the function.

Instead you want to collect multiple entries. I would just drop the ['message'] key, and use an additive indexed array:

foreach($db as $row){
  $commentdata[] = $row['message'];
}

This way your result array might contain:

 Array (
    [0] => this is a One comment
    [1] => this is a second comment
    [2] => third one
)