storing post information in mysql as array

Question

How would i go about taking all information thats submitted via POST to a page, and storing it in a db as a readable array

Right now i have this function:

    $mysql = mysql_query("INSERT INTO `table` (`sid`, `contents`) VALUES ('$sid', '$contents')") or die(mysql_error());
    if($mysql){
    return TRUE;
    }else{
    return FALSE;
    }

when i pass $_POST for $contents, all i get in the db is Array I need some way of reading the post values, converting them to something readable, storing them, and then being able to get them back out and loop through the info again

Crash course PHP/MySQL: oreillynet.com/pub/a/php/2003/12/23/php_foundations.html — nash
– nash, Commented Nov 23, 2009 at 9:17

nash · Accepted Answer · 2009-11-23 09:24:26Z

2

Although you can serialize an array and store it in a MySQL field, I wouldn't recommend going about it this way. You don't expose what you are trying to achieve in your question, but I think you're just starting out using MySQL.

The way that I'd recommend is just designing a proper table with columns named after the values you wish to store, and then to create a proper query to store the values separately, not as a big serialized array.

Here's a crash course: http://www.oreillynet.com/pub/a/php/2003/12/23/php_foundations.html

answered Nov 23, 2009 at 9:24

nash

2,19115 silver badges18 bronze badges

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

Comments

karim79 · Accepted Answer · 2009-11-23 09:27:09Z

1

Use serialize:

Generates a storable representation of a value This is useful for storing or passing PHP values around without losing their type and structure.

Example:

// turn $_POST into a string that can be reconstructed to its original array form
$postStr = serialize($_POST);

Use unserialize to recover the string as an array:

// give me back my array
$postArr = unserialize($postStr);

Make sure to correctly escape your string using mysql_real_escape_string prior to inserting in the database.

edited Nov 23, 2009 at 9:27

answered Nov 23, 2009 at 9:14

karim79

343k67 gold badges420 silver badges409 bronze badges

Comments

dfilkovi · Accepted Answer · 2009-11-23 09:15:09Z

1

You need to serialize http://php.net/manual/en/function.serialize.php and then store the POST data.

To fetch it you need to unserialize it after fetching

answered Nov 23, 2009 at 9:15

dfilkovi

3,0917 gold badges42 silver badges51 bronze badges

Comments

cort · Accepted Answer · 2009-11-23 09:37:47Z

1

+1 to nash. What you want to achieve is against the database normalization. You may think that it's a good idea now but you'll feel remorse soon. If you're unconfortable with the database level, you could try a ORM.

answered Nov 23, 2009 at 9:37

cort

1,1262 gold badges12 silver badges21 bronze badges

Collectives™ on Stack Overflow

storing post information in mysql as array

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related