Okay
  Public Ticket #1864203
Serialized PHP array stored in Database
Closed

Comments

  • trevolution started the conversation

    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!





  •  2,572
    Aleksandar replied

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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