Importing CSV textfile into MySQL database

Dillenger

Can anyone tell me why this isn't working???


<?
		  if ($REQUEST_METHOD=="POST") {
		$date = date("Y-m-d");
		$published = "NO";
		  $sql = 'LOAD DATA LOCAL INFILE $textfile INTO TABLE `test` FIELDS TERMINATED BY \',\' OPTIONALLY ENCLOSED BY \'"\' ESCAPED BY \'\\\\\' LINES TERMINATED BY \'\\r\\n\''; 
		  $result = mysql_db_query($db,"$sql",$connect);
			if (!$result) {
		echo("ERROR: " . mysql_error() . "\n$sql\n");
		  }else{
		  echo "Data uploaded to database";
		  }
		  }

	  ?>

sneakyimp

what sort of error/problem are you having? need more info to diagnose.

i recall having some trouble loading files because of permissions. i was using phpMyAdmin and it simply wouldn't import the data even though the user was authorized, etc. i eventually had to log in as root to do it....total pain...never did figure out exact problem

Dillenger

I finally figured it out now...

i had to use the complete root address. like home/usr/local/ blah blah blah, then it worked... the problem was with permissions with me too.