在单个MYSQL单元格中插入多个值

Can anyone suggest me how can i store Multiple values in a single MySQL cell using Php? I am simply using the insert function but it is not helpfull at all.

No, no no, no, NO!

Never store multiple values in a single cell. It will always get back to you. It is against the 3rd rule of DB normalization.

Insert only single values in a cell and add multiple records if you must. Example

photos table:          id  | filename
                       1   | 'myfoto.jpg'

comments table:       photo_id | user_id  | comment
                      1        | 23       | 'great picture'
                      1        | 99       | 'nice'
                      1        | 7        | 'do not like it'

Although I fully agree with the previous answer that it's really bad practice to store multiple values in a single cell, in some special occasions and with certain limitations you can do this.

So, if you insist, you need to make a string containing all your values. The easiest way is to separate them with comma, line break or some other character which doesn't appear / forbidden in the actual values. Make sure to sanitize them first, though.

If your values are more complex, you can put them into array and use PHP serialization (serialize/unserialize) or json encoding (json_encode/json_decode).

Once you get have your string, simply use UPDATE query to update that DB row.