Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

PHP Integrating PHP with Databases Querying the Database with PHP Working with Results

Posted by Gerry Tarney
Gerry Tarney
3,970 Points

I don't see this in video at all. How do I loop through results and send to function?

Not sure where to begin. This wasn't mentioned in the video. ... Loop through results and pass to the send_offer function...

index.php 
<?php
include "helper.php";

try {
    $results = $db->query(
        "SELECT member_id, email, fullname, level FROM members"
    );
} catch (Exception $e) {
    echo $e->getMessage();
}
//add code below this line

2 Answers

Jeffrey van Rossum
Jeffrey van Rossum
2,994 Points

You can loop through the results using the foreach function, like this:

<?php

//add code below this line
foreach ( $results as $member ) {
   // function with the arguments from the member
   send_offer( $member['member_id'], $member['email'], $member['fullname'], $member['level']  );
}
Gerry Tarney
Gerry Tarney
3,970 Points
Gerry Tarney
Gerry Tarney
3,970 Points

Thank you!