echo $_SERVER['PHP_SELF'];
?>
" method="post">
<!-- Write a query to get this select dropdown. Display product names -->
<select name="productId">
<option value=""></option>
<option value="1">DomoKun</option>
<option value="3">Painting</option>
</select>
<!-- and a submit button -->
<input type="submit"/>
</form>
<?php
// Receive the user input and do stuff
if ($_POST) {
// Get the user's input
$productId = $_POST['productId'];
// Validate the input // Write a query
$query = 'select * from aca_product where product_id = "' . $db->quote($productId) . '"';
$db->setQuery($query);
// get the result
$product = $db->loadObject();
// Display it in html
if (!empty($product)) {
echo '<h3>' . $product->name . '</h3>';
echo '<img src="' . $product->image . '"/>';
}
}
