mysqli_fetch_array while loop columns [duplicate]

Question

Should be pretty basic, but I can't get it to work. I have this code to iterate over a mysqli query:

while($row = mysqli_fetch_array($result)) {
    $posts[] = $row['post_id'].$row['post_title'].$row['content'];
}

It works and returns:

Variable #1: (Array, 3 elements) ↵ 0 (String): "4testtest" (9 characters) 1 (String): "1Hello world!Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!" (99 characters) 2 (String): "2Sample PageThis is an example page. It's different from a blog post because it will stay in one place and will show up in your site navigation (in most themes)." (161 characters)

The problem is that it puts all three colums into one column, so I can't access them seperatly.

This for example:

0 (String): "4testtest" (9 characters)

Should be seperated into 4, test, test

When I do this:

while($row = mysqli_fetch_array($result)) {             
    $posts['post_id'] = $row['post_id'];
    $posts['post_title'] = $row['post_title'];
    $posts['type'] = $row['type'];
    $posts['author'] = $row['author'];  
}

It only outputs 1 row instead of all three …

Any help is greatly appreciated!

<?php foreach ($posts as $post): ?> <?php echo $post_id; ?> <?php echo $post_title; ?> <?php echo $type; ?> <?php echo $author; ?> <?php endforeach; ?> — Sebastian
– Sebastian, Commented Jan 22, 2013 at 10:42
Also check procedural while loop example in php.net/manual/en/mysqli-result.fetch-assoc.php and php.net/manual/en/mysqli-result.fetch-array.php — Clark Superman
– Clark Superman, Commented Sep 26, 2014 at 9:00

Ricardo Ortega Magaña · Accepted Answer · 2022-12-16 19:16:27Z

28

Get all the values from MySQL:

    $post = array();
    while($row = mysqli_fetch_array($result))
    {
        $posts[] = $row;
    }

Then, to get each value:

<?php 
     foreach ($posts as $row) 
        { 
            foreach ($row as $element)
            {
                echo $element."<br>";
            }
        }
?>

To echo the values. Or get each element from the $post variable

edited Dec 16, 2022 at 19:16

answered Jan 22, 2013 at 10:41

Ricardo Ortega Magaña

2,44219 silver badges23 bronze badges

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

2 Comments

Your Common Sense Over a year ago

Although your code is nearest to a proper one, you really need to be more consistent in naming...

Albuquerque Web Design Over a year ago

The question was for MYSQLI - php7 vs php5

Nigel Ren · Accepted Answer · 2017-07-26 06:00:14Z

7

This one was your solution.

$x = 0;
while($row = mysqli_fetch_array($result)) {             
    $posts[$x]['post_id'] = $row['post_id'];
    $posts[$x]['post_title'] = $row['post_title'];
    $posts[$x]['type'] = $row['type'];
    $posts[$x]['author'] = $row['author'];
    $x++;
}

edited Jul 26, 2017 at 6:00

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

answered Feb 26, 2016 at 12:29

Bogdan Lozyak

871 silver badge1 bronze badge

Comments

05beckga · Accepted Answer · 2016-02-01 10:35:13Z

5

I think this would be a more simpler way of outputting your results.

Sorry for using my own data should be easy to replace .

$query = "SELECT * FROM category ";

$result = mysqli_query($connection, $query);


    while($row = mysqli_fetch_assoc($result))
    {
        $cat_id = $row['cat_id'];
        $cat_title = $row['cat_title'];

        echo $cat_id . " " . $cat_title  ."<br>";
    }

This would output :

-ID Title
-1 Gary
-2 John
-3 Michaels

answered Feb 1, 2016 at 10:35

05beckga

952 silver badges9 bronze badges

Comments

Elangovan · Accepted Answer · 2017-02-13 10:46:44Z

1

Both will works perfectly in mysqli_fetch_array in while loops

while($row = mysqli_fetch_array($result,MYSQLI_BOTH)) {
    $posts[] = $row['post_id'].$row['post_title'].$row['content'];
}

(OR)

while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) {
    $posts[] = $row['post_id'].$row['post_title'].$row['content'];
}

mysqli_fetch_array() - has second argument $resulttype.

MYSQLI_ASSOC: Fetch associative array

MYSQLI_NUM: Fetch numeric array

MYSQLI_BOTH: Fetch both associative and numeric array.

answered Feb 13, 2017 at 10:46

Elangovan

3,6184 gold badges34 silver badges39 bronze badges

1 Comment

Elangovan Over a year ago

It is real time example and it is working perfectly for above mentioned code, then why you are given negative rating. If you used above code and anything fails means just reported me, this is reason and gave negative.

Fero · Accepted Answer · 2013-01-22 10:41:47Z

-2

Try this :

   $i = 0;    
    while($row = mysqli_fetch_array($result)) {  

            $posts['post_id'] = $row[$i]['post_id'];
            $posts['post_title'] = $row[$i]['post_title'];
            $posts['type'] = $row[$i]['type'];
            $posts['author'] = $row[$i]['author'];  

        }   
    $i++;
    }

print_r($posts);

answered Jan 22, 2013 at 10:41

Fero

13.3k46 gold badges119 silver badges159 bronze badges

Comments

Jose Ricardo Bustos M. · Accepted Answer · 2015-10-28 23:07:32Z

-3

Try this...

while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {

edited Oct 28, 2015 at 23:07

Jose Ricardo Bustos M.

8,1847 gold badges44 silver badges66 bronze badges

answered Oct 28, 2015 at 22:50

Pepito Rosales

1

2 Comments

Parixit Over a year ago

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.

Anders Over a year ago

@Parixit Looks like an answer to me? Not sure if it is correct or not, but that is not important for the review.

Collectives™ on Stack Overflow

mysqli_fetch_array while loop columns [duplicate]

6 Answers 6

2 Comments

Comments

Comments

1 Comment

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

Comments

1 Comment

Comments

2 Comments

Linked

Related