While loop Mysqli doesn't save in array

Question

I am using Class and function, trying to send data from mysqli while loop to public $post=array(); in Class,

I dunno why while loop only save last data from mysqli

Code

class Post extends Connection{

        public $post=array();

        function selectPost(){
            $query="select * from posts";
            $mysqli=$this -> connect();
            $select_all_post=$mysqli->query($query);
            $x=1;
            while($row=$select_all_post->fetch_object()){  
                $this->post = array( 'Post No   ' . $x=> array(
                    'post_title' => $row->post_title,
                    'post_author' => $row->post_author,
                    'post_date' => $row->post_date,
                    'post_content' => $row->post_content
                ));
                $x++;
            }
            echo print_r($this->post);
        }
    }

if im trying to use [] at post array, it works but it make new array Check Output

$this->post[] = array( 'Post No   ' . $x=> array(
                        'post_title' => $row->post_title,
                        'post_author' => $row->post_author,
                        'post_date' => $row->post_date,
                        'post_content' => $row->post_content
                    ));

My question, how to send all data from mysqli using while loop to array in Class?

Like This

scrowler · Accepted Answer · 2016-11-22 03:34:31Z

2

Just use the post number as the array key on your class property $this->post instead of indexing a new array each time:

$this->post['Post No ' . $x] = array(
    'post_title' => $row->post_title,
    'post_author' => $row->post_author,
    'post_date' => $row->post_date,
    'post_content' => $row->post_content
);

answered Nov 22, 2016 at 3:34

scrowler

24.4k10 gold badges67 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kent Aguilar · Accepted Answer · 2016-11-22 03:53:01Z

1

Since you're using $this->post = array(.... After your while loop, the last assigned value is the last record of your query.

I'm not sure how you're going to perform your saving on this. I assume that after you have your posts collection, then you will loop on it and that's where you will perform the insertion right?.

Anyhow, considering your code, you can use array_push. Like so,

array_push($post, array( 'Post No ' . $x=> array(
        'post_title' => $row->post_title,
        'post_author' => $row->post_author,
        'post_date' => $row->post_date,
        'post_content' => $row->post_content
    )));

answered Nov 22, 2016 at 3:53

Kent Aguilar

5,4081 gold badge36 silver badges21 bronze badges

1 Comment

scrowler Over a year ago

This is just a slightly longer version of the second part of what he has tried already

Collectives™ on Stack Overflow

While loop Mysqli doesn't save in array

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related