Support › MB Custom Table › Custom database with custom upload_dir for images problem
- This topic has 4 replies, 2 voices, and was last updated 8 months, 1 week ago by
Rob van Tuin.
-
AuthorPosts
-
August 27, 2023 at 12:09 AM #43042
Rob van Tuin
ParticipantHi,
I'm using a Meta-box custom table for one of my post-types which is working fine for most of it, the problem I have is with retrieving the image data.
For the images, I use a custom upload_dir I'm not able to get the image data, I get the database field data 'a:1:{i:0;s:81:"https://wp-plugin.test/wp-content/uploads/events/images/main/test-image.jpg";}' but I can not get it decoded. It works fine if I use the media folder.
function get_event_meta($event_id){ global $wpdb; $table = EVENT_TABLE_NAME; $event_id = get_the_ID(); $event_query = $wpdb->prepare("SELECT * FROM $table WHERE id=%s;", $event_id ); $event = $wpdb->get_row( $event_query, ARRAY_A ); $event['main_image'] = rwmb_meta( 'image_main', EVENT_TABLE_ARG, $event_id); return $event; }Any insight on what I do wrong?
August 28, 2023 at 9:05 PM #43064Peter
ModeratorHello Rob,
What is "decode" in this case? You can simply follow the documentation below to get the field value that is stored in a custom table.
https://docs.metabox.io/extensions/mb-custom-table/#getting-field-valueAugust 29, 2023 at 12:00 AM #43069ParticipantDecode is trying to convert this string 'a:1:{i:0;s:81:"https://wp-plugin.test/wp-content/uploads/events/images/main/test-image.jpg";}' into normal variables.
I followed the documentation as you can see in the code
$event['main_image'] = rwmb_meta( 'image_main', EVENT_TABLE_ARG, $event_id);but it always comes back with an empty array.August 29, 2023 at 8:17 PM #43076ModeratorHello,
You can use the WordPress function
maybe_unserialize()to decode the value
https://developer.wordpress.org/reference/functions/maybe_unserialize/
https://stackoverflow.com/questions/25766378/wordpress-show-unserialize-data-in-a-smart-wayOr use the helper function:
$args = [ 'storage_type' => 'custom_table', 'table' => EVENT_TABLE_NAME, ]; $value = rwmb_meta( 'image_main', $args, $event_id ); echo $value;September 2, 2023 at 11:02 AM #43121ParticipantYes, thank you, the maybe_unserialize option works, but the helper function does not work for images, it works for other cloneable fields fine.
-
AuthorPosts
- You must be logged in to reply to this topic.