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

Loy Yee Ko
Loy Yee Ko
5,814 Points
Posted by Loy Yee Ko
Loy Yee Ko
5,814 Points

When I click on an item, it doesn't return the result but rather refresh and display the full catalog page again

as the title above. This is really confusing, please let me know what's the problem if you may, thank you

details.php <?php

include ("inc/functions.php");

if (isset($_GET["id"])){ $id = filter_input(INPUT_GET,"id", FILTER_SANITIZE_NUMBER_INT); $item = single_item_array($id); var_dump($item); }

if (empty($item)){ header("location:catalog.php"); exit; } $pageTitle = $item["title"]; $section = null;

include ("inc/header.php"); ?>

<div class= "section page"> <div class = "wrappper" > <div class="breadcrumbs" > <a href="catalog.php">Full Catalog</a> > <a href="catalog.php?cat= <?php echo strtolower($item['catalog']); ?>"> <?php echo $item['category']; ?></a> > <?php echo $item['catalog']; ?> <?php echo $item['title']; ?>

    </div>
    <div class = "media-picture">
    <span>
    <img src = "<?php echo $item['img']; ?>" alt = "<?php echo $item['title']; ?>" />
    </span>
    </div>
<div class = "media-details">
    <h1><?php echo $item['title']; ?>  </h1>
    <table>
        <tr>
            <th> Catagory </th>
            <td> <?php echo $item['category']; ?> </td>
        </tr>
        <tr>
            <th> Genre </th>
            <td> <?php echo $item['genre']; ?> </td>
        </tr>
        <tr>
            <th> Format </th>
            <td> <?php echo $item['format']; ?> </td>
        </tr>
        <tr>
            <th> Year </th>
            <td> <?php echo $item['year']; ?> </td>
        </tr>

        <?php 
        if (strtolower($item['category']) =="books") {
            ?>
            <tr>
            <th> Authors </th>
            <td> <?php echo implode(", ", $item['author']); ?> </td>
            </tr>
            <tr>
            <th> Publisher </th>
            <td> <?php echo $item['publisher']; ?> </td>
            </tr>
            <tr>
            <th>ISBN</th>
            <td> <?php echo $item['isbn']; ?> </td>
            </tr>
        <?php  }  elseif (strtolower($item['category']) =="movies") {
            ?>
            <tr>
            <th> Director </th>
            <td> <?php echo implode(", ", $item['director']); ?> </td>
            </tr>
            <th> Writers </th>
            <td> <?php echo implode(", ", $item['writer']); ?> </td>
            <tr>
            <th> Stars </th>
            <td> <?php echo implode(", ", $item['star']); ?> </td>
            </tr>
        <?php  } elseif (strtolower($item['category']) =="music") {
            ?>
            <tr>
            <th> Artist </th>
            <td> <?php echo $item['artist']; ?> </td>
            </tr>

        <?php } ?>
    </table>
</div>

</div>

functions.php <?php function full_catalog_array(){ include("connection.php"); try { $results = $db->query("SELECT media_id, title, category, img FROM Media"); echo "Retrieved Results"; } catch (Exception $e){ echo "Unable to retrieve results"; echo $e->getMessage(); exit; } $catalog = $results->fetchAll(); return $catalog; }

function single_item_array($id){ include("connection.php"); try { $results = $db->prepare(" SELECT title, category, format, year, img, 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 = ?");
    $results->bindParam(1,$id, PDO::PARAM_INT);
    $results->execute();
} catch (Exception $e){
    echo "Unable to retrieve results";
    echo $e->getMessage();

    exit;
}
$catalog = $results->fetch();

if(empty($item)) return $item; try { $results = $db->prepare(" SELECT fullname, role

    FROM Media_People
    JOIN People ON Media_People.people_id = People.people_id
    WHERE Media_People.media_id = ?"
    );
    $results->bindParam(1,$id, PDO::PARAM_INT);
    $results->execute();
} catch (Exception $e){
    echo "Unable to retrieve results";
    echo $e->getMessage();
    exit;
}

while($row = $results->fetch(PDO::FETCH_ASSOC)) {

$item[$row["role"]][] = $row["fullname"];

} return $item; }

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

function array_category($catalog, $category) {

    return array_keys($catalog);

$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);

}