How to store an array(of strings) in phpMyAdmin

Question

is there a way to store an array in phpMyAdmin.

I know there are probably a few but I was wondering which would be the best with CodeIgniter.

My issue is I want to add the data via CodeIgniter Model and I can't find any reference about arrays.

Solution

first of all phpmyadmin isnt where the data is stored, phpmyadmin is an interface for mySQL databases. http://www.phpmyadmin.net/home_page/index.php

That being said, mySQL databases cannot store 'an array', only datatypes such as ints, strings, datetimes etc

A possible solution is to covert your array of strings into one long string (php -implode) and store it as a single string in your database.

Then when you pull it out of the database, separate it back into an array of strings (php str_split)