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 Integrating Database Results

Posted by Joy Manuel
Joy Manuel
6,464 Points

Functions.php no longer works when moving db query to functions.php

So far everything and all pages work properly, except when moving database query to functions.php. This page no longer displays. I have set up my IDE correctly, downloading files to MySQL database. Using MAMP.

<?php //page broke since Integrating Database Results video. Unable to retrieve results function full_catalog_array() { include("connection.php"); //echo "Connected to the database"; try { $results = $db->query("SELECT media_id, title, category, img FROM Media"); } catch (Exception $e) { echo "Unable to retrieve results"; exit; }

    $catalog = $results->fetchAll();
    return $catalog;

} function single_item_array($id) { include("connection.php"); //echo "Connected to the database"; try { $results = $db->query( "SELECT media_id, title, category, img, format, year, genre, publisher, isbn FROM Media JOIN Genres ON Media_genre_id = Genres.genre_id LEFT OUTER JOIN Books ON Media.media_id = Books.media_id WHERE Media.media_id = $id" ); } catch (Exception $e) { echo "Unable to retrieve results"; exit; }

    $catalog = $results->fetch();
    return $catalog;

} var_dump(single_item_array(1)); function get_item_html($id,$item) { $output = "<li><a href='details.php?id=" . $id . "'><img src='" . $item["img"] . "' alt='" . $item["title"] . "' />" . "<p>View Details</p>" . "</a></li>"; return $output; }

function array_category($catalog,$category) { $output = array();

foreach ($catalog as $id => $item) {
    if ($category == null OR strtolower($category) == strtolower($item["category"])) {
        $sort = $item["title"];
        $sort = ltrim($sort,"The ");
        $sort = ltrim($sort,"A ");
        $sort = ltrim($sort,"An ");
        $output[$id] = $sort;            
    }
}

asort($output);
return array_keys($output);

}