How to implement the database queries as web services.

[Shaheen Kushan]

Hi, i desperately need help with following matter, any help would be deeply appreciate it,

Implement the database as web services. Provide simple forms which can be used to demonstrate these services in operation.

thanks,
Shaheen

[Oralloy]

So you want to accept arbitrary SQL and produce meaningful results?

Or will you simply present a page requesting values and then do some arbitrary query based on those?

[Shaheen Kushan]

So you want to accept arbitrary SQL and produce meaningful results?

Or will you simply present a page requesting values and then do some arbitrary query based on those?

hi, thank you for your reply, here is the exact thing that i have to do:

Level 8

Implement the database queries which you created in level 6 as web services. Provide simple forms (scaffolding) which can be used to demonstrate these services in operation. In addition to these XML services try to recreate level 6 by applying the XSLT you created in level 7 to your service results.

Note: You should consider carefully the difference between property list results and single property detailed results. Think about how you will handle paged lists of results. These services may be implemented either with or without SOAP.



Level 6 I have already completed this level, however i have no expertise in PHP language, and i desperately need to help to complete this level, please help if you can.

Provide a means for casual visitors to browse and search for accommodation on offer. Search terms may be location, type of property, number of beds and combinations thereof. Search results should be returned in a paginated list format where each entry in the list may be clicked to show full specific property details including the agent’s public details.

Note: A casual visitor should not be expected to authenticate with the site. You should not expect search terms to be an exact match for items. Make sure that you have sufficient items in your database to demonstrate pagination.


Level 7i have pasted level 7 here as well as it related to level 8
You are to design an XML language that can be used to describe accommodation. This will involve the creation of a DTD and/or Schema together with example XML documents. You are also to create an XSLT file that transforms your XML documents into the XHTML formats that you created in Level 6. Provide examples that demonstrate your XSLT using both client-side and server-side XSLT processing.

Note: Your XML language should reflect the structure of your database. How can you make good use of XML attributes? Do not forget to include your DTD and XML files in your final report. Think about how you would represent lists of properties in short format and full details of single properties. Please include links to your XML files with and without XSLT in your website to help with assessment.


please help if you can, thanks

[Oralloy]

Well, it sounds like you'll have to design a database to hold your accomodation information. I'd start by building an appropriate relation structure, and then the relational database once the structure is defined.

My preference is to use RDBMS, rather than hierarchical like XML structures, because of the well-defined relational model and ease of using SQL.

Once your RDBMS is defined, you can start to write your XML schema. The conversion should be straightforward , unless your database is highly complex. Basically every independednt data tree maps into one XML structure.

After that, all you have to do is run your queries and generate the appropriate XML. Don't forget to encode special characters.

Once you've done that, you'll have to