[RESOLVED] Assigning lines to an array or db

[iantimmy123]

I have a page where a user will enter information copied from an email into a text box part of a form such as below

TransactionId : 21884948
Custref : 6988822309
Product : 359672006270600
SID :

TARRIFF : VZ2253MHP

I am looking to put each piece of information into a field in a MYSQL table or into an array but am unsure how to break up the information. The problem i'm having is that there is nothing but a new line between one piece of information and the next title and that sometimes there will be blank spaces instead if information.

Any help appreciated.

Thanks

[NogDog]

(Untested)

$lines = preg_split("[\r\n]+", $_POST['text']);
$data = array();
foreach($lines as $line)
{
  list($key, $value) = explode(':', $line);
  $data[trim($key)] = trim($value);
}

At this point $data should be an associative array which you can reference to insert/update your database, or whatever else you want to do with it.

[iantimmy123]

Thanks for that but i'm getting the message

Warning: preg_split() [function.preg-split]: Unknown modifier '+' in C:\Program Files\xampp\htdocs\CPC\processsubmitcase.php on line 56

Warning: Invalid argument supplied for foreach() in C:\Program Files\xampp\htdocs\CPC\processsubmitcase.php on line 58
Array ( )

[NogDog]

Oops:

 $lines = preg_split("/[\r\n]+/", $_POST['text']);

[iantimmy123]

Superb, thanks a lot mate. Going to try and work out now what it all means lol.