CSV Upload

[l12852]

Hi, I have a script that will upload a CSV file into MySQL. The file has some quotation marks around the values. This script seems to get rid of those. Now I have a file without quotation marks around the values; they are only separated by a comma. seems simple, but I can't get them load. I was wondering if anybody see's something I don't in these few lines of code that is preventing me from uploading this new file type.

$openit = file($UPLOAD_PATH."/".$name);
$filearray = file($UPLOAD_PATH."/".$name);
$rowcount = count($openit);
$validrecords = $rowcount; $counter_fail = 0;
$counter_succ = 0;
for($j=0; $j<$rowcount; $j++)

{
$item = explode("$separator", $filearray[$j]);

In summary, if none of my values have a comma around them, it doesn't work, if they do, then it works

[sneakyimp]

Don't double post. 🙁

[l12852]

In summary, if my values have a quotation mark around them, it doesn't work, if they do, then it works

[sneakyimp]

Don't Double Post, Butthead.

[l12852]

$UPLOAD_PATH = "/home/content/w/e/s/western/html/load/";

$UPLOAD_NUM = 2;

function displayUploadedList ()
{
global $UPLOAD_PATH,
$UPLOAD_NUM,
$_FILES;

$address ="?";
$user = "?";
$pass ="?";
$mydatabase = "?";
$mytable = "autos";
$separator = ",";
$noconnection = "Error: Could not connect to database. Please try again later!";
@ $db = mysql_pconnect("$address", "$user", "$pass");
mysql_select_db($mydatabase);

// Connect to the database - exit if connection fails
if (!$db)
{
	?>
	<span class=Error><?=$noconnection?></span>
	<?	

	return false;
}

mysql_query("delete from $mytable");


$buff = '';
$error = 0;
for ($i = 0; $i < $UPLOAD_NUM; $i++)
{
	$name = $_FILES["File$i"]['name'];        
	$tmp  = $_FILES["File$i"]['tmp_name'];   

	if (!is_uploaded_file ($tmp))                     
		continue;

	$buff .= "<li class=Text><b>".$name."</b>";

	if (!@move_uploaded_file($tmp, $UPLOAD_PATH."/".$name)) 
	{
		$error = 1;
		continue;
	}

	$openit = file($UPLOAD_PATH."/".$name);
	$filearray = file($UPLOAD_PATH."/".$name);
	$rowcount = count($openit);
	$validrecords = $rowcount;          
	$counter_fail = 0;
	$counter_succ = 0;
	for($j=0; $j<$rowcount; $j++)         
	{

$item = explode("$separator", $filearray[$j]);
include("query.inc");

$result = mysql_query($query);
if ($result)
{
$counter_succ++;
}
else
{
$counter_fail++;
}
}

	$buff .= "<ul class=Text><li>$counter_succ of $validrecords records added</li>";
	if ($counter_fail > 0)
	{
		$buff .= "<li class=Text>$counter_fail records <font color=red>failed</font> to be added</li>";
	}

	$buff .= "</ul></li>";
}

if (strlen ($buff) == 0)
{
	?>
	<span class=Warning>Select at least one file to upload.</span>	
	<?	
	return false;
}
else if ($error)
{
	?>
	<span class=Error>Some of the selected files have not been uploaded.</span><br>
	<span class=Text>Check the existence of upload directory: <b><?=$UPLOAD_PATH?></b> and your permissions.</span>	
	<?	

	return false;
}

?>
<span class=Message>The following files have been uploaded</span>
<ul class=Text><?=$buff?></ul>

[l12852]

"value1","value2","value3" this works
value1,value2, value3 this doesn't