Insert array data into database column with mysql

Many times we need to store #array in #database with because may we don’t want to create all specified fields with names in #database table, so we just inserted, and here is example that I want to save whole #array data in database table field mysql.

$save_array = array(
		'sd_sitename' => 'SDTuts'
		,'sd_blogurl' => 'http://www.sdtuts.com'
		,'sd_author' => 'Rameez Soomro(Faisal Ahsan)'
		,'sd_post_name' => 'Insert array data into database column with mysql'
		,'sd_script_name' => 'php'
		,'sd_cms_name' => 'WordPress'
);

mysql cannot allow you to save array like above array style, there are 2 method to store a data in database table column

1. json

SAVE WITH JSON

$save_array = json_encode($save_array);
// RUN MYSQL QUERY INSERT OR UPDATE

RETRIEVE WITH JSON

///RUN A MYSQL QUERY TO GET COLUMN WHERE WE STORED JSON DATA
$saved_array = json_decode['saved_json_data'];

2. serialize

SAVE WITH SERIALIZE

$save_in_db  = serialize($save_array);
//RUN MYSQL INSERT QUERY

RETRIEVE WITH

//RUN QUERY TO GET SAVE DATA FROM TABLE
$save_in_db  = unserialize($retrieved_data['my_saved_data_serialize_format']);