<?php
/**
* File: /path/to/webroot/properties/add.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 list of localities
$query = "SELECT id, name FROM localities";
foreach ($dbh->query($query) as $row) {
$viewVars['localities'][$row['id']] = $row['name'];
}
// Get the list of amenities
$query = "SELECT id, name FROM amenities";
foreach ($dbh->query($query) as $row) {
$viewVars['amenities'][$row['id']] = $row['name'];
}
// If form is submitted then save the data
// We aren't doing any validation but in a real
// web application you should.
if (!empty($_POST['description'])) {
// Query to insert the property
$query = "INSERT INTO
properties
SET
type = :type,
transaction_type = :transaction_type,
description...