I'm not seeing how the URLs for the shirts are working... [SOLVED]

I'm wondering, then, if it's not by database.php or config.php files...

// Config.php

<?php

    // these two constants are used to create root-relative web addresses
    // and absolute server paths throughout all the code

    define("BASE_URL","/treehouse/PDO_tutorial/");
    define("ROOT_PATH",$_SERVER["DOCUMENT_ROOT"] . "/treehouse/PDO_tutorial/");

    define("DB_HOST", "localhost");
    define("DB_NAME", "shirts4mike");
    define("DB_PORT", "3306"); // default 3306
    define("DB_USER", "root");
    define("DB_PASS", "");

// Database.php

<?php

try {
    $db = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";port=" . DB_PORT . ", "DB_USER", "DB_PASS");
    $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
    $db->exec("SET NAMES 'utf8'");


} catch (Exception $e) {
    echo "Could not connect to the database.";
    exit;
}

Thanks!

By the way, what does the "MOD" mean accompanying your profile image? (I've seen others with "STAFF", but I've no idea what "MOD" means)

Thanks!

It's not either of those files. Where Randy is actually working in in the attached video is the products.php file in the include file. He's in the get_product_single function, which is called in the shirt.php file. Basically it's this:

<?php
if (isset($_GET["id"])) {
    $product_id = intval($_GET["id"]);
    $product = get_product_single($product_id);
}

Which says if an ID is set (i.e. "108") than call get_product_single and pass the function the ID, which should be the SKU, which is used to make a DB call to select name, price, img, sku, paypal from the products table where the sku the query from the string.

<?php
function get_product_single($sku) {

    require(ROOT_PATH . "inc/database.php");

    try {
        $results = $db->prepare("SELECT name, price, img, sku, paypal FROM products WHERE sku = ?");
        $results->bindParam(1,$sku);
        $results->execute();
    } catch (Exception $e) {
        echo "Data could not be retrieved from the database.";
        exit;
    }

    $product = $results->fetch(PDO::FETCH_ASSOC);

    return $product;
}

The MOD just means I'm a moderator on the forum. I have the ability along with my fellow MODS to edit post, select best answers, change or add tags, etc..just basic stuff to help the forum run smoother. We're not paid by treehouse, we just volunteer and were picked by the staff at treehouse to mod based on our previous interactions with the forums.

The guys with the STAFF under their image actually work for Treehouse.

There must be something wrong with my database.php code anyway, because when I try to go back to the index page, I get this error:

Parse error: syntax error, unexpected 'DB_USER' (T_STRING) in C:\xampp\htdocs\treehouse\PDO_tutorial\inc\database.php on line 4

It sounds like your database user is wrong in your config file. Which could be, as you can set your database user and password to whatever you want, the config file just has to reflect that change.

It's the same as it was before, when it worked.

When I change it back to this code, in database.php, it works:

$db = new PDO("mysql:host=localhost;
                            dbname=shirts4mike;
                            port=3306;",
                            "root",
                            "");

But I still get the "Object not found!" when I try to put in this URL:

http://localhost/treehouse/PDO_tutorial/shirts/108/