Databases
StackOverflow2013
Postsdbo
PORetrieve information after a booking is completed (cURL, iFrame...?) on an external website
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORetrieve information after a booking is completed (cURL, iFrame...?) on an external website
    primarykey
    data
    text
    <p>I am working on a challenging problem : finding a solution to get data after a booking process. Basically, I have a page with a form (SLIM FORM), that I need to automatically fill with informations coming from provider form (e.g. easyjet.com or hotels.com, any booking site basically). For instance : <a href="https://secure.booking.com/hotel/es/royal.html?sid=1c2bab12a0c64a541728840f52cd6401;errorc_checkin_invalid=checkin;errorc_intro_error_message_invalid=intro_error_message;errorv_stage=1;errorv_checkin=2011-07-05;errorv_hotel_id=90228;errorv_installment_count=1;errorv_hostname=www.booking.com;errorv_nr_rooms_9022801_80638194_0=1;errorv_interval=1" rel="nofollow noreferrer">https://secure.booking.com/hotel/es/royal.html?sid=1c2bab12a0c64a541728840f52cd6401;errorc_checkin_invalid=checkin;errorc_intro_error_message_invalid=intro_error_message;errorv_stage=1;errorv_checkin=2011-07-05;errorv_hotel_id=90228;errorv_installment_count=1;errorv_hostname=www.booking.com;errorv_nr_rooms_9022801_80638194_0=1;errorv_interval=1</a> the information in my Booking is what i need to get.</p> <p><img src="https://i.stack.imgur.com/TW5wj.png" alt="enter image description here"></p> <p>I made some tests and here are what I found out, for now :</p> <p>It's not possible to have both on the same page, because with cURL, there is no communication with the external server, and with iframes, it leaves the page ASAP the src of the iframe changes.</p> <p>So, I decided that the booking process should happen on a dedicated page, in the domain of the booking provider (easyjet.com...)</p> <p>1) Am I right to consider performing the booking on the real site, or is there a way to include the external website on my page and perform the whole process of booking in it (basically filling forms on departure, arrival date etc...)?</p> <p>If not possible, I made some tests with cURL and came to this conclusion :</p> <p>_ I will have to define fitted regex for each provider, and I am under the impression that some have mechanisms to identify cURL and block it. (e.g. lufthansa.com) But it works quite well with others ( booking.com )</p> <p>I have 2 additionnal questions :</p> <p>2) Are there better solutions than cURL to parse some HTML in a page (especially since it doesn't work if the URL doesn't include sessionID)? I was thinking maybe of using something like Selenium...</p> <p>3) How can I trigger my cURL parsing on an other tab or window? (I was thinking about a system similar to bookmarks that can trigger some JavaScript code)</p> <p>Thanks for your answers and sorry for the length :-)</p> <p><strong>Update</strong> : Based on answers I received, here are fresh thoughts : for big providers (easyjet, hotels.com etc...), I will use an API if available. For small providers (e.g. <a href="http://www.hotel-gare-clermont.com/en,1,6217.html" rel="nofollow noreferrer">http://www.hotel-gare-clermont.com/en,1,6217.html</a> ), I think the proxy solution is worth another one, and I won't receive any complaints on legal issues from "Hotel de la Gare", while adding visibility to those small providers. What do you think?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMichael Kohne
    1. USMichael Lumbroso
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PORetrieve information after a booking is completed (cURL, iFrame...?) on an external website
      1. USMichael Lumbroso
      1. VTBountyStart
    2. VO
      singulars
      1. PORetrieve information after a booking is completed (cURL, iFrame...?) on an external website
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PORetrieve information after a booking is completed (cURL, iFrame...?) on an external website
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODo keep in mind that you should try to talk to the providers - they may be able to offer an API interface, they might object and block the server IP (although this is business for them, so it's unlikely)
      singulars
      1. PORetrieve information after a booking is completed (cURL, iFrame...?) on an external website
      1. USPhil Lello
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload