Laterooms xml

[chippyb]

haha yea i was thinking that, dont worrys deleted all those pages now

Looks great as it is, especially like the green. I'd leave it like that

Grant

 

[expertc]

Looks great as it is, especially like the green. I'd leave it like that

Grant

Oi, Grant. We have been parsing XMLs for several hours now I wouldn't even mind... hmmm... PINK

 

[chippyb]

lol I have such a head ache now i dunno about you guys but i need a holiday after that lol!! but pink sounds good, anyone care to share mysql info lol

 

[Admin]

I'm making good progress on mine.

How do I spread the results across multiple pages with Next / Previous links

 

[nick-harper]

I'm making good progress on mine.

How do I spread the results across multiple pages with Next / Previous links

Is this in wordpress or custom?

 

[expertc]

I'm making good progress on mine.

How do I spread the results across multiple pages with Next / Previous links

For live page you might need to have some sort of a numeric key or ID for every entry. If data is parsed live, it's a headache. You might need to store data in temp MySQL tables that you can empty on exit.

P.S. Do they have API?

 

[Admin]

Custom PHP. They do have an API doc where I can set a limit on the number of results using "&lim=" but would prefer to have all results spread across multiple pages.

 

[nick-harper]

Custom PHP. They do have an API doc where I can set a limit on the number of results using "&lim=" but would prefer to have all results spread across multiple pages.

Bang them all into a database and use something like this

 

[chippyb]

that was all just words to me lol, but there again, im sure i leant this in a lesson once and it wasnt that hard why cant it just be simple

 

[expertc]

Custom PHP. They do have an API doc where I can set a limit on the number of results using "&lim=" but would prefer to have all results spread across multiple pages.

If you do a dynamic paging that would increase processing times tremendously. Because you should use something like auto-incrementing value inside the loop. Store it (session store) and then "miss" first n records and display up-to n+m where m is number of records per page. For first page is very fast but speed will considerably slow down when going on the higher page numbers as it has to filter a*n records where "a" is a page number (starting from 0).

Dumping into temp DB table might be a good idea is it only do one run on a feed not "a" runs.

 

[nick-harper]

I think doing anything "live" without some sort of cache (database) would be a nightmare and be really slow!

 

[chippyb]

how do i go about puttin the live xml into a mysql database then?

 

[monaghan]

how do i go about puttin the live xml into a mysql database then?

Replace the "print/echo" statements with a db_insert() statement (setting up the necessary database open / setup statements first. Then in your php display page use a db_select() statement to pull back the desired fields.

I would really suggest looking at something like sitepoint.com and learning with simple examples. I can't remember the title, but Sitepoint used to have a book (available as an ebook as well) called something like "designing websites using php & mysql" which would cover everything you need and more.

Once you understand the concepts you can then apply it to any site / datafeed you like.

 

[chippyb]

but doesnt doing this stop it being a live feed?

 

[nick-harper]

but doesnt doing this stop it being a live feed?

Depending on your hosting you can just update the feed a couple of times per hour!

If Laterooms only update their feed at certain times you can just run it then and if will update your database!

You have the advantage of making searches, related hotels in the area, featured random hotel and a lot more!

As said, follow some guides and start off small to figure out how it all works and which bit does what. You will find it is very powerful

 

[chippyb]

I have manged to get the live url feed to work, but as you guys said it is slow, I also havent worked out paging yet either, I was wondering how to get this feed cached into the mysql database like you said to speed this up I can post any code you need up if you want to see what I have, any help would be great, will to trade favours

Thanks

Ryan