text parsing?

kaos057

I was wondering if someone could point me in theright direction. I want to be able to take a text file and make something like:

10122321 || Item1 Name || Item1 Price
32432434 || Item2 Name || Item2 Price

go into a database as id, item, price?

HalfaBee

Have a look at explode()

HalfaBee

seby

a 2 minute code:

$fp = fopen ('/home/public_html/file.txt', 'r');
while (!feof ($fp))
{
	$seperate = explode('||', str_replace(' ', '' , fgets($fp, 4096)));

mysql_query("INSERT INTO table (id, item, price) VALUES ('".$seperate[0]."', '".$seperate[1]."', '".$seperate[2]."')");
} 
fclose ($fp);

i didn't test it but it should work.

kaos057

Ok, I got the parser done but I can't figure out how to make it do one line at a time. I want it to parse one line, enter it into the table, then go to the next line and enter a new line in the table.

edit: btw I dont use a seperate file to parse, I use a text area to copy/paste the data into. I have everything working but using the format posted It just keeps making new rows in the database of the first line.

seby

you made me test it and it works just as i said. the insert query is inside a while loop so it going to loop and insert all the lines in the text file.

1) make a table called products:

CREATE TABLE `products` (
  `id` int(10) unsigned NOT NULL default '0',
  `item` varchar(50) NOT NULL default '',
  `price` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

2) create a text file called file.txt with:

123 || keyboard || $20.00
456 || speakers || $45.00

3) create a php file and add to it:

$fp = fopen ('/home/public_html/file.txt', 'r'); 
while (!feof ($fp)) 
{ 
    $seperate = explode('||', str_replace(' ', '' , fgets($fp, 4096))); 

mysql_query("INSERT INTO products (id, item, price) VALUES ('".$seperate[0]."', '".$seperate[1]."', '".$seperate[2]."')"); 
}  

fclose ($fp);

4) Change the path above to the full path to the file.txt

5) save everything and upload, now run the php file via browser and check your database table.. you should see two rows.

kaos057

Ok that works as long as I have the extra text file to read the data from but is it possible to do it with a submitted text area that has the data copied/pasted in it?