PHP-将逗号分隔的字符串转换为Dot或Symbol分隔值，以便存储在MySql中

Question

My current project consist of a Mysql table having 22 fields already.

I want to add a new field namely Permanent address. in the front-end its a textarea in which user will fill the following data's with either newlines or comma separated As per the standard of here, First string will House name, then Post office, then Place, then Pincode.

So I want to store it in a single coloumn namely "permanent_address". so how I store this comma/newline separated values into table field.?

Can it achieved by converting the comma/newline values into symbol ( @,#,%,&,* ) separated values, so that it can be stored to DB without violating 1st NF

Answer 1

You can use explode function to split the text into different parts. It will work like this,

$parts = explode(",",$input);  // this will split input in array, $input will have the text input
$street_name = $parts[0];      // gives the first part 

If you want to split by both "," and new line " ", you can use,

$parts = preg_split( "/[,|
]/", $input );