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
我当前的项目包含一个已有22个字段的Mysql表。
我想添加一个新字段，即永久地址。 在前端它是一个textarea，用户将使用换行符或逗号分隔填写以下数据按照此处的标准，第一个字符串将是House名称，然后是Post Office，然后是Place，然后是Pincode。
所以我想把它存储在一个coloumn中，即“permanent_address”。 所以我如何将这个逗号/换行分隔值存储到表字段中。？
可以通过将逗号/换行值转换为符号（@，＃，％，＆amp; ，*）分隔值，以便它可以存储到DB 而不会违反第一个NF
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 );