get_post_meta and add_post_meta not working

You’re saving the transaction details as a serialized object in post-meta and then you’re trying to search for a specific order ID. Your problem is here:

$data = get_post_meta( $ggowlccpy_order_id, $key = '_ggowlccpy_refund_details_get',
                       $single = false );

get_post_meta requires a post ID but you’re passing it the order ID you want to search for.

How to search for the order ID? The problem is that it’s packed into a serialized object. One way would be to also store the order ID as a separate meta value so that you can search for it directly, e.g. (untested sorry)

add_post_meta( $post->ID, '_ggowlccpy_merchant_ref', $ggowlccpy_order_id);

$meta_query = new WP_Meta_Query(array(
                  meta_key = '_ggowlccpy_merchant_ref',
                  meta_value = $ggowlccpy_order_id,
                  compare="="));
$orders = $wpdb->get_results($meta_query->get_sql( 'post', $wpdb->posts, 'ID' ));

It won’t be possible to match the existing serialized value: you’re base64-encoding it to obscure the value in the database. (At least I guess this is to obscure it: you don’t generally need to base64-encode the output of PHP serialize value.) If this wasn’t base64-encoded then you could e.g. serialize the order ID and then search for _ggowlccpy_refund_details_get values that are LIKE (i.e. contain as a substring) the serialized order ID, then deserialize all of the results and check each one for merchant_ref = order ID until you find the correct one. However if you do need to query by this then I think a separate new post_meta value is easier and better.

Related Posts:

  1. Most efficient way to get posts with postmeta
  2. How to update_post_meta value as array
  3. What’s the point of get_post_meta’s $single param?
  4. Get a single post by a unique meta value
  5. advanced custom fields update_field for field type: Taxonomy
  6. update_post_meta not saving when value is zero
  7. Trying to get custom post meta through Jetpack JSON API [closed]
  8. Why time functions show invalid time zone when using ‘c’ time format?
  9. Why is get_post_meta returning an array when I specify it as single?
  10. delete unused postmeta
  11. Add post meta based on another post meta value before publish post
  12. WP REST API “rest_no_route” when trying to update meta
  13. delete value 0 in post meta [closed]
  14. Can I safely delete a record, manually, in the wp postmeta table?
  15. What action hook updates post meta?
  16. Exclude a category from the filed under list
  17. How do I access post meta data when publishing a new post in Gutenberg?
  18. How to add meta tag to wordpress posts filter?
  19. Are multiple values from get_post_meta guaranteed to be ordered?
  20. Add a post metadata if only the key and value does not exist
  21. Correct processing of `$_POST`, following WordPress Coding Standards
  22. Metabox Data not being saved [closed]
  23. How can I get values using key in Carbon Fields from Multiselect?
  24. WordPress Action Hooks and Post ID?
  25. Options to get my custom post type metadata via the WordPress API
  26. Generate an Email address from that of the Post Author
  27. Get page->parent’s name?
  28. How to get the total number of meta_values based on a custom post type?
  29. conditional function to change post-meta background image
  30. Does “update_post_meta” check if value is the same before updating?
  31. Custom meta field don’t give me numerical value
  32. how to get all post with the same post meta?
  33. Update Line Item Meta Data – WooCommerce API
  34. Echo page title from page with custom meta datetime picker
  35. MySQL Query To Select Post By Postmeta
  36. Unset field from an array not working as expected
  37. Update post_meta with WooCommere variation data
  38. Copy content stored in meta to post content
  39. How to programmatically customise the Contact Form7 notification email prior to sending? [closed]
  40. Saving repeated option values when querying in Published, draft and all
  41. How to hide meta block(s) in certain post format
  42. What type of index should I use for postmeta?
  43. Get a row from a separate table by matching a posts meta_key to a tables ID column
  44. need some assistance with the checkboxes (selecting/deselecting featured posts)
  45. get_post_meta() not work for the first post inside the loop
  46. Adding new value to existing meta key
  47. how to get a list of meta data fields assocaited with a custom post type
  48. Gutenberg: How to display meta field data in the block frontend (save function)
  49. Reset/delete post views meta/custom field after X hours or minutes or seconds
  50. String taken from database table post_meta is showing HTML tags on Frontend
  51. Have lots of meta for posts, is it better to get at all at once or each individually
  52. Delete posts based on post meta data
  53. Query posts WITHOUT a custom meta field
  54. Add box with custom per-page properties
  55. get_post_meta not working when variable used for post ID
  56. Update post meta dynamically
  57. How do I edit the posted “by” and “on” in the post meta
  58. How to delete duplicate records in wp_postmeta database table?
  59. Need a SQL query to update meta_key=’_price’ with value in meta_key=’_regular_price’
  60. Display current user’s custom post meta in sidebar
  61. update_post_meta() adding bits in database [closed]
  62. Get posts ordered by meta data
  63. How to get single value from get_post_meta() array of values?
  64. Displaying values from related field – if empty shows current post type’s link and title
  65. get_post_meta inside echo [closed]
  66. WordPress postmeta: Store data as an array or single item?
  67. wordpress update multiple posts post meta
  68. Display Post Meta in Header
  69. Array of user ids to list of user names
  70. Conditional For get_the_author_meta
  71. Custom fields or something else
  72. Count Post and Page Views based on meta_value Using Shortcode in Dashboard Widget
  73. I want to Add Feedburner Right After Meta Details
  74. if get_post_meta function returns empty – Do Not Display HTML
  75. Custom column on CPT not showing correct value when meta data not set
  76. How to access post meta on the first time a post is published
  77. I Can’t get the post_tag name from term_id using wp_set_object_terms
  78. URL from get_post_meta() is broken my URL
  79. How to update/add child posts meta whenever the parent post meta is updated?
  80. How to query post with meta?
  81. why is my postmeta table is so heavy
  82. update_post_meta() throws Uncaught error: Cannot create duplicate attribute
  83. Export media library with metadata and import into new blog
  84. Multiple meta key and value search in the query
  85. Why doesn’t wp_oembed_get() for the video post format not work?
  86. Re-pointing images to cloud storage
  87. Custom Meta Fields that are Echo’d are removed on post update?
  88. How to add dynamic content in title and meta description in wordpress theme for homepage, post page, category, tag and pages
  89. undesrtanding get_post_meta function
  90. Retrieve posts from meta key
  91. Assign postmeta in bulk
  92. Re-order posts inside tax query
  93. Posts with no meta field do not appear when sorting by meta field
  94. Using mysql queries to delete custom post types based on meta_value
  95. Write query according to post_meta
  96. Why values dont shows in custom post column?
  97. get_post_meta of multiple posts?
  98. I am stuck between post meta function to call unique id
  99. query with custom field
  100. Using Form to alter PHP variable [closed]
techhipbettruvabetnorabahisbahis forumutaraftarium24eduedusedueduseduedueduedusedusedu