<?php
/**
* File: /path/to/webroot/properties/index.php
*/
include('init.php');
// Get the list of cities
$query = "SELECT id, name FROM cities";
foreach ($dbh->query($query) as $row) {
$viewVars['cities'][$row['id']] = $row['name'];
}
// Get the query and city from form (if submitted)
$q = !empty($_POST['q']) ? $_POST['q'] : '';
$city = !empty($_POST['city_id']) ? $_POST['city_id'] : '';
$viewVars['q'] = $q;
$viewVars['city_id'] = $city;
render('index');

<form action="index.php" method="post">
<fieldset>
<legend>Search</legend>
<div class="input">
<label>City: </label>
<select name="city_id">
<?php foreach ($viewVars['cities']
as $id => $name): ?>
<?php
$selected = '';
if ($id =...