Start New Discussion within our Computer Science Community

Hi I have a Csv file in website and it gets updated every half an hour, I want to copy the csv file to database(Mysql)to visualize it can anyone help.
thnx

Well, you might know that you can open a file on a web server in PHP with fopen

$fileInFile=fopen("http://www.fas.usda.gov/psdonline/download/support_tables/countries.csv", "rb");
   while(!feof($fileInFile))
   {
      $strData = fgets($fileInFile);
      printf($strData);
   }
   fclose($fileInFile);

...then parse the contents and insert into the database

This question has already been answered. Start a new discussion instead.