Is storing php array in mysql as serialized harmful?

Question

I have some data data as array in php and i am storing this as serialized in mysql table in a single column. Does this have any potential harm ?

Uday Sawant · Accepted Answer · 2011-12-14 07:46:12Z

2

You can use "mysql_real_escape_string()" to escape unwanted codes before storing the data in mysql. Also stripslashes() and addslashes() functions are available. These functions escapes special characters in a string so you can store and retrieve the data safely.

Still it may affect the performance to some extent.

answered Dec 14, 2011 at 7:46

Uday Sawant

5,8083 gold badges35 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hacker Over a year ago

Yeah i do use mysql_real_escape_string always. I feel its better then storing these records in multiple rows in another table to storing all in single column in same table.

Collectives™ on Stack Overflow

Is storing php array in mysql as serialized harmful?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related