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

Gergő Endrész
Gergő Endrész
7,169 Points
Posted by Gergő Endrész
Gergő Endrész
7,169 Points

I think this new course element is not perfect yet. If anyone succeeded in passing this, please, let me know.

Note: note even the preview function works. I tried to figure out what is in the helper.php file by file_get_contents, but not even a simple echo command works.

index.php 
<?php
include "helper.php";
echo file_get_contents("helper.php");

/* 
 * helper.php contains
 * $results->query("SELECT member_id, email, fullname, level FROM members");
 */

1 Answer

Matthias J.
Matthias J.
20,355 Points
Matthias J.
Matthias J.
20,355 Points 
<?php
include "helper.php";

foreach($results as $result){
  send_offer($result[0], $result[1], $result[2], $result[3]);
}

/* 
 * helper.php contains
 * $results->query("SELECT member_id, email, fullname, level FROM members");
 */
Gergő Endrész
Gergő Endrész
7,169 Points
Gergő Endrész
Gergő Endrész
7,169 Points

Thanks for the answer. I am not a rocket scientist if we speak about PHP, but I think this wasn't too straightforward. A bit of change in the comment there would make it clear that the fetched values are already in the $results var. Please, correct me if I am wrong, I am here to learn.

Matthias J.
Matthias J.
20,355 Points
Matthias J.
Matthias J.
20,355 Points

you have at the bottom a comment with

$results->query("SELECT member_id, email, fullname, level FROM members");

this told me that the in the results there are the member_id, email, and so on :)

if anything is unclear feel free to ask, i just suck at explanations :D