[RESOLVED] can i use a text form field to add multipul records

The_Stig

I have a form that i can paste in title disc date ect but only one item per field

i know their is a way to paste in the info like below but how do i do it? Please

title,decs,dates
title,decs,dates
title,decs,dates
title,decs,dates
title,decs,dates

leatherback

This is completely unclear.

What are you trying to do? Create a form with several repetitions of the same fields? Or..?

Please clarify

devinemke

is this what you mean?

$text = 'title1,decs1,dates1
title2,decs2,dates2
title3,decs3,dates3
title4,decs4,dates4';

$explode = explode("\n", $text);
foreach ($explode as $value)
{
	$sql = 'INSERT INTO table VALUES( ' . trim($value) . ')';
	echo $sql . '<br>';	
}

The_Stig

I have some product that need adding to our SQL DB products table and i want to enter them in a lot faster I don't want to have to upload them into SQL direct as many members of staff will be working on this.

at the momnet we have a php form that has text field boxes ie

title box
disc box
date box

ect

but i have seen in the past were multipul lines of data have been added on some other scripts as lines of data pasted into one text box on a form ie
title,desc,date ie the title seperated by a , were one line of data is pasted per row in the table ie
1,title,desc,date
2,title,desc,date
3,title,desc,date
4,title,desc,date
5,title,desc,date
6,title,desc,date

each one of the lines above are a record that needs adding to the SQL DB table

is their a way to set it as this type of form entry ie a multipost ect?

leatherback

Hi Devinemke's code is what you are looking for. Interpret the $text variable as a variable which was submitted from a form.

So in the form you place:
title1,decs1,dates1
title2,decs2,dates2
title3,decs3,dates3
title4,decs4,dates4'

and het code will process the subm itted data.