[RESOLVED] Text file uploads

[discostudio]

Here's the thing, I need to be able to accept data by text files in the following format:

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

But here's the catch, there is actually 8 possible columns and they could be ordered in any order.

I need to read the file and output the following information row by row:

loop {
$record["columnname"]       =      "column value for that row";  

} 

Then once the array is populated for each row, I have a function that inserts a row of data like this:

insertrow("talename", $record); 

so what it sould really do is this:

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

rowloop {
// build row in an array suing column names as keys
$record["columnname1"]       =      "column value for that row";  

$record["columnname2"]       =      "column value for that row"; 
$record["columnname3"]       =      "column value for that row"; 
$record["columnname4"]       =      "column value for that row"; 

insertrow("talename", $record);
}

I have allready asked this on this forum today in a different context, maybe I am making the problem a little easier for someone else to understand.

If anyone has any idea what I am talking about, please Help!!!!

[konsu]

i do not have an idea what you are talking about. do you want to write code that splits a string of characters using the pipe character as separator? or are you looking for help determining which column is which?

[AstroTeg]

I think what you'll need to do is identify each element number and what its column name is. Start by working on the first row (the one with the column names). Read them in and keep track of their name and the order you found them in (an array will work great for this).

Then you can move onto the second row (where your data lives) and read it in. Once in, you'll need to assign it. You'll know which position is which by the first row array you've built. You can retrieve the column name and store the column name as the key of the new array and the row value (from line 2) as the value (if that makes sense). Its pretty tough to explain and I don't have enough time to write a code sample. I'd recommend breaking the problem into smaller, solvable parts. Start off with the first row and find a way to associate the column name with the element position you found it in in the file.

[discostudio]

This was soooooooo close to what I need:

devinemke wrote:

<?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>';
	}
}
?>

This works absolutely perfect, but as I use a insert function for all my sql row inserts, I need to create the array as shown in my first post.

[AstroTeg]

Are you looking for a copy and paste solution?

[discostudio]

I'm not asking for you guys to do the work for me, it's just I am having real trouble with this one, as I have real problems understanding multidimensional arrays and foreach looping etc.

Just need another example, then maybe I might get the hang of it.

[konsu]

to solve your problem, you need to have an array with the list of field names in the right order. then once you have this list you just implode it as the code that you posted last does. to determine the right order, read the first line from the file, and go through every field separated by the pipe and determine the type of the field and put the field name corresponding to this field in to the appropriate position in the array of field names.

[discostudio]

That's great, I kinda get the general jist of what I need to do, what I could do with is a code example of how to do it.

[konsu]

does your file always contain the list of field names in its first line?

[discostudio]

Yes allways, the only clause is there can be upto 8 field names and they can be in any order.

[konsu]

so then the code by devinemke seems correct. why did you say it does not work?

[discostudio]

Because the way he did it I just loop aound a mysql statement.

I need to build an array use my insert function, delete the array and then start again, row by row.

Tell me if I am not making any sense.

[konsu]

<?php 
$file = 'product_name|productid|image 
Stanton SL1600|123212|[url]http://www.com.com/images/1232.jpg[/url] 
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 = do_insert($fields, $subexplode);
        echo $sql . '<br>'; 
    } 
} 

function do_insert($fields, $values)
{
    return 'INSERT INTO table (' . implode(',', $fields) . ') VALUES (' . implode(',', $values) . ')'; 
}
?> 

[discostudio]

That's good but here's the insert function I need it to work with:

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

[konsu]

ok, i see now. if your original question was something like "how do i create an association array for each line in a text file where the first line contains the list of keys and the subsequent lines contain elements for these keys?" it would have saved a lot of confusion ; -) also, the below code i am sure can be simplified by using the php's built-in array functions.

<?php  

$file = 'product_name|productid|image 
Stanton SL1600|123212|[url]http://www.com.com/images/1232.jpg[/url] 
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  

    {
        $i = 0;
        $record = array();

    foreach ($fields as $field)
    {
        $record[$field] = $subexplode[$i];
        $i++;
    }
    insert($tablename, $record); 
}  
}  

?> 

[discostudio]

OK this is the result I get:

Array
(
    [MPN	Manufacturer Name	UPC	Product Name	Product Description	Product Price	Product URL	Image URL	Dealtime.co.uk Categorisation	Stock Availability	Stock Description	Standard Shipping	Weight] => Proel	2889	19" Vented Rack Panel	Available in various sizes, these panels block access into a rack but allow air to pass through for ventilation.	415.00	http://www.discostudio.co.uk/djshop/product_info.php?product_id=100709&affid=dealtime	http://www.fxmedia.co.uk/images/discostudio/100709t.jpg	Musical Instruments	Y	Next Day Delivery	0.00	0.0
)
Array
(
    [MPN	Manufacturer Name	UPC	Product Name	Product Description	Product Price	Product URL	Image URL	Dealtime.co.uk Categorisation	Stock Availability	Stock Description	Standard Shipping	Weight] => Proel	2890	19" Vented Rack Panel	Available in various sizes, these panels block access into a rack but allow air to pass through for ventilation.	415.00	http://www.discostudio.co.uk/djshop/product_info.php?product_id=100709&affid=dealtime	http://www.fxmedia.co.uk/images/discostudio/100709t.jpg	Musical Instruments	Y	Next Day Delivery	0.00	0.0
)

This feed uses tab delimited [\t] not a pipe but does this look as it should?

[konsu]

i do not understand the question. what is this output of?

[discostudio]

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

$explode = explode("\n", $datafile);   

foreach ($explode as $key => $value)   

{   

    $subexplode = explode('\t', trim($value));   

    if ($key == 0) {$fields = $subexplode;}   

    else   

    { 
        $i = 0; 
        $record = array(); 

    foreach ($fields as $field) 
    { 
        $record[$field] = $subexplode[$i]; 
		            $i++; 
    }
[b]print_r($record);[/b]
    //insert($tablename, $record);  
}   
} 

I replaced the insert with print_r() to see if the array was ok, but that wouldn'twork with my insert function. So since I don't understand foreach and multiple level arrays I was wondering if you had any idea where it went wrong?

[konsu]

what are the contents of the file?

[discostudio]

MPN	Manufacturer Name	UPC	Product Name	Product Description	Product Price	Product URL	Image URL	Dealtime.co.uk Categorisation	Stock Availability	Stock Description	Standard Shipping	Weight
	Proel	2889	19" Vented Rack Panel	Available in various sizes, these panels block access into a rack but allow air to pass through for ventilation.	415.00	[url]http://www.discostudio.co.uk/djshop/product_info.php?product_id=100709&affid=dealtime[/url]	[url]http://www.fxmedia.co.uk/images/discostudio/100709t.jpg[/url]	Musical Instruments	Y	Next Day Delivery	0.00	0.0
	Proel	2890	19" Vented Rack Panel	Available in various sizes, these panels block access into a rack but allow air to pass through for ventilation.	415.00	[url]http://www.discostudio.co.uk/djshop/product_info.php?product_id=100709&affid=dealtime[/url]	[url]http://www.fxmedia.co.uk/images/discostudio/100709t.jpg[/url]	Musical Instruments	Y	Next Day Delivery	0.00	0.0