DCM Software Rental Listing Database

Technical Summary

rentaldb is a Perl application developed by DCM Software to manage a MySQL database of rental listings.

It is called from a <script> tag that may be inserted into any HTML web page.

The program will display records or a search form from which users may specify criteria such as city, number of bedrooms, number of bathrooms, etc. A search option will only be presented if there are listings with more than one of that option. For example, if there are listings for more than one city, this option will be presented on the search form.

Likewise, a search option can be suppressed from being displayed by adjusting values in the <script> tag.

Listings can be displayed sorted by street address or by rent amount.

From a password-protected administration page, property managers may add new listings, change or delete existing listings, upload property photos, or backup and restore listings. A listing can also be hidden temporarily without deleting any data.

Fields of the rental database include...

  • Headline
  • Is the listing active? (Y or N)
  • Street address
  • Unit (optional)
  • City
  • State (XX)
  • Rental type (R=Residential, C=Commercial, O=Storage)
  • Number of bedrooms (0-9)
  • Number of bathrooms (0.0-9.5)
  • Rent amount (monthly) (0 = “call for quote”)
  • Area (square feet)
    		•
  • Description (part 1)
  • Description (part 2)
  • Rent includes...
  • Tenant responsible for...
  • Date listing was added (YYYY-MM-DD)
  • Date available (MMDD)
  • Heating/cooling
  • Room sizes
  • Number of units in building (1-999)
  • Agent name
    		•

    To display Search Form, insert this <script> tag anywhere in the <body> element of your HTML page...

    <script type="text/javascript" src="http://www.dcmsoft.com/cgi-bin/rentaldb.pl?[client id],FRM,[listing page],X,X,X,X,X"></script>

    [client id] is your three-digit Client ID assigned by DCM and [listing page] is the filename of the HTML page on your site from which listings are displayed (e.g., “rental.htm”).

    The series of X characters may be omitted entirely or else adjusted to control which search options are offered. The first X may be changed to a specific rental type (e.g., R=Residential). The second X may be changed to the city to match, with any spaces in the city replaced_with_underscores. The third X may be changed to the number of bedrooms to match. The fourth X may be changed to the number of bathrooms. The fifth X may be changed to a date (MMDD) the unit will be available.

    The X characters may only be omitted if none of them are being changed.

    To display listings, insert this <script> tag anywhere in the <head> element of your HTML page...

    <script type="text/javascript">
     function displist() {
      document.write('\<script type="text/javascript" src="');
      document.write('http://www.dcmsoft.com/cgi-bin/rentaldb.pl?[client id],SEL,,,');
      document.write(location.href.substr(location.href.indexOf("?")+1));
      document.write('"\>\<\/script\>');
     }
    </script>

    And insert this tag anywhere in the <body> element...

    <script type="text/javascript">displist();</script>

    To display email signup form, insert this <script> tag anywhere in the <body> element of your HTML page...

    <script type="text/javascript" src="http://www.dcmsoft.com/cgi-bin/rentaldb.pl?[client id],ASF,X,X,X,X,X,X"></script>

    Return previous page