How can I read the value from mysql using PHP

Question

Following is a value I am seeing in one of my fields in mysql for wordpress database

a:2:{i:0;i:31;i:1;i:23;}

What is this format? How can I get the valued of alternate I using PHP ?

question from:https://stackoverflow.com/questions/65918317/how-to-get-serialized-data-out-of-database-and-show-the-right-valuewordpress-wo

Answer 1

That is a serialize()'d variable, you can use unserialize() to convert back to the appropriate datatype - in this case an Array with Integer indexes and values.

For WordPress there is a function called maybe_unserialize() which is useful for database values if you aren't sure if it has been serialized or not.