I was thrilled to see the ability of this plugin to make something out of a serialized PHP array, however, the array I'm attempting to decode is stored as a meta_value in the wp_usermeta table. This array is stored for each user, and so appears many times in the database, if that makes sense, and each instance may carry different values and even a different number of columns.
1. Fundamentally, is it possible with the plugin to construct some kind of query to read and construct a table based on the serialized values which are stored in the database as described, rather than importing from a URL as shown in the demo?
I am sorry to inform you that unfortunately something like this is not possible with the plugin's built-in features. It would require some customization for this to work.
I was thrilled to see the ability of this plugin to make something out of a serialized PHP array, however, the array I'm attempting to decode is stored as a meta_value in the wp_usermeta table. This array is stored for each user, and so appears many times in the database, if that makes sense, and each instance may carry different values and even a different number of columns.
Eg
User 1
meta_key: wp_s2member_custom_fields
meta_value:
a:6:{s:6:"gender";s:1:"M";s:3:"dob";s:8:"1/5/2005";s:10:"sailprefix";s:3:"HKG";s:10:"sailnumber";s:3:"520";s:4:"club";s:3:"ABC";s:9:"hkodalaws";s:1:"Y";}
User 2
meta_key: wp_s2member_custom_fields
meta_value:
a:17:{s:7:"address";s:0:"";s:4:"club";s:5:"RHKYC";s:12:"contactphone";s:0:"";s:3:"dob";s:10:"27/10/2004";s:6:"gender";s:1:"F";s:6:"hkborn";s:0:"";s:9:"hkodalaws";s:1:"Y";s:10:"hkpassport";s:0:"";s:6:"isafid";s:0:"";s:8:"magazine";s:0:"";s:9:"otherclub";s:0:"";s:17:"permanentresident";s:0:"";s:10:"sailnumber";s:3:"206";s:10:"sailprefix";s:3:"HKG";s:6:"school";s:0:"";s:19:"schoolcontactperson";s:0:"";s:7:"yearshk";s:0:"";}
With that in mind,
1. Fundamentally, is it possible with the plugin to construct some kind of query to read and construct a table based on the serialized values which are stored in the database as described, rather than importing from a URL as shown in the demo?
2. How does one go about that? :-)
Many thanks!
Hello trevolution.
Thank you for your purchase.
I am sorry to inform you that unfortunately something like this is not possible with the plugin's built-in features. It would require some customization for this to work.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables