Auto Update XML->MySQL by using PHP

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • th1982
    New Member
    • Feb 2008
    • 51

    Auto Update XML->MySQL by using PHP

    I want to auto get data from xml file( daily updated) to mysql database every day at 11am and 5pm .Right now I know how to get it but i need to run 1 php file called "importxml.php" .I want it automatically 2times per day.
    Any solutions for it
    Thanks very much
  • ronverdonk
    Recognized Expert Specialist
    • Jul 2006
    • 4259

    #2
    You'll need a cron job to do that automatically. Ask your provider if you can run such a job or that he can automate/run that for you.

    Ronald

    Comment

    • th1982
      New Member
      • Feb 2008
      • 51

      #3
      Thanks to yr reply
      But can you tell me what the cron job ?
      Thanks very much

      Comment

      • ronverdonk
        Recognized Expert Specialist
        • Jul 2006
        • 4259

        #4
        Originally posted by th1982
        Thanks to yr reply. But can you tell me what the cron job ?
        Thanks very much
        It would be sensible to first get some understanding of the CRON principle. Therefore this link to Wikipedia CRONTAB

        There is a Cron Deamon PHP, running crons usually depends on the services of your server provider. You should contact him to inquire about the possibilities for you to run,or have run, a regular Cron job.

        Ronald

        Comment

        • th1982
          New Member
          • Feb 2008
          • 51

          #5
          Thanks so much,now i understood
          But poor for me , my hosting didnot support cron job.they said dont have this function.
          do you have another way to do that
          sorry for disturbing you so much
          thanks
          By the way can you take a look to this site:

          why is it not working in IE but working in firefox?thanks

          Comment

          • code green
            Recognized Expert Top Contributor
            • Mar 2007
            • 1726

            #6
            But poor for me , my hosting didnot support cron job.they said dont have this function.
            do you have another way to do that
            I got around this problem by setting a scheduled task on a Windows machine
            to open a browser that ran the URL of the script I wished to run.
            I am guessing that a cron can do the same thing.
            why is it not working in IE but working in firefox?thanks
            It is probably incorrect HTML syntax.
            Firefox seems to be stricter about such things

            Comment

            • ronverdonk
              Recognized Expert Specialist
              • Jul 2006
              • 4259

              #7
              Originally posted by th1982
              By the way can you take a look to this site:
              http://www.purpleasia. com/clients/VFM_test/index.php
              why is it not working in IE but working in firefox?thanks
              Originally posted by code green
              It is probably incorrect HTML syntax.
              Firefox seems to be stricter about such things
              Funny thing, usually things that work in IE do not work in FF. But here it is the other way around.

              I advise you to go to the JavaScript/DHTML forum with your problem. Easier than branching off this thread.

              Good luck

              Ronald

              Comment

              • Markus
                Recognized Expert Expert
                • Jun 2007
                • 6092

                #8
                Originally posted by th1982
                Thanks so much,now i understood
                By the way can you take a look to this site:

                why is it not working in IE but working in firefox?thanks
                Your doctype is incorrect
                and when corrected, you have hundreds of validation errors.
                validate here

                Comment

                • th1982
                  New Member
                  • Feb 2008
                  • 51

                  #9
                  I m so happy with all yr helps.
                  thank you so much. I will try to fix all these problems.
                  About auto update that I need to run it on server, but our host has no crontab.so i need the script to auto run it.
                  Thanks

                  Comment

                  Working...