How to extract data from a post meta serialized array?

Use unserialize() to convert it into an array.

$mydata="a:5:{s:9:"engine_id";a:1:{i:0;s:9:"300000225";}s:15:"transmission_id";a:1:{i:0;s:6:"257691";}s:5:"plant";a:1:{i:0;s:23:"Oshawa, Ontario, Canada";}s:15:"Manufactured in";a:1:{i:0;s:6:"CANADA";}s:22:"Production Seq. Number";a:1:{i:0;s:6:"151411";}}";
$mydata = unserialize($mydata);
echo $mydata['Manufactured in'][0];

Edit– Related thought- something to keep in mind when storing meta data serialized like this is that you limit your ability to use that data in queries, if that’s a concern for you. for instance, it’s not so easy to write queries like “show me all parts manufactured in Canada”, or order results by engine id, since that data is tucked away with a bunch of other data in one field.

Related Posts:

  1. How to store post meta in an array?
  2. get_*_meta doesn’t always return an array
  3. Unset field from an array not working as expected
  4. Post meta as array looks like string instead of array
  5. Time & Date on Post – Time Ago Custom Function
  6. Can A Post Meta Field Store multiple values that are not in an array?
  7. Array of user ids to list of user names
  8. update_post_meta() updating nested array in Multidimensional array with empty sub-array
  9. How can I update this array built from post meta data?
  10. What format is this and how to get value “lal” and “pila” from it
  11. How to get posts by meta value as multi-dimensional array?
  12. Multiple meta key and value search in the query
  13. Fetching array of postmeta with $wpdb and in_array conditional
  14. wp_postmeta store multiple values in one key [closed]
  15. How do I retrieve the slug of the current page?
  16. Most efficient way to get posts with postmeta
  17. Get posts by meta value
  18. Explanation of update_post_(meta/term)_cache
  19. How to save an array with one metakey in postmeta?
  20. WordPress is stripping escape backslashes from JSON strings in post_meta
  21. How can I get the post ID from a WP_Query loop?
  22. Check if Post Title exists, Insert post if doesn’t, Add Incremental # to Meta if does
  23. How to update_post_meta value as array
  24. Adding meta tag without plugin
  25. What’s the point of get_post_meta’s $single param?
  26. What is the different between an attachment in wp_posts and an attachment in wp_postmeta?
  27. How to edit a post meta data in a Gutenberg Block?
  28. Sanitizing integer input for update_post_meta
  29. post formats – how to switch meta boxes when changing format?
  30. Execute action after post is saved with all related post_meta records (data)
  31. Lack of composite indexes for meta tables
  32. Get a single post by a unique meta value
  33. if get_post_meta is empty do something
  34. How we get_post_meta without post id
  35. How get post id from meta value
  36. What is the code to get the download link for a product in WooCommerce?
  37. Safe to delete blank postmeta?
  38. advanced custom fields update_field for field type: Taxonomy
  39. update_post_meta not saving when value is zero
  40. Content hooks vs User hooks
  41. Meta compare with date (stored as string) not working
  42. When using add_post_meta and update_post_meta, is there any way to give the individual arrays keys?
  43. Trying to get custom post meta through Jetpack JSON API [closed]
  44. How to update/insert custom field(post meta) data with wordpress REST API?
  45. How can merge two arrays values in one array and save in database
  46. Restrict post edit/delete based on user ID and custom field
  47. get_post_meta returning empty string when data shows in the database
  48. publish_post action hook doesn’t give post_meta_data
  49. Remove WordPress.org Meta link
  50. Remove post meta keys
  51. How to access the post meta of a post that has just been published?
  52. Why time functions show invalid time zone when using ‘c’ time format?
  53. Why is get_post_meta returning an array when I specify it as single?
  54. How to update/delete array in post meta value?
  55. How to get all term meta for a taxonomy – getting term_meta for taxonomy
  56. Adding an assisting editor box to Post page
  57. Is it possible to store arrays in a custom field?
  58. delete unused postmeta
  59. Should I sanitize custom post meta if it is going to be escaped later?
  60. How to update single value in multi dimensional Post Meta?
  61. Add post meta based on another post meta value before publish post
  62. How do I retrieve multi-dimensional arrays from the wp_postmeta table, & display on a website?
  63. Front-end update_post_meta snippet displays white screen?
  64. Query between two meta values?
  65. Save both current and new version of post meta
  66. Get Advanced Custom Fields values before saving [closed]
  67. Give extra post-meta to RSS feeds
  68. How to get meta value in wp_attachment_metadata
  69. WP REST API “rest_no_route” when trying to update meta
  70. Clean up output added via wp_head()
  71. List posts under meta_value heading
  72. Why am I getting an infinite loop with have_posts?
  73. get_post_meta – get a single value
  74. delete value 0 in post meta [closed]
  75. update_post_meta from data in multidimensional array created from a form
  76. Can I safely delete a record, manually, in the wp postmeta table?
  77. What action hook updates post meta?
  78. Can’t translate the post meta data (Date) in another language
  79. get_post_meta / update_post_meta array
  80. WP Meta Query for some meta (array) values
  81. adding a URL to a post meta
  82. Exclude a category from the filed under list
  83. Compare two meta key values against each other inside the get_posts array?
  84. Short of raw SQL, can I query for multiple attachment metadata that have a given array key?
  85. How do I access post meta data when publishing a new post in Gutenberg?
  86. update_post_meta() not working when used with WordPress action
  87. Using Advanced Custom Field (ACF) to insert meta description on each page
  88. Triple meta_key on custom SELECT query
  89. get_post_custom()
  90. Adding meta data to an attachment post
  91. update_post_meta not adding anything.(Nor add_post_meta)
  92. loop through all meta keys with get_post_meta
  93. Get posts by meta value with date
  94. How to add meta tag to wordpress posts filter?
  95. Are multiple values from get_post_meta guaranteed to be ordered?
  96. Automatically adding meta data to posts or multiple query help
  97. Identifying Importer Posts
  98. Get updated post meta on save_post action?
  99. Get post from meta_key and meta_value
  100. Add a post metadata if only the key and value does not exist

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)