connect(); $title = 'Products By Price'; $main = ''; $main .= <<

Select products under $:

EOF; if (isset($_GET['price'])) { $price = validFloat($_GET['price']); if ($price > 0) { $query = $db->prepare("SELECT price, name, image FROM geekproducts WHERE price <= ? ORDER BY price, name"); $query->execute(array($price)); $number = $query->rowCount(); $main .= "

We sell $number products under $$price.

"; $main .= ''; $main .= ''; foreach ($query->fetchAll() as $row) { $main .= ""; } $main .= '

Price	Item Name	Thumbnail (click to enlarge)
$$row[price]	$row[name]

'; } else { $price = htmlspecialchars($_GET['price']); $main .= "

$price is not a valid number. Please enter a valid number.

"; } } require '../utils/simpleTemplate.php'; ?>