PHP Execute array multple times on the one page

Question

I want to run two seperate foreach loops on the one page, but only write my SQL once. For example see the below code, only the ul with the id of first runs, the second ul is empty.

    <?php
        $mylist = 'SELECT * FROM myTable';
        $showlist = $pdo->prepare($mylist);
        $showlist->execute();
    ?>  
    <ul id="first">
        <?php foreach ($showlist as $rowid):;?>
            <li><?php echo $rowid['id'] ?></li>
        <?php endforeach; ?>  
    </ul>
    <ul id="second">
        <?php foreach ($showlist as $rowname):;?>
            <li><?php echo $rowname['name'] ?></li>
        <?php endforeach; ?>  
    </ul>

I thought renaming the as would allow me to use it again but this doesn't seem to be the case? What is the best approach here?

Possible duplicate of stackoverflow.com/questions/278259/… — Alma Do
– Alma Do, Commented Aug 13, 2013 at 10:26
@AlmaDoMundo fair call re being a duplicate. I think the two answers here are better than the other site though in terms of giving an example of how to get this working? — ak85
– ak85, Commented Aug 13, 2013 at 10:37

thelastshadow · Accepted Answer · 2013-08-13 10:29:01Z

2

try:

<?php
$mylist = 'SELECT * FROM myTable';
$showlist = $pdo->prepare($mylist);
$showlist->execute();
$result = $showlist->fetchAll();

foreach ($result as $rowid) {
    // do stuff
}

foreach ($result as $rowname) {
    // do stuff
}

answered Aug 13, 2013 at 10:29

thelastshadow

3,6604 gold badges37 silver badges37 bronze badges

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

Comments

Julian F. Weinert · Accepted Answer · 2013-08-13 10:31:29Z

1

You'd need to stack your elements in an extra array first:

$mylist = 'SELECT * FROM myTable';
$showlist = $pdo->prepare($mylist);
$showlist->execute();

$rows = array();

foreach($showlist as $row) {
    array_push($rows, $row);
}

echo "<ul>";
foreach($rows as $row) {
    echo "<li>".$row['id']."</li>";
}
echo "</ul><ul>";
foreach($rows as $row) {
    echo "<li>".$row['name']."</li>";
}
echo "</ul>";

answered Aug 13, 2013 at 10:31

Julian F. Weinert

7,5808 gold badges67 silver badges109 bronze badges

Collectives™ on Stack Overflow

PHP Execute array multple times on the one page

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related