XML from Start to Finish - Phase 1

[Dököll]

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.x mlThis file is linked with web pages in the Apartment Search Database. Be sure to save as .xml, Save as Type: All Files.


[code=html]

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

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

<RENTALUNITS>
<LISTING>
<APARTMENT>Konn er Ridge</APARTMENT>
<ADDRESS>23 Monroe St.</ADDRESS>
<PHONE>256-5533</PHONE>
<BEDROOMS>3</BEDROOMS>
<BATHS>2</BATHS>
<VACANCY>2</VACANCY>
</LISTING>
<LISTING>
<APARTMENT>Konn er Ridge</APARTMENT>
<ADDRESS>23 Monroe St.</ADDRESS>
<PHONE>256-5533</PHONE>
<BEDROOMS>1</BEDROOMS>
<BATHS>1</BATHS>
<VACANCY>2</VACANCY>
</LISTING>
<LISTING>
<APARTMENT>Rive r 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>Whit e 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>Moor e 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>Rhod es Manner Apartments</APARTMENT>
<ADDRESS>1000 Welsh Ave</ADDRESS>
<PHONE>395-3305</PHONE>
<BEDROOMS>4</BEDROOMS>
<BATHS>2</BATHS>
<VACANCY>2</VACANCY>
</LISTING>
</RENTALUNITS>

[/code]

(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.


[code=html]

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


<Apartmnt>
<Name>Konner Ridge III</Name>
<Type>Apartme nt 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>Eastwoo d 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>$59 0,000.00</Your_Price>
</Apartmnt>


<Apartmnt>
<Name>Blair House</Name>
<Type>Condomini um</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>$67 8,000.00</Your_Price>
</Apartmnt>



<Apartmnt>
<Name>Vorhaus Condos</Name>
<Type>Condomini um</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>Condomini um</Type>
<Crime-Rate_1>3 % Low</Crime-Rate_1>
<Crime-Rate_2>6 % High</Crime-Rate_2>
<Your_Price>$69 9,670.00</Your_Price>
</Apartmnt>

</Find_It>

[/code]

(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.


[code=html]

<?xml version="1.0"?>
<xsl:transfor m version="1.0" xmlns:xsl="http ://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
Database search
<center>
<a href="Uhome.htm l"><img border="0" src="4433444.bm p" alt="Click here to go home"></img></a>
<h2>Browse Availability</h2>
</center>
<xsl:for-each select="RENTALU NITS/LISTING">
<xsl:sort select="APARTME NT" />
<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">Nu mber of Bedrooms/Baths </span>
<xsl:value-of select="BEDROOM S" /> 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>

[/code]

(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.


[code=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.dt d">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Fetch Bedrooms</title>
</head>
<body bgcolor="gray">
<xml id="dsoRENTALUN ITS" src="BEDS/App_Price.xml"> </xml>
<p align="center">
<a href="index.htm "><img border="0" src="img_citywi de.gif"></img></a></p>
<p></p>
<p style="font-size:24px; color: #332266; font-weight:900">Sea rch By # of Rooms</p>
<p style="font-size:18px; color: white; font-weight:100">Num ber of Rooms:<input type="text" id="searchtext " size="20" onKeyPress="key Pressed()">&nbs p;
<button onClick="findAp p()">search</button>
</p>


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

function findApp() {
searchstring = searchtext.valu e.toUpperCase()
if (searchstring== "") {
searchresult.in nerHTML = "<b>Please add # of rooms in textbox.</b>"
return
}
dsoRENTALUNITS. recordset.moveF irst()
var outputresult=""
while (!dsoRENTALUNIT S.recordset.EOF ) {
namestring = dsoRENTALUNITS. recordset("Num_ Bed").value
if (namestring.toU pperCase().inde xOf(searchstrin g)>=0)
outputresult += "<b>" + dsoRENTALUNITS. recordset("Num_ Bed")+"</b> ("+dsoRENTALUNI TS.recordset("B eds")+")</p>"
+ "<p style='margin-left:25px'><b>L ocation: </b>"+dsoRENTALUN ITS.recordset(" Local")+"</p>"
+ "<p style='margin-left:25px'><b>F or: </b>"
+ dsoRENTALUNITS. recordset("Opti on_Bound") +"<br /></p>"
dsoRENTALUNITS. recordset.moveN ext()
}
if (outputresult== "")
searchresult.in nerHTML = "Number of rooms selected currently unavailable."
else
searchresult.in nerHTML = outputresult
}
//-->
</script>

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

<br>
<table align="center" width="670">
<tr>
<td width="34%">
<a href="apartment list.xml">Brows e Location</a>
</td>
<td width="34%">
<a href="apartment _price.html">Br owse 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:XX XXXXX@Me.org">< FONT FACE="Arial" SIZE="-2" color="lightgre en"><b>XXXXXXX@ Me.org</a></b></font><br> All rights reserved.
<br></CENTER>
</p>
</FONT></b>
</body>
</html>

[/code]


(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.


[code=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.dt d">
<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.htm l"><img border="0" src="img_citywi de.gif"></img></a>
<h2>Apartment Listing By Price</h2>
<button onclick="AppTab le.firstPage()" >|&lt; First Page </button>&nbsp;&n bsp;
<button onclick="AppTab le.previousPage ()">&lt; Previous Page </button>&nbsp;&n bsp;
<button onclick="AppTab le.nextPage()"> Next Page &gt; </button>&nbsp;&n bsp;
<button onclick="AppTab le.lastPage()"> Last Page &gt;| </button>
<hr color="#666666" size="5" width="75%" />
<table id="AppTable" datasrc="#dsoAp p" datapagesize="6 " border="1" cellpadding="5" >
<thead style="color:da rkred; 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_P rice"></span></td>
</tr>
</table>

<br>
<table align="center" width="670">
<tr>
<td width="34%">
<a href="apartment list.xml">Brows e Location</a>
</td>
<td width="34%">
<a href="apartment _price.html">Br owse 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:XX XXXXX@You.org"> <FONT FACE="Arial" SIZE="-2" color="lightgre en"><b>XXXXXXX@ You.org</a></b></font><br> All rights reserved.
<br></CENTER>
</p>
</FONT></b>
</body>
</html>

[/code]


(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.


[code=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.dt d">
<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"><c enter>Welcome our home Page! <br><img src="7666646.gi f" /></div>
</tr></td>
</table>
<table border="0" width="90%">
<tr>
<td align="center" width="26%"><im g src="ttttetetet et.jpg" usemap="#Databa seSearchbar"/>
<map name="DatabaseS earchbar">
<area shape="rect" coords="16,90,1 95,117" href="apartment list.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="apartment list.xml">Brows e Location</a>
</td>
<td width="34%">
<a href="apartment _price.html">Br owse 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:XX XXXXX@You.org"> <FONT FACE="Arial" SIZE="-2" color="lightgre en"><b>XXXXXXX@ You.org</a></b></font><br> All rights reserved.
<br></CENTER>
</p>
</FONT></b>
</body>
</html>
[/code]

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

[konfushus]

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]

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!

[Dököll]

Hey there good buddy!

Here is the complete app, download and save the files to the same location, put App_Price file in a folder called BEDS.

apartment.htm
apartment_price .htm
ApartmentSearch .xsl
App_Price.xml
apartmentlist.x ml
index.htm

Download, then scan for viruses before opening if you're not comfortable.

Hope this works for ya...

Dököll