How to pass user meta_key and meta_value (values as array)

Question

I want to pass user meta_key to meta_value, but the meta_value array is like this:

$user_biodata = array(
    'register_facebook_id' => 1311064406686333,
);

I want check if user is already registered through this function;

$wp_users = get_users(array(
    'number'       => 1,
    'count_total'  => false,
    'fields'       => 'id',

    'meta_query' => array(
        array(
            'meta_key' => 'user_biodata',
            'meta_value' => array( 'register_facebook_id' => 1311064406686333 ),
        )
    ),
));

But the result is always 1 even when the value not exist, how do I fix it?

Drupalizeme · Accepted Answer · 2017-11-06 11:24:54Z

1

What you are doing is not a valid way of retrieving and checking serialize data from the WP. You may insert array as a user meta but this array behind the scenes is transformed to serialize string something the MySql can handle.

There are options for searching with the LIKE operator but I don't endorse this use as it can lead to unexpected results.

$args = array(
'number'       => 1,
'count_total'  => false,
'fields'       => 'ID',

'meta_query' => array(
        array(
            'key' => 'user_biodata',
            'value' => 'yourValue',
            'compare' => 'LIKE',
        ),

    ),
);

$users = get_users($args);

edited Nov 6, 2017 at 11:24

answered Nov 6, 2017 at 9:19

Drupalizeme

1,6262 gold badges13 silver badges17 bronze badges

1

Thanks, but not using '%%'.,

Opsional
– Opsional

2017-11-06 11:18:15 +00:00
Commented Nov 6, 2017 at 11:18
Yes @Opsional you are correct this is redundant.

Drupalizeme
– Drupalizeme

2017-11-06 11:24:44 +00:00
Commented Nov 6, 2017 at 11:24

Add a comment |

Stack Exchange Network

How to pass user meta_key and meta_value (values as array)

1 Answer 1

Your Answer

Hot Network Questions

How to pass user meta_key and meta_value (values as array)

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions