PHP how to display multiple array values

Question

How can I display array values that I retrieved from the database for example the following array values.

while($row = mysqli_fetch_array($query)){
    $post_id[] = $row['id'];
    $post_user_id[] = $row['user_id'];
    $post_title[] = $row['title'];
}

Output.

<li><a href="' . $post_user_id . 'post.php?id="' . $post_id . '">' . $post_title . '</a></li>
<li><a href="' . $post_user_id . 'post.php?id="' . $post_id . '">' . $post_title . '</a></li>
<li><a href="' . $post_user_id . 'post.php?id="' . $post_id . '">' . $post_title . '</a></li>
<li><a href="' . $post_user_id . 'post.php?id="' . $post_id . '">' . $post_title . '</a></li>
<li><a href="' . $post_user_id . 'post.php?id="' . $post_id . '">' . $post_title . '</a></li>

codaddict · Accepted Answer · 2010-08-30 08:33:00Z

2

You can do the following outside the while loop:

for($i=0;$i<count($post_id);$i++) {
    echo '<li><a href="'.$post_user_id[$i].'post.php?id='.$post_id[$i].'">'.$post_title[$i] . '</a></li>';
}

answered Aug 30, 2010 at 8:33

codaddict

457k83 gold badges501 silver badges537 bronze badges

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

5 Comments

Alex Pliutau Over a year ago

All your lines will be the same. Where $i?

Alex Pliutau Over a year ago

sizeof() more faster than count()

Alex Pliutau Over a year ago

Check this with firebug. Or you can read about operations speed on phpbench.com

Your Common Sense Over a year ago

@Alexander honestly, this site makes people totally misunderstood performance issues. It makes people think that difference between count() and sizeof() (if it really was, between just different names of single function) does matter anything. While it doesn't. And you are right with firebug. Just always test everything with firebug. When network latency involved, nothing of such a microoptimization could be noticeable. Trust me, no code itself does affect performance. Data manipulation does affect it.

deceze Over a year ago

@Alexander Shrapnel is right, but to put it in less aggressive terms: sizeof: Description: "This function is an alias of: count()." Please provide irrefutable proof that an alias of a function is faster than the function itself. Thank you. :)

Your Common Sense · Accepted Answer · 2010-08-30 08:43:05Z

1

<?
$data = array();
while($row = mysqli_fetch_array($query)){
  $data[] = $row;
}
?>

Output.

<? foreach ($data as $row): ?>
<li>
 <a href="<?=$row['post_user_id']?>post.php?id=<?=$row['post_id']?>">
  <?=$row['post_title']?>
 </a>
</li>
<? endforeach ?>

answered Aug 30, 2010 at 8:43

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Comments

Alex Pliutau · Accepted Answer · 2010-08-30 08:33:08Z

0

for ($i=0; $i<sizeof($post_id); $i++) {
   echo '<li><a href="' . $post_user_id[$i] . 'post.php?id=' . $post_id[$i] . '">' 
   . $post_title[$i] . '</a></li>';
}

answered Aug 30, 2010 at 8:33

Alex Pliutau

22k28 gold badges115 silver badges144 bronze badges

Comments

Tokk · Accepted Answer · 2010-08-30 08:35:37Z

0

while($row = mysqli_fetch_array($query)){
    $post_id = $row['id'];
    $post_user_id = $row['user_id'];
    $post_title = $row['title'];
    echo "<li><a href=\"" . $post_user_id . "post.php?id=" . $post_id . "\">" . $post_title . "</a></li>";
}

But in my Oppinion, the Links are not very well formated, you would need a [userid]post.php for each user. Better would be:

    echo "<li><a href=\""post.php?userid=\"".$post_user_id."\"&id=". $post_id ."\">" . $post_title . "</a></li>";

So your post.php gets the userid and the id per GET by clicking on the link.

edited Aug 30, 2010 at 8:35

answered Aug 30, 2010 at 8:30

Tokk

4,5223 gold badges35 silver badges48 bronze badges

2 Comments

ddb Over a year ago

I dont want to use it in the same while loop.

Alex Pliutau Over a year ago

$post_id[] is array. $post_id - is not array.

deceze · Accepted Answer · 2010-08-30 08:43:24Z

0

Instead of splitting up a database record (a row) across multiple variables, it's usually a better idea to keep them together in a multi-dimensional array like this:

$posts = array();

while ($row = mysqli_fetch_array($query)) {
    $posts[] = $row;
}

foreach ($posts as $post) {
    echo $post['id'];
    echo $post['user_id'];
    echo $post['title'];
    ...
}

answered Aug 30, 2010 at 8:43

deceze♦

525k89 gold badges806 silver badges954 bronze badges

Comments

makki · Accepted Answer · 2010-08-30 08:52:04Z

0

Better way would be

while($row = mysqli_fetch_array($query)){
   echo '<li><a href="' . $row['user_id'] . 'post.php?id="' . $row['id'] . '">' . $row['title'] . '</a></li>';
}

if you need the same output. But in my opinion the links are not well formed.

answered Aug 30, 2010 at 8:52

makki

2,1073 gold badges23 silver badges37 bronze badges

Collectives™ on Stack Overflow

PHP how to display multiple array values

6 Answers 6

5 Comments

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

5 Comments

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related