php foreach outside the function

Question

i'm learning php.

i have a function with mysql query select.

than i use it with foreach list..

but it work me only if the foreach is inside the function. i don't know how to get it work outside the function..

what i'm doing wrong?

working code - https://phpbox.info/d3GCP

no working code:

function volaco ()
{
$query = $db->getQuery(true);

$query = "select a.id, count(i.id) as all_items, a.name,  SUM(i.state = '1') published, SUM(i.state = '0') unpublished"
    . " FROM item as i"
    . " JOIN application a ON a.id = i.application_id"
    . " group by i.application_id";

$db->setQuery($query);

$apps= $db->loadObjectList();

}

$apps = volaco();
?>

    <table >
        <?php if (count($apps)) : foreach ($apps as $app) : ?>
            <tr >
                <td  width="40%"><?php echo $app->name; ?></td>
                <td  width="20%" style="text-align: center;"><?php echo $app->all_items;?></td>
                <td  width="20%" style="text-align: center;"><?php echo $app->published; ?></td>
                <td  width="20%" style="text-align: center;"><?php echo $app->unpublished; ?></td>
            </tr>
        <?php endforeach; else : ?>
<?php endif; ?>
    </table>

thanks a lot

return results form your function then you can get it like $apps = volaco(); — Akshay
– Akshay, Commented Sep 15, 2015 at 12:11

Saty · Accepted Answer · 2015-09-15 12:06:59Z

1

You function volaco() need return type

return $apps= $db->loadObjectList();

Read Returning values

answered Sep 15, 2015 at 12:06

Saty

22.5k7 gold badges35 silver badges52 bronze badges

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

Comments

Yuri Blanc · Accepted Answer · 2015-09-15 12:20:01Z

0

Add a return to your volaco() function, $apps is out of the scope.

function volaco ()
        {
        $query = $db->getQuery(true);

        $query = "select a.id, count(i.id) as all_items, a.name,  SUM(i.state = '1') published, SUM(i.state = '0') unpublished"
            . " FROM item as i"
            . " JOIN application a ON a.id = i.application_id"
            . " group by i.application_id";

        $db->setQuery($query);

        return $db->loadObjectList();
        ?>

answered Sep 15, 2015 at 12:20

Yuri Blanc

64510 silver badges25 bronze badges

Comments

vipul sorathiya · Accepted Answer · 2015-09-15 12:23:15Z

Try this:

function volaco ()
{
$query = $db->getQuery(true);

$query = "select a.id, count(i.id) as all_items, a.name,  SUM(i.state = '1') published, SUM(i.state = '0') unpublished"
    . " FROM item as i"
    . " JOIN application a ON a.id = i.application_id"
    . " group by i.application_id";

$db->setQuery($query);

$apps= $db->loadObjectList();
return $apps; 

}

$apps = volaco();
?>

    <table >
        <?php if (count($apps)) : foreach ($apps as $app) : ?>
            <tr >
                <td  width="40%"><?php echo $app->name; ?></td>
                <td  width="20%" style="text-align: center;"><?php echo $app->all_items;?></td>
                <td  width="20%" style="text-align: center;"><?php echo $app->published; ?></td>
                <td  width="20%" style="text-align: center;"><?php echo $app->unpublished; ?></td>
            </tr>
        <?php endforeach; else : ?>
<?php endif; ?>
    </table>

Collectives™ on Stack Overflow

php foreach outside the function

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related