Create search form using XML data

[ldg76]

Hi there
I'm new to XML and have been asked to produce a search form from the XML data (ie drop down boxes with relevant info)in XHTML which will drop the info into a database when the user has selected their requirements.
If anyone could point me in the right direction, or offer any tips, it would be greatly appreaciated.
Cheers

 

[JontyMC]

XML data > XSL > XHTML form > Server-side code (ASP, PHP,etc) > Database.

What does the XML look like? What server-side stuff u using?

Jon

"I don't regret this, but I both rue and lament it.

 

[ldg76]

Hi
Iam using the latest version of Apache and this is the XML I am using - its rather long!:

<flights>
<flight>
<flightno>BE145</flightno>
<origin>NCL</origin>
<destination>SOU</destination>
-
<departures>
-
<departure>
<departdate>03-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>03-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>05-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>05-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>07-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>07-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>10-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>10-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>12-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>12-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>14-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>14-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>17-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>17-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>19-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>19-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>21-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>21-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>24-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>24-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>26-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>26-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>28-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>28-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
-
<departure>
<departdate>31-10-2005</departdate>
<departtime>08:55</departtime>
</departure>
-
<departure>
<departdate>31-10-2005</departdate>
<departtime>17:55</departtime>
</departure>
</departures>
<flighttime>100</flighttime>
<capacity>12</capacity>
<operator>flybe</operator>
<costprice>30.00</costprice>
</flight>
-
<flight>
<flightno>BA123</flightno>
<origin>NCL</origin>
<destination>ALC</destination>
-
<departures>
-
<departure>
<departdate>03-09-2005</departdate>
<departtime>10:20</departtime>
</departure>
-
<departure>
<departdate>10-09-2005</departdate>
<departtime>10:20</departtime>
</departure>
-
<departure>
<departdate>17-09-2005</departdate>
<departtime>10:20</departtime>
</departure>
-
<departure>
<departdate>24-09-2005</departdate>
<departtime>10:20</departtime>
</departure>
-
<departure>
<departdate>08-10-2005</departdate>
<departtime>10:20</departtime>
</departure>
-
<departure>
<departdate>15-10-2005</departdate>
<departtime>10:20</departtime>
</departure>
-
<departure>
<departdate>22-10-2005</departdate>
<departtime>10:20</departtime>
</departure>
-
<departure>
<departdate>29-10-2005</departdate>
<departtime>10:20</departtime>
</departure>
</departures>
<flighttime>215</flighttime>
<capacity>20</capacity>
<operator>British Airways</operator>
<costprice>80.00</costprice>
</flight>
-
<flight>
<flightno>BA312</flightno>
<origin>ALC</origin>
<destination>NCL</destination>
-
<departures>
-
<departure>
<departdate>03-09-2005</departdate>
<departtime>15:20</departtime>
</departure>
-
<departure>
<departdate>10-09-2005</departdate>
<departtime>15:20</departtime>
</departure>
-
<departure>
<departdate>17-09-2005</departdate>
<departtime>15:20</departtime>
</departure>
-
<departure>
<departdate>24-09-2005</departdate>
<departtime>15:20</departtime>
</departure>
-
<departure>
<departdate>08-10-2005</departdate>
<departtime>15:20</departtime>
</departure>
-
<departure>
<departdate>15-10-2005</departdate>
<departtime>15:20</departtime>
</departure>
-
<departure>
<departdate>22-10-2005</departdate>
<departtime>15:20</departtime>
</departure>
-
<departure>
<departdate>29-10-2005</departdate>
<departtime>15:20</departtime>
</departure>
</departures>
<flighttime>215</flighttime>
<capacity>20</capacity>
<operator>British Airways</operator>
<costprice>80.00</costprice>
</flight>
-
<flight>
<flightno>BE567</flightno>
<origin>NCL</origin>
<destination>SOU</destination>
-
<departures>
-
<departure>
<departdate>03-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>03-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>05-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>05-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>07-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>07-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>10-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>10-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>12-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>12-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>14-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>14-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>17-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>17-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>19-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>19-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>21-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>21-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>24-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>24-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>26-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>26-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>28-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>28-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
-
<departure>
<departdate>31-10-2005</departdate>
<departtime>11:00</departtime>
</departure>
-
<departure>
<departdate>31-10-2005</departdate>
<departtime>20:15</departtime>
</departure>
</departures>
<flighttime>100</flighttime>
<capacity>12</capacity>
<operator>flybe</operator>
<costprice>30.00</costprice>
</flight>
-
<flight>
<flightno>EJ954</flightno>
<origin>LGW</origin>
<destination>AGP</destination>
-
<departures>
-
<departure>
<departdate>03-09-2005</departdate>
<departtime>08:00</departtime>
</departure>
-
<departure>
<departdate>10-09-2005</departdate>
<departtime>08:00</departtime>
</departure>
-
<departure>
<departdate>17-09-2005</departdate>
<departtime>08:00</departtime>
</departure>
-
<departure>
<departdate>24-09-2005</departdate>
<departtime>08:00</departtime>
</departure>
-
<departure>
<departdate>08-10-2005</departdate>
<departtime>08:00</departtime>
</departure>
-
<departure>
<departdate>15-10-2005</departdate>
<departtime>08:00</departtime>
</departure>
-
<departure>
<departdate>22-10-2005</departdate>
<departtime>08:00</departtime>
</departure>
-
<departure>
<departdate>29-10-2005</departdate>
<departtime>08:00</departtime>
</departure>
</departures>
<flighttime>235</flighttime>
<capacity>40</capacity>
<operator>Easy Jet</operator>
<costprice>60.00</costprice>
</flight>
-
<flight>
<flightno>EJ617</flightno>
<origin>AGP</origin>
<destination>LGW</destination>
-
<departures>
-
<departure>
<departdate>03-09-2005</departdate>
<departtime>14:40</departtime>
</departure>
-
<departure>
<departdate>10-09-2005</departdate>
<departtime>14:40</departtime>
</departure>
-
<departure>
<departdate>17-09-2005</departdate>
<departtime>14:40</departtime>
</departure>
-
<departure>
<departdate>24-09-2005</departdate>
<departtime>14:40</departtime>
</departure>
-
<departure>
<departdate>08-10-2005</departdate>
<departtime>14:40</departtime>
</departure>
-
<departure>
<departdate>15-10-2005</departdate>
<departtime>14:40</departtime>
</departure>
-
<departure>
<departdate>22-10-2005</departdate>
<departtime>14:40</departtime>
</departure>
-
<departure>
<departdate>29-10-2005</departdate>
<departtime>14:40</departtime>
</departure>
</departures>
<flighttime>235</flighttime>
<capacity>40</capacity>
<operator>Easy Jet</operator>
<costprice>60.00</costprice>
</flight>
-
<flight>
<flightno>BE659</flightno>
<origin>EDI</origin>
<destination>JER</destination>
-
<departures>
-
<departure>
<departdate>04-09-2005</departdate>
<departtime>10:45</departtime>
</departure>
-
<departure>
<departdate>11-09-2005</departdate>
<departtime>10:45</departtime>
</departure>
-
<departure>
<departdate>18-09-2005</departdate>
<departtime>10:45</departtime>
</departure>
-
<departure>
<departdate>25-09-2005</departdate>
<departtime>10:45</departtime>
</departure>
-
<departure>
<departdate>09-10-2005</departdate>
<departtime>10:45</departtime>
</departure>
-
<departure>
<departdate>16-10-2005</departdate>
<departtime>10:45</departtime>
</departure>
-
<departure>
<departdate>23-10-2005</departdate>
<departtime>10:45</departtime>
</departure>
-
<departure>
<departdate>30-10-2005</departdate>
<departtime>10:45</departtime>
</departure>
-
<departure>
<departdate>04-06-2006</departdate>
<departtime>10:45</departtime>
</departure>
-
<departure>
<departdate>05-06-2006</departdate>
<departtime>10:45</departtime>
</departure>
</departures>
<flighttime>270</flighttime>
<capacity>8</capacity>
<operator>flybe</operator>
<costprice>52.60</costprice>
</flight>
-
<flight>
<flightno>BE596</flightno>
<origin>JER</origin>
<destination>EDI</destination>
-
<departures>
-
<departure>
<departdate>04-09-2005</departdate>
<departtime>16:50</departtime>
</departure>
-
<departure>
<departdate>11-09-2005</departdate>
<departtime>16:50</departtime>
</departure>
-
<departure>
<departdate>18-09-2005</departdate>
<departtime>16:50</departtime>
</departure>
-
<departure>
<departdate>25-09-2005</departdate>
<departtime>16:50</departtime>
</departure>
-
<departure>
<departdate>09-10-2005</departdate>
<departtime>16:50</departtime>
</departure>
-
<departure>
<departdate>16-10-2005</departdate>
<departtime>16:50</departtime>
</departure>
-
<departure>
<departdate>23-10-2005</departdate>
<departtime>16:50</departtime>
</departure>
-
<departure>
<departdate>30-10-2005</departdate>
<departtime>16:50</departtime>
</departure>
-
<departure>
<departdate>10-06-2006</departdate>
<departtime>16:50</departtime>
</departure>
-
<departure>
<departdate>11-06-2006</departdate>
<departtime>16:50</departtime>
</departure>
</departures>
<flighttime>270</flighttime>
<capacity>8</capacity>
<operator>flybe</operator>
<costprice>52.60</costprice>
</flight>
</flights>

Thanks in advance for any help

 

[JontyMC]

What fields do you want to have on the form? What server-side language are you using? PHP?

Jon

"I don't regret this, but I both rue and lament it.

 

[ldg76]

Hi
I'm running this from PHP. The fields I'm trying to display are:
Flight number with origin and destination with the departure times for the user to chose from as well as the time, capacity, operator and cost price.
Its so that the user can chose which destination they want to go on, then the time they wish to travel and enter the number of passengers. Sorry this is longwinded, but its the best I can explain as its still frustrating the hell out of me!
Thank you