[RESOLVED] PHPMysql trouble

dannyb77

I realise this may be more of a Mysql question, but if anyone could help, that'd be great.

I'm having real difficulties loading data into my database from a CSV file.

I've managed to import the data from a copy of the CSV on my own machine (using LOAD DATA INFILE 'c:\program files\xampp\htdocs\uniq.csv' etc etc etc).

However, the CSV I will be eventually using will be stored and updated online by someone else at, for example, www.example.com. I tried the same thing (LOAD DATA INFILE 'http://www.example.com/newbie.csv' etc etc etc) but it comes up with the error "FILE 'http://www.example.com/newbie.csv' not found". I have also tried putting \s in the URL but it comes up with the same error.

Is there any way to do this?

Many thanks,

Dan :-)

bradgrafelman

Use something like [man]file_get_contents[/man] to retrieve the remote file, write the contents to a local file, use that local file with the "LOAD DATA INFILE," and delete it when you're done.

dannyb77

Awesome...thanks! I'll give it a go and let you know how I get on?

dannyb77

Thanks to Brad...after following his advice this was the solution I came up with:

<?php
$url = file_get_contents("http://www.example.com/sample.csv");
file_put_contents("sample.csv", $url);
$sql1 = 'TRUNCATE TABLE sample';
$sql = 'LOAD DATA LOCAL INFILE \'C:\\\\Program Files\\\\xampp\\\\htdocs\\\\sample.csv\' REPLACE INTO TABLE `sample` FIELDS TERMINATED BY \',\' OPTIONALLY ENCLOSED BY \'"\'';

mysql_query($sql1) or die("Error 1");
mysql_query($sql) or die ("Error 2");
?>

That automatically reads the file stored on the web by my colleagues, and updates my database every time someone goes through the page.

THANK YOU!