How to store MySql values as Multidimensional Array using PHP

Question

I have a database table as follows.

<table border='1'><th>Id</th><th>FirstName</th><th>last Name</th><tr><td>1</td><td>Tom</td><td>T</td></tr><tr><td>2</td><td>Jerry</td><td>J</td></tr></table>

I would like to store all values as a multi dimensional array using php(using a while loop to retrieve fields).That is, I would like the data to be echoed as:

array(array(1,Tom,T),array(2,Jerry,J));

Amber · Accepted Answer · 2010-08-30 05:29:32Z

3

$result = mysql_query("SELECT * FROM tablename;");
while($result_ar = mysql_fetch_array($result)) {
    $multid_array[] = $result_ar;
}

after which $multid_array will be an array of arrays.

answered Aug 30, 2010 at 5:29

Amber

531k89 gold badges643 silver badges558 bronze badges

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

1 Comment

Awais Qarni Over a year ago

I found it useful after 6.20 months of your answer. ;-)

Ben Rowe · Accepted Answer · 2010-08-30 05:29:31Z

0

You can use phps serialize function to convert any variable into a string representation

$string = serialize($dbData);

You can use unserialize() to convert the string back into arrays, objects, etc

$dbData = unserialize($string);

Once you have the data within a string, it's very easy to store in a file, db, etc. A disadvantage is that you won't be able to search your database easily for this data.

answered Aug 30, 2010 at 5:29

Ben Rowe

28.8k6 gold badges58 silver badges76 bronze badges

Collectives™ on Stack Overflow

How to store MySql values as Multidimensional Array using PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related