Help needed with cronjob data feed script

Discussion in 'Scripts' started by kcammandc, Jun 10, 2007.

  1. #1
    Hi

    i have a couple of websites, that sell products. my supplier can supply me with a 'Streaming CSV data feed' or as an xml feed (i think)

    i am running my sites with php and mySQL backend. my question is would it be possible to set my a daily cronjob to pull this data into my mySQL database?

    and my second question is, is there anyone here willing to help design this for me, i am willing to pay for the help.

    Regards
    Eliot
     
    kcammandc, Jun 10, 2007 IP
  2. adluo.sales

    adluo.sales Peon

    Messages:
    40
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    sure, you can do what you want.
     
    adluo.sales, Jun 10, 2007 IP
  3. kcammandc

    kcammandc Peon

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    any change you want to put it togeather for me if i give you all the details. i looking for it to something like the following

    every day at 2am pull the xml feed from www.domain.com/feed.xml, the feed have four columns of data: code,subcode,name, status

    i need it to pull into an existing sql table and update the status column. and match the records by code, (in the sql table the code & subcode are combined: e.g. subcode space code, into one column)

    and all this needs to within a cronjob

    any help would be good, sample code etc, if needed im willing to pay
     
    kcammandc, Jun 11, 2007 IP