Copying a Csv file from web page to database

[rahulroshan]

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

[thines01]

Do you program?

[rahulroshan]

Yes , I know basics of Php,sql and python

[thines01]

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