This a:1:{i:0;s:1:"3";}
is the serialized version of an array in PHP. You can unserialize it by using the function unserialize
like below-
$data = unserialize('a:1:{i:0;s:1:"3";}');
So after unserialize inside $data
you’ll get an array like below-
Array
(
[0] => 3
)
This array will contain the user ID which is blocked by the user who is the owner of the user meta.
Now here you can run a foreach
loop on $data
and using get_user_by
function you get all the users.
Hope that helps.
Related Posts:
- How to convert objects into arrays
- How to check if a meta value has already been assigned to any user?
- How can I save unique user data on my site? [closed]
- Grouping posts by a custom meta value
- If Array Values Match Another Array’s Values, Then
- Comapare get_user_meta value
- How can get all users by current user meta?
- Edit Account – read and write to MySQL
- MySQL Query Returns Array () In Shortcode
- How to store checkbox data for individual users?
- Convert a column of a table containing an Array as response in HTML
- Usermeta data unserialize, extract and display in table in WordPress
- How to insert multiple rows and columns in database using array
- How to display MySQL table data which is stored as an array?
- Store custom field’s multiple values in one user meta key
- get_users when from meta key that has serialized values
- Let users register weight each day and save it in DB
- How to get the list of WooCommerce product image of a certain category from database?
- Custom query to get post names beginning with a digit
- Changing user_nicename
- WordPress will not operate correctly
- tag search using WP_Query
- Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- the_author_meta not working
- if statement on database query
- Is the regular ajax request method safe or I should use admin-ajax.php?
- Create an array from an array
- Sortable admin column for one meta key with three possible meta values
- WordPress Ajax Custom Query – High CPU LOAD
- AJAX in WordPress, sending coords data to MySQL and show after into map
- Styling images coming from another blog
- Must Use Plugin Causing Query Error
- How to create and work with custom data / tables (i.e., for arbitrary data)?
- Ajax $wpdb not returning table data
- Is there a way to get 3+ dimensional array from a single MySql command
- Admin Options page. Save as Array
- PHP get the first post separately from array returned by wpdb->get_results()
- How can I add multiple ‘tax_query’ arrays via a loop?
- Can’t get wp_insert_post to work
- I want to select the from values from database in WordPress? [closed]
- mysql query from wordpress page using custom table
- User management system similar to wordpress one?
- Importing Geo data into wordpress database
- PHP Fatal error: Uncaught mysqli_sql_exception: Table doesn’t exist in wordpress/wp-includes/wp-db.php
- adding custom user input fields in WordPress admin dashboard gives error The link you followed has expired. Please try again
- PHP Array Returning [object Object]. Tried existing answers results with no luck
- foreach loop still echoes array
- Update user profile information from functions.php
- Not connecting to database in file with multiple MySQL connections
- Way to bulk make all my tags lowercase?
- $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
- How to fix this warning:call_user_func_array() expects exactly 2 parameters, 1 given in D:\wamp\www\…….\wp-includes\class-wp-hook.php on line 286
- How do I create a numbered list with PHP? [closed]
- php include not working in custom page
- Countdown to date function?
- How to get the last category name of a child category?
- Warning: in_array() null given in PHP function
- email alert for product availability
- User Meta Value not echoing despite Var_Dump Showing correct string
- How do I prepare strings for insertions as values into a MySQL table?
- How can I split my query result in 2 arrays?
- add category to posts with tag wordpress
- array_rand not working correctly?
- How can I Use 2 databases with one WordPress install
- Get css class of menu item in custom menu structure
- Order a WP_Query by meta value where the value is an array
- Why won’t this wpdb get_results query return results?
- Using multiple variables to assign categories to an array
- Repeat a function with 24hrs gap for n number of days
- Using Ajax to submit a form, and run a SQL Select query based on user input from the form
- WordPress low speed after migrating to new host
- AWS Lightsail WordPress – connect to database on instance using mysqli
- call to undefined function mysql_connect
- How can I show how much water got saved on this order (making use of the number of items bought) on a thank-you-page?
- Using wpdb to connect to a different database is not working
- How to edit content in WordPress and the Polylang – plugin? – with demosite
- Change upload URL by mime type
- WP post meta – for loop inside for loop
- Insert data from form to database
- Make sticky post with FacetWP
- not able to access $_POST on backend profile update
- Get meta_query value by user meta array
- Prepared DB Query from _POST array
- Trouble with checked() for array of multiple checkboxes
- How to use foreach and if statement within array of arrays?
- Include a custom field in mysql query
- How to find the function which is outputting Array
- Insert double entry in DB
- Exclude Post ID from Array Specified in Custom Field
- Get author meta of all writers
- Splitting One Big WordPress Site into Multiple Small Sites
- Hide a nav menu item based on get_user_meta results
- How to pass username into form that sends data to database
- How to edit the default database of WordPress [closed]
- PHP Use Declared array Variable inside already Declared Array
- Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel
- Force array to be a string [closed]
- Execute multiple PHP Snippets causes error?
- Replace block content with an array
- what to do after instlling cyberpanel on VPS