[SOLVED] php split

[Nandini]

hi all

i am so worrying about php split.

i have a textarea field with values as

 

abc=123

qqqqqqq=938

eeeeeee=87373

etc

 

I dont know how much lines of data user will be enter.

 

I want to split that data by line wise and store those values into mysql table as follows.

 

----------------------------------------------------------------

id        keyword            data

----------------------------------------------------------------

1        abc                  123

1        qqqqqqq          938

1        eeeeeee          87373

-----------------------------------------------------------

 

number of lines are not constant. In this scenario number of lines are 3. in future it will be 4 or 7 or 10 etc.

 

Can any one send me script

 

Its urgent , pls

 

 

 

 

[shatner]

$data = '
abc=123
qqqqqqq=938
eeeeeee=87373
';

$records = explode("\n", $data); // split the data up line by line

foreach($records as $record){ // loop through each line
$bits=explode('=', $record);  // split the line by the '='
$text = trim($bits[0]); //  1st bit of the line
$number = trim($bits[1]); // 2nd bit of the line

echo $text . '' . $number . '<br>'; // print it back out
}

[DarkWater]

We aren't here to just right scripts for you.  Just use explode(), like shatner demonstrated.  It's pretty simple.  And is there a reason why every row has the same ID?

[Nandini]

Every row has the same id means

those details are belongs to one user.

So for every user can insert those values.

So for every user that id incremented by 1.

see this

 

----------------------------------------------------------------

id        keyword            data

----------------------------------------------------------------

1        abc                  123

1        qqqqqqq          938

1        eeeeeee          87373

2        abc (2nd user)                  123

2        qqqqqqq(2nd user)          938

2        eeeeeee(2nd user)          87373

-----------------------------------------------------------

 

Hi shatner.

 

Thanx for your help. how can i store these values as shown in the previous table

[Nandini]

topic solved by using insert command within foreach loop.

 

thanx for everyone.