Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > xml > insights

XML from Start to Finish - Phase 1

Dököll's Avatar
Moderator
  
Join Date: Nov 2006
Location: Upstate NY - US
Posts: 2,268
#1   Jul 4 '07
Hey gang!

I thought this may be of use. Pretty old project from College, the code is familiar, but just in case someone is looking.

Program: Apartment Search Database
Language: HTML, XML, XSL, CSS, JavaScript


(1) Save the below in an XML file called apartmentlist.xmlThis file is linked with web pages in the Apartment Search Database. Be sure to save as .xml, Save as Type: All Files.


[HTML]

<?xml version="1.0"?>
<!-- File Name: apartmentlist.xml -->

<?xml-stylesheet type="text/xsl" href="ApartmentSearch.xsl"?>

<RENTALUNITS>
<LISTING>
<APARTMENT>Konner Ridge</APARTMENT>
<ADDRESS>23 Monroe St.</ADDRESS>
<PHONE>256-5533</PHONE>
<BEDROOMS>3</BEDROOMS>
<BATHS>2</BATHS>
<VACANCY>2</VACANCY>
</LISTING>
<LISTING>
<APARTMENT>Konner Ridge</APARTMENT>
<ADDRESS>23 Monroe St.</ADDRESS>
<PHONE>256-5533</PHONE>
<BEDROOMS>1</BEDROOMS>
<BATHS>1</BATHS>
<VACANCY>2</VACANCY>
</LISTING>
<LISTING>
<APARTMENT>River Side Apartments</APARTMENT>
<ADDRESS>400 St. Joe River Rd.</ADDRESS>
<PHONE>395-4474</PHONE>
<BEDROOMS>1</BEDROOMS>
<BATHS>1</BATHS>
<VACANCY>2</VACANCY>
</LISTING>
<LISTING>
<APARTMENT>White Oak Apartments</APARTMENT>
<ADDRESS>900 W. 111th St</ADDRESS>
<PHONE>398-4123</PHONE>
<BEDROOMS>2</BEDROOMS>
<BATHS>2</BATHS>
<VACANCY>1</VACANCY>
</LISTING>
<LISTING>
<APARTMENT>Moore Woods Apartments</APARTMENT>
<ADDRESS>200 N. 1st St.</ADDRESS>
<PHONE>695-0695</PHONE>
<BEDROOMS>2</BEDROOMS>
<BATHS>1</BATHS>
<VACANCY>2</VACANCY>
</LISTING>
<LISTING>
<APARTMENT>Rhodes Manner Apartments</APARTMENT>
<ADDRESS>1000 Welsh Ave</ADDRESS>
<PHONE>395-3305</PHONE>
<BEDROOMS>4</BEDROOMS>
<BATHS>2</BATHS>
<VACANCY>2</VACANCY>
</LISTING>
</RENTALUNITS>

[/HTML]

(2) Save this one as another XML file, name it App_Price.xml
Stick it in a folder called BEDS. This file is linked with web pages in the Apartment Search Database. Be sure to save as .xml, Save as Type: All Files.


[HTML]

<?xml version="1.0"?>
<!-- File Name: App_Price.xml -->
<Find_It>
<Apartmnt>
<Name>Konner Ridge</Name>
<Type>Condominium</Type>
<Crime-Rate_1>13 % Low</Crime-Rate_1>
<Crime-Rate_2>26 % High</Crime-Rate_2>
<Your_Price>$189,000.00</Your_Price>
</Apartmnt>


<Apartmnt>
<Name>Konner Ridge III</Name>
<Type>Apartment Building</Type>
<Crime-Rate_1>23 % Low</Crime-Rate_1>
<Crime-Rate_2>35 % High</Crime-Rate_2>
<Your_Price>$89,000.00</Your_Price>
</Apartmnt>


<Apartmnt>
<Name>Konner Ridge VI</Name>
<Type>1600 Brick House</Type>
<Crime-Rate_1>10 % Low</Crime-Rate_1>
<Crime-Rate_2>12 % High</Crime-Rate_2>
<Your_Price>$1,600,000.00</Your_Price>
</Apartmnt>


<Apartmnt>
<Name>Eastwood Place Apartments</Name>
<Type>Brick Mansion</Type>
<Crime-Rate_1>9 % Low</Crime-Rate_1>
<Crime-Rate_2>12 % High</Crime-Rate_2>
<Your_Price>$590,000.00</Your_Price>
</Apartmnt>


<Apartmnt>
<Name>Blair House</Name>
<Type>Condominium</Type>
<Crime-Rate_1>5 % Low</Crime-Rate_1>
<Crime-Rate_2>10 % High</Crime-Rate_2>
<Your_Price>$2,021,899.00</Your_Price>
</Apartmnt>


<Apartmnt>
<Name>Blair House IV</Name>
<Type>Old Brick House</Type>
<Crime-Rate_1>3 % Low</Crime-Rate_1>
<Crime-Rate_2>8 % High</Crime-Rate_2>
<Your_Price>$678,000.00</Your_Price>
</Apartmnt>



<Apartmnt>
<Name>Vorhaus Condos</Name>
<Type>Condominium</Type>
<Crime-Rate_1>11 % Low</Crime-Rate_1>
<Crime-Rate_2>16 % High</Crime-Rate_2>
<Your_Price>$1,189,000.00</Your_Price>
</Apartmnt>
<Apartmnt>
<Name>The French Quarter</Name>
<Type>Condominium</Type>
<Crime-Rate_1>3 % Low</Crime-Rate_1>
<Crime-Rate_2>6 % High</Crime-Rate_2>
<Your_Price>$699,670.00</Your_Price>
</Apartmnt>

</Find_It>

[/HTML]

(3) Add the XSL file, must be named ApartmentSearch.xslThis file is linked with web pages in the Apartment Search Database. Be sure to save as .xsl, Save as Type: All Files.


[HTML]

<?xml version="1.0"?>
<xsl:transform version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
Database search
<center>
<a href="Uhome.html"><img border="0" src="4433444.bmp" alt="Click here to go home"></img></a>
<h2>Browse Availability</h2>
</center>
<xsl:for-each select="RENTALUNITS/LISTING">
<xsl:sort select="APARTMENT" />
<p>
<span style="font-style:italic; font-weight: 900; color: #ff6633">
<xsl:value-of select="ADDRESS" />
</span>
<xsl:text> </xsl:text>
<span style="font-variant:small-caps; font-weight:bold">
<xsl:value-of select="PHONE"/>
</span>
</p>
<p style="margin-left: 3%">
<span style="font-weight:bold">Number of Bedrooms/Baths </span>
<xsl:value-of select="BEDROOMS" /> bedrooms and <xsl:value-of select="BATHS"/> baths.
Number of vacancies:
<span style="font-style:italic; font-weight: bold; color:#009999">
<xsl:value-of select="VACANCY" />
</span>
</p>
</xsl:for-each>
</xsl:template>
</xsl:transform>

[/HTML]

(4) Add a couple of HTML files, this one should be named apartment.htmlThis file is linked with web pages in the Apartment Search Database. Be sure to save as .html, Save as Type: All Files.


[HTML]

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Fetch Bedrooms</title>
</head>
<body bgcolor="gray">
<xml id="dsoRENTALUNITS" src="BEDS/App_Price.xml"></xml>
<p align="center">
<a href="index.htm"><img border="0" src="img_citywide.gif"></img></a></p>
<p></p>
<p style="font-size:24px; color: #332266; font-weight:900">Search By # of Rooms</p>
<p style="font-size:18px; color: white; font-weight:100">Number of Rooms:<input type="text" id="searchtext" size="20" onKeyPress="keyPressed()">&nbsp;
<button onClick="findApp()">search</button>
</p>


<hr size="5" color="#cccccc"/>
<div id="searchresult">
<p style="font-size:18px; color: lime; font-weight:100">Results:
</div>
<script type="text/javascript">
<!--hide from old browsers
function keyPressed(k) {
var hitEnter=event.keyCode
if (hitEnter==13) findApp()
}

function findApp() {
searchstring = searchtext.value.toUpperCase()
if (searchstring=="") {
searchresult.innerHTML = "<b>Please add # of rooms in textbox.</b>"
return
}
dsoRENTALUNITS.recordset.moveFirst()
var outputresult=""
while (!dsoRENTALUNITS.recordset.EOF) {
namestring = dsoRENTALUNITS.recordset("Num_Bed").value
if (namestring.toUpperCase().indexOf(searchstring)>=0 )
outputresult += "<b>" + dsoRENTALUNITS.recordset("Num_Bed")+"</b> ("+dsoRENTALUNITS.recordset("Beds")+")</p>"
+ "<p style='margin-left:25px'><b>Location: </b>"+dsoRENTALUNITS.recordset("Local")+"</p>"
+ "<p style='margin-left:25px'><b>For: </b>"
+ dsoRENTALUNITS.recordset("Option_Bound") +"<br /></p>"
dsoRENTALUNITS.recordset.moveNext()
}
if (outputresult=="")
searchresult.innerHTML = "Number of rooms selected currently unavailable."
else
searchresult.innerHTML = outputresult
}
//-->
</script>

<hr size="5" color="#cccccc" />

<br>
<table align="center" width="670">
<tr>
<td width="34%">
<a href="apartmentlist.xml">Browse Location</a>
</td>
<td width="34%">
<a href="apartment_price.html">Browse Price</a>
</td>
<td width="32%">
<a href="apartment.html">Search Rooms</a>
</td>
</tr>
</table>
</center>

<br>
<br>

<p>
<b><CENTER>
<FONT FACE="Arial" SIZE="-2" color="white">
Copyright &copy; 2006-2008 For more information about our business,<br> please contact us: <a href="mailto:XXXXXXX@Me.org"><FONT FACE="Arial" SIZE="-2" color="lightgreen"><b>XXXXXXX@Me.org</a></b></font><br> All rights reserved.
<br></CENTER>
</p>
</FONT></b>
</body>
</html>

[/HTML]


(5) Name below, apartment_price.htmlThis file is linked with web pages in the Apartment Search Database. Be sure to save as .html, Save as Type: All Files.


[HTML]

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<xml id="dsoApp" src="App_Price.xml"></xml>
<head>
<title>Browse By Price</title>
</head>
<body bgcolor="gray">
<center>
<a href="index.html"><img border="0" src="img_citywide.gif"></img></a>
<h2>Apartment Listing By Price</h2>
<button onclick="AppTable.firstPage()">|&lt; First Page </button>&nbsp;&nbsp;
<button onclick="AppTable.previousPage()">&lt; Previous Page </button>&nbsp;&nbsp;
<button onclick="AppTable.nextPage()"> Next Page &gt; </button>&nbsp;&nbsp;
<button onclick="AppTable.lastPage()"> Last Page &gt;| </button>
<hr color="#666666" size="5" width="75%" />
<table id="AppTable" datasrc="#dsoApp" datapagesize="6" border="1" cellpadding="5">
<thead style="color:darkred; font-size:14pt; font-weight:900">
<th>TYPE</th>
<th>NAME</th>
<th>CRIME RATE</th>
<th>YOUR PRICE</th>
</thead>
<tr>
<td><span datafld="Type" style="font-family:arial; font-style:italic"></span></td>
<td><span datafld="Name" style="font-family:arial; font-weight:900"></span></td>
<td><span datafld="Crime-Rate_1"></span>, <span datafld="Crime-Rate_2"></span></td>
<td><span datafld="Your_Price"></span></td>
</tr>
</table>

<br>
<table align="center" width="670">
<tr>
<td width="34%">
<a href="apartmentlist.xml">Browse Location</a>
</td>
<td width="34%">
<a href="apartment_price.html">Browse Price</a>
</td>
<td width="32%">
<a href="apartment.html">Search Bedrooms</a>
</td>
</tr>
</table>
</center>
<p>
<b><CENTER>
<FONT FACE="Arial" SIZE="-2" color="white">
Copyright &copy; 2006-2008 For more information about our business,<br> please contact us: <a href="mailto:XXXXXXX@You.org"><FONT FACE="Arial" SIZE="-2" color="lightgreen"><b>XXXXXXX@You.org</a></b></font><br> All rights reserved.
<br></CENTER>
</p>
</FONT></b>
</body>
</html>

[/HTML]


(6) Here is our index.htmlThis file is linked with web pages in the Apartment Search Database. Be sure to save as .html, Save as Type: All Files.


[HTML]

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>XXXXX, Inc. Apartment Search</title>
</head>
<body bgcolor="gray">
<table border="0" width="90%">
<tr>
<td><div align="center"><p style="font-weight:bold"><center>Welcome our home Page! <br><img src="7666646.gif" /></div>
</tr></td>
</table>
<table border="0" width="90%">
<tr>
<td align="center" width="26%"><img src="ttttetetetet.jpg" usemap="#DatabaseSearchbar"/>
<map name="DatabaseSearchbar">
<area shape="rect" coords="16,90,195,117" href="apartmentlist.xml" alt="Browse Location" />
<area shape="rect" coords="39,131,167,157" href="apartment_price.html" alt="Browse Price" />
<area shape="rect" coords="35,169,173,195" href="apartment.html" alt="Search Bedrooms" />
</map>
</td>
</tr>
</table>

<br>
<table align="center" width="670">
<tr>
<td width="34%">
<a href="apartmentlist.xml">Browse Location</a>
</td>
<td width="34%">
<a href="apartment_price.html">Browse Price</a>
</td>
<td width="32%">
<a href="apartment.html">Search Bedrooms</a>
</td>
</tr>
</table>

<p>
<b><CENTER>
<FONT FACE="Arial" SIZE="-2" color="white">
Copyright &copy; 2006-2008 For more information about our business,<br> please contact us: <a href="mailto:XXXXXXX@You.org"><FONT FACE="Arial" SIZE="-2" color="lightgreen"><b>XXXXXXX@You.org</a></b></font><br> All rights reserved.
<br></CENTER>
</p>
</FONT></b>
</body>
</html>
[/HTML]

Please note: XML Data in this web site were managed through a variety of platforms. An ASP.NET web site allowed data to be added to an SQL Server 2005 database, which were then loaded to an Access Database. A VB application helped make up XML files to load to the above.

Related link: http://bytes.com/forum/thread762010.html

Added info: http://bytes.com/forum/thread777267.html

Have fun!

Dököll
Last edited by Dököll; Apr 13 '08 at 04:13 AM. Reason: HTML Tags



Newbie
  
Join Date: Jan 2008
Posts: 1
#2   Jan 28 '08

re: XML from Start to Finish - Phase 1

Hey,

I did all this but no data shows up in the listing by price page and the data is all just text in the browse by location page and the search by # of bedrooms doesnt return any results.

Is this info coming in phase 2 or something?
Dököll's Avatar
Moderator
  
Join Date: Nov 2006
Location: Upstate NY - US
Posts: 2,268
#3   Jan 29 '08

re: XML from Start to Finish - Phase 1

Hey there!


This is a complete code. A working one in fact used in a live web site....

You may be having problems with the JavaScript portion. Please compare both your code and the posted on. Will look to see if anything's amiss. And sorry for the inconvenience.

In a bit!
Reply

« previous insight | next insight »

Similar XML bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved