Technical question - How do they do that?

by 12 replies
14
Hey guys,

I have stumbled an affiliate site of a specific niche and he updates the prices of the products on the site live.

I can have the product entire list as an xml or csv but it means uploading it to the site every day and it's not so convenient and takes time.

When I go to view the products at his site, you can actually see the prices of the products being updated live on the page, on the site itself.

This is how I want to do this on my future site from the same niche, any idea how this is done please?

Thank you, hope this was understood.
#search engine optimization #question #technical
  • Banned
    Most likely he's downloading a database of items and prices into MYSQL and updating every hour or so.
    • [1] reply
    • Not sure, because once I enter the page you actually see the prices change in front of your eyes. You don't think he gets them directly from the sites and updates live? Is it possible?

      Thanks,
      • [1] reply
  • Well...

    You can not do that only by using php and mysql since from what are you saying this happen without refreshing the page and to do that you need java.

    PHP is a server side java is client side... this means that a php script is running in the server and you must make a request to the server to run the script and this mean you refresh the page. Java is running in the browser so you do not need to refresh it.

    This is not so difficult to do.. make a php script to update the prices in the db and then use java to access another php script to get those prices and this java must run at a certain period.

    If you are interested to get those price from his website send me more details and maybe I can help you with that.
    • [1] reply

    • Thanks John, for now we'll do the update once a day as it is sufficient for us, but I did mean the prices change after you refresh the page

      Thank you both for your help, let's see how it goes updating it once a day and if I'll need live updates (after page refresh) I'll ask you again.

      Take care and thank you!
      • [1] reply
  • I think They are using AJAX for doing this
  • I'm sure they're using XML through an API.
    • [1] reply
    • Maybe they are retrieving the prices using XML, but they cannot change the prices on an already loaded page without something AJAX, right ?

Next Topics on Trending Feed