searching xml data from html page : listing results
 

Good morning.

I am building a website for a property lettings agent. Their database uploads an XML file to my server. I want to integrate the data in a "property for let" page and make this searchable by 3 areas : postcode/zipcode , number of rooms , price. There aren't really that many properties (currently 40) but the number will grow. I also want to filter out "random" properties to display on other pages eg "latest 3 listings" and "random property."

What are my options?

I hope this makes sense. I only need pointing in the right direction for the moment.

Many thanks.

Stephen

One accepted practice uses the so-called three-tiered Model-View-Controller paradigm, which is implemented with a back-end database such as MySQL, PostgreSQL, Oracle, etc (the model), a web server such as Apache (with a browser, the view), and some application-specific CGI or PHP code (the controller). A Google search for Model View Controller (MVC) should yield a plethora of information to use as a starting point.
Your application will require you to populate the database from the uploaded XML, and then create HTML pages with content extracted from the database, using your application-specific CGI/PHP code. Extracting from and updating the information in the database would be done using SQL queries embedded in your code. It is difficult to be more specific than this without more details of your application.

--- rod.

Thanks. I suspected MySQL, Apache and PHP. Time to get my fingers dirty with something new.........