Uploading text file contents into a variable

[discostudio]

All I need to do is upload the contents of a text file into an array:

product_name|productid|image
Stanton SL1600|123212|http://www.com.com/images/1232.jpg
Stanton SL1601|123211|http://www.com.com/images/1231.jpg

First I need to im port this into a single variable then simply expload it into an array with the header values as the field names.

Then I can loop each row into my database.

I need to do it this way, as I want to check the data before uploading into the db, otherwise I would have used INFILE.

Anyone any ideas on where to start.

[leatherback]

the file function: php.net/file

[devinemke]

create an HTML form with a file input field for uploading the file. read the manual section on Handling file uploads to see examples. once the file is uploaded to your server, use the [man]file[/man] function to spool the contents of the file into an array. loop thu the array using the [man]foreach[/man] construct and use the [man]explode[/man] fucntion on during each loop iteration to get each field as an array element. each these elemenst to construct your SQL.

[discostudio]

I understand the file upload process and I also understand INFILE in mysql.

Could anyone write me a function that will output an array full of the data I need with the column names as the column names in the array, then maybe I can loop through the array like follows:

(Where $record is the outputted array var)

foreach ($record as $key => $val)
		{
if ($count==0) {$fields = "`".$key."`"; $values = $val;}
else {$fields .= ", "."`".$key."`"; $values .= ", ".$val;}
			$count++;
		}	

$query = "INSERT INTO ".$tablename." (".$fields.") VALUES (".$values.")";

[discostudio]

Here is the full insert function I use:

	function insert ($tablename, $record)
	{
		if(!is_array($record)) die ($this->debug("array", "Insert", $tablename));

	$count = 0;
	foreach ($record as $key => $val)
	{
		if ($count==0) {$fields = "`".$key."`"; $values = $val;}
		else {$fields .= ", "."`".$key."`"; $values .= ", ".$val;}
		$count++;
	}	

	$query = "INSERT INTO ".$tablename." (".$fields.") VALUES (".$values.")";

	$this->query = $query;
	mysql_query($query, $this->db);

	if ($this->error()) die ($this->debug());

	if ($this->affected() > 0) return true; else return false;

} // end insert

[devinemke]

a simple example:

<?php
$file = 'product_name|productid|image
Stanton SL1600|123212|http://www.com.com/images/1232.jpg
Stanton SL1601|123211|http://www.com.com/images/1231.jpg';

$explode = explode("\n", $file);
unset($explode[0]);
foreach ($explode as $value)
{
	$subexplode = explode('|', trim($value));
	$sql = "INSERT INTO table SET product_name = '$subexplode[0]', productid = '$subexplode[1]', image = '$subexplode[2]'";
	echo $sql . '<br>';
}
?>

[discostudio]

So how do I read the first line and use the first line as the field names?

product_name|productid|image

coz someone may upload more fields

product_name|productid|image|UPN

Sorry if I am making this complicated.

[devinemke]

discostudio wrote:

So how do I read the first line and use the first line as the field names?

<?php
$file = 'product_name|productid|image
Stanton SL1600|123212|http://www.com.com/images/1232.jpg
Stanton SL1601|123211|http://www.com.com/images/1231.jpg';

$explode = explode("\n", $file);
foreach ($explode as $key => $value)
{
	$subexplode = explode('|', trim($value));
	if ($key == 0) {$fields = $subexplode;}
	else
	{	
		$sql = 'INSERT INTO table (' . implode(',', $fields) . ') VALUES (' . implode(',', $subexplode) . ')';
		echo $sql . '<br>';
	}
}
?>

[discostudio]

Cool, that works, now I need to uild it into my code and I am definately doing something wrong.

$explode = explode("\n", $datafile); 
	foreach ($explode as $key => $value) 
	{ 
    	$subexplode = explode('\t', trim($value));
		if ($key == 0) {$fields = $subexplode;} 
    	else 
    	{
	foreach ($subexplode as $key => $value) 
		{
		$record[$fields]	=	$db->mySQLSafe($value);
		}
		$insert = $db->insert("avera_merchant_feed_data", $record);
		echo "INSERT ROW";
		}
	}

This in theory should access the insert function row by row but it don't work.

Any ideas anyone.

[discostudio]

Basically the insert function works as follows:

loop row {

$record["storeID"] 			=	$db->mySQLSafe($_POST['storeID']);
	$record["dateTime"] 		= 	$db->mySQLSafe("NOW()", "");		
	$record["notes"] 			=	$db->mySQLSafe($_POST['Notes']);

$insert = $db->insert("avera_merchant_uploads", $record);
unset($record); 
	

} loop

[discostudio]

so what i need to generate from the text file is this:

loop {

$record["columnname1"]           =      row value; 
$record["columnname2"]        =      row value;         

$record["columnname3"]             =      row value;

insertrow("talename", $record);
}

based on the values of the text file

[discostudio]

So I tried this and where am I going wrong? Just not working!

$datafile = implode('', file($_FILES['File']['tmp_name']));

$explode = explode("\n", $datafile); 
foreach ($explode as $key => $value) 
{ 
	$subexplode = explode('|', trim($value));
		if ($key == 0) {$fields = $subexplode;} 
		else 
		{
			foreach ($subexplode as $subkey => $subvalue) 
	{			
$record[$fields]	=	$db->mySQLSafe($subvalue);
echo $record[$fields] . "=>" . $subvalue; // lets see if it's corect
//$insert = $db->insert("avera_merchant_feed_data", $record);
		}
		}
	} 

[discostudio]

I changed ti to this and I am confident I am getting somewhere ut now I just cannot seem to get the column values in the second loop, as they are two different arrays:

$datafile = implode('', file($_FILES['File']['tmp_name']));

$explode = explode("\n", $datafile); 
foreach ($explode as $key => $value) 
{ 
	$subexplode = explode('|', trim($value));
		if ($key == 0) {$fields = $subexplode;} 
		else 
		{
			foreach ($subexplode as $subvalue) 
			{			
		$record["$fields"]	=	$db->mySQLSafe($subvalue);
		echo $record[$fields] . "=>" . $subvalue;
		//$insert = $db->insert("avera_merchant_feed_data", $record);
			}
		}
} 

[discostudio]

Any more advise would be appreciated as I am allmost there, any obvious coments are also appreciated, as there is something I am simply not doing right!