XML file to transfer to server and read reply

[Martin_Miler]

I'm trying to send an XML file from my web site to a server. This file will initiate a response from the server that I need to pars and incorporate into an HTML file.

I have the file created, how do I post this using HTTP? I've looked at articels on DOM and other vehicles, but they all consider sending small bits of text. I'm very new at programing in PHP - VB on a PC is my usual source of 'relaxation'.

[mrbaseball34]

Well a few of questions come to mind...
1. Is the server expecting the file to be XML? Is it expecting
a header to tell it that?

2. Are you using post or get?

3. What is expected in return?

4. It can be done using VB very quickly if that is what you are
   
   familiar with, even without using DOM.

[Martin_Miler]

Thanks for your reply,
I'm sending an XML file - example:

<?xml version="1.0" encoding="UTF-8" ?>
- <SynxisHotelAvailRQ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="file:///C:/source/agent/WWW/schemas/SynxisHotelAvailRQ.xsd" Version="1.0" TimeStamp="2002-08-23T18:39:09" EchoToken="echo123" LanguageId="US-EN" SummaryOnly="true">
<Credentials UserId="AVAILABILITY" Password="certification" />
- <AvailRequestSegment>
- <HotelReferences>
<HotelReference ChainCode="SYN" HotelCode="SSMCL" />
<HotelReference ChainCode="SYN" HotelCode="SSDEN" />
</HotelReferences>
<StayDateRange ArrivalDate="2003-04-07T00:00:00" DepartureDate="2003-04-08T00:00:00" />
- <RoomStayCandidate>
- <GuestCounts>
<GuestCount AgeQualifyingCode="Adults" Count="2" />
<GuestCount AgeQualifyingCode="Children" Count="0" />
</GuestCounts>
</RoomStayCandidate>
</AvailRequestSegment>
</SynxisHotelAvailRQ>

The reply I'll get will be something like the attachment.
Right now I would like to use post via HTTPS.
The URL I'm targeting is:
https://agent.synxis.com/xml/SynxisAvailabilityRequest

These are test files.

[mrbaseball34]

In order to test, I need the schema file located here:

C:/source/agent/WWW/schemas/SynxisHotelAvailRQ.xsd

[mrbaseball34]

Would you rather have this done in VB or PHP?

[Martin_Miler]

Hope I'm not confusing... I have a web site built using PHP and it is from this web site that I want to make the file posting and then read the reply file on the web site and display the result on the web.

[mrbaseball34]

After re-reading your original question, I figured it out.

I haven't done any XML in PHP but I guess I could take a look
and see if I can come up with anything.

[mrbaseball34]

I still need the schema file...

[Martin_Miler]

Is this for the sending or the reply?
I don't usualy use one for the sending - If you enter the url in IE you get a file upload page that asks you to select the file and send. So log as the file is in the same format for sending it should work from whatever platform you 'posting' from'. I have used this format from my pc and it wirks remotely using 'Microsoft XML parser .SDK' which I use for sending similar files from my PC. As regards the reply .... I'll need to investigate.
Can you tell me if it is just the sending part you require a schema to?

[mrbaseball34]

Well, I don't know, yet, as I saw that the XML you posted required the schema on your local drive. I was surprised you didn't notice that...

xsi:noNamespaceSchemaLocation="file:///C:/source/agent/WWW/schemas/SynxisHotelAvailRQ.xsd"

[Martin_Miler]

Agreed - but havn't used one! The application at the server end translates the file and sends a reply. One of my tasks of course is to Pars the reply and display the results on a web page and this may need a schema(?).

[mrbaseball34]

So you are saying that the file does not exist on your local system?

If you don't have it, I can't help you because the parser is going to require it.

[Martin_Miler]

Did you get the files - I sent them last week?

[mrbaseball34]

I did not get the schema file..

[Martin_Miler]

Did you get my zip file? - this is all there is - no schema file required. Can you tell me where you get the requirement for a schema file in your programming. I have done this over the PC and the web without the schema and it worked. Can it not just be ignored?
😕

[vronsky]

use the curl() functios to post the xml

$xml = "xml.data";

$ch = curl_init ();
    $ch1=curl_setopt ($ch, CURLOPT_URL, "http://youserver.com");
    $ch2=curl_setopt ($ch, CURLOPT_POST, 1);
    $ch3=curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml'));
    $ch4=curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
    $ch5 =curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
    $result = curl_exec($ch);
	if (!$result) {echo "<h1>damnit</h1>";}
    curl_close ($ch);

where $result is the xml you receive back

then you put your xml response into an array using the funtion I writen at
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10235030

then you do whatever you want with your parsed data.

Can I ask which project are you growing up ?

[Martin_Miler]

Hello,
Manyt thanks for your reply - I'm using this to get information on hotel availability from a web server. The client (Jo Public) asks for room availabiliuty on a particuar date and I reply to the web site with information form a central database so that the client may choose a hotel from the list that come back and makes a request to book a night (or two).
I'll start looking at your program.
thanks again.
🙂

[Martin_Miler]

Working like a dream - many thanks😃

[vronsky]

Always happy to help...and be helped...

[Martin_Miler]

Hello again!
I have been parsing the file, but have come across elements that I would like to extract, but can't see how to.
I would like to get the information in HotelCode, MinRate and MaxRate. These don't have end tags and have this = sign that I can't see in any XML documentation how to deal with.
I would also like to ignore records that have :
HasAvailability="false".

Below is a sample of two records from the XML file I'm trying to pars. Elements like 'ADDRESS1' get parsed fine.

<?xml version="1.0" ?>
- <SynxisSummaryAvailRS Version="1.0" EchoToken="echo123" TimeStamp="2003-04-22T13:45:41.291">
- <SummaryResponses>
- <SummaryResponse HasAvailability="true">
<HotelReference ChainCode="PRIOB" HotelCode="gori" />
<ShortDescription>The service and atmosphere are unique amongst Londons best.</ShortDescription>
- <PostalAddress>
<Address1>Beeston Place</Address1>
<City>London</City>
<PostalCode>SW1W 0JW</PostalCode>
<Country>UNITED KINGDOM</Country>
</PostalAddress>
<RateRange CurrencyCode="GBP" MinRate="210.00" MaxRate="295.00" />
</SummaryResponse>
- <SummaryResponse HasAvailability="false">
<HotelReference ChainCode="PRIOB" HotelCode="pear" />
<ShortDescription>An exclusive hotel situated outside the Saxon village of Purton</ShortDescription>
- <PostalAddress>
<Address1>Church End Purton</Address1>
<City>Swindon</City>
<PostalCode>SN5 4ED</PostalCode>
<Country>UNITED KINGDOM</Country>
</PostalAddress>
</SummaryResponse>
etc.