Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

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

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
<?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

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

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