#!/usr/local/bin/php3 Katonalle Appartment Search

Katonalle

" . "Appartments with " . $rooms . " room" . ($rooms < 2 ? "" : "s") . "\n\n"; echo "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; while (odbc_fetch_row($result)) { $no_of_apparts++; $no_of_apparts % 2 ? $bg_color = "#FFFFFF" : $bg_color = "#AFCFFF"; echo "\n" . "\n" . "\n" . "\n" . "\n" . "\n" . "\n"; } echo "\n" . "\n" . "\n" . "
TypeFloor areaDistrictAddressRent asked
" . odbc_result($result, 1) . "" . sprintf("%.1f", odbc_result($result, 2)) . " m2" . odbc_result($result, 3) . "" . odbc_result($result, 4) . "" . odbc_result($result, 5) . "
" . "Total number: $no_of_apparts" . "
\n\n"; } function execute_query($rooms) { global $faces; $no_of_apparts = 0; error_reporting(0); // comment this to get warnings and error messages $db = odbc_connect("TCP/IP db.cs.Helsinki.FI 1414", "uusmed", "lehma"); if ($db) { $result = odbc_exec($db, "SELECT ptype, pm2, parea, paddress, prent_asked FROM PROPERTY WHERE prooms = $rooms ORDER BY ptype, pm2, parea, paddress, prent_asked"); if ($result) { echo_result($rooms, $result); } else { echo "

Execution of " . "database query failed. Try again later.

\n\n"; } } else { echo "

Couldn't connect " . "to database. Try again later.

\n\n"; } } function echo_date() { global $faces; $loc_date = date("d M Y"); echo "
\n" . "
" . "
Katonalle
$loc_date
\n" . "
\n"; } function echo_form($act_url) { global $faces; echo "

Appartment search

\n\n"; echo "
\n" . "
\n" . "" . "Give number of rooms:\n" . "\n" . "\n" . "
\n" . "
\n\n"; } // THIS IS THE MAIN PART if ($room_count != "") { $room_count = intval($room_count); if ($room_count < 1 || $room_count > 100) { echo "

The number of " . "rooms given was incorrect.

\n\n"; } else { execute_query($room_count); } } echo_form($PHP_SELF); echo_date(); ?>