Is it possible to dump an array into a mysql text field and read it back as an array?

Question

I would like to log every submission of a web form made on our website from the $_POST array, and save it to our mysql database.

I'm outputting the following to the submission page which is obviously very readable:

print "<pre>";
print_r($_POST);
print "</pre>";

Looks like:

Array
(
    [field1] => value1
    [field2] => value2
    [field3] => value3
)

Is it possible to save it exactly like that but to a text field?

And then what about pulling that information back out of the table and converting it back to an array for processing?

No, a `print_r()` is not easily converted to the original array. Instead you should `serialize` or `json_encode` your data. — jeroen, Jul 04 '16 at 09:39
YES! see `serialize()` and `unserialise()` or I prefer `json_encode()` and `json_decode()` — RiggsFolly, Jul 04 '16 at 09:39
yes you can use json_enocde and at display time you can use json_decode. — Denis Bhojvani, Jul 04 '16 at 09:39
http://stackoverflow.com/questions/1978438/save-php-array-to-mysql — Naranca, Jul 04 '16 at 09:40
use json_encode($_POST,true); and store in text field and after fetching the field use json_decode($variable,true); decode into array — JYoThI, Jul 04 '16 at 09:43

score 1 · Accepted Answer · answered Jul 04 '16 at 09:46

1

use json_encode($_POST,true); and store in text field and after fetching the field use json_decode($variable,true); decode into array.

answered Jul 04 '16 at 09:46

JYoThI

This is perfect. Thanks all! Knew there must be a simple way... – James Wilson Jul 04 '16 at 11:19

1 Answers1