[thelist] matched pairs php + mysql

Maximillian Schwanekamp lists at neptunewebworks.com
Sat Sep 18 21:07:07 CDT 2004

Andrew wrote:

>I want to store a set of data in one field of a table that can be pulled
>out and formatted the same way that it was input ( style).
>eg I have a table with say 6 rows 6 columns the data input will be stored
>in one field (presumably seperated by  a comma, the data can then be
>pulled out and presented in the same way it was input, ie if r3 c4 contain
>data that is where it will be displayed on the fronted?
Not sure why you would do it this way, but perhaps PHP's serialize() and 
unserialize() would work for you here.  Your tabular data can be 
represented as an array of arrays (e.g. $arrTable), which can then be 
made into a string for storage in MySQL using serialize($arrTable).  On 
output, you would pull the data from MySQL, and use unserialize() to 
convert the string data back into your array.  If you need to go 
further, you can serialize() entire objects as well - but note the 
caveats described in PHP manual.

All this said, you might give a little more detail about what you're 
doing - maybe someone here will have a more robust solution.  Presenting 
tabular data is a classic SQL task.

Maximillian Von Schwanekamp
Dynamic Websites and E-Commerce
NeptuneWebworks.com <http://www.neptunewebworks.com/>
voice: 541-302-1438
fax: 208-730-6504

More information about the thelist mailing list