How to convert objects into arrays

$wpdb->get_results has a second parameter that lets you specify what kind of return value you want:

For example:

$data = $wpdb->get_results( $query, ARRAY_A );

Here you get an associative array back.

Related Posts:

  1. Grouping posts by a custom meta value
  2. MySQL Query Returns Array () In Shortcode
  3. Convert a column of a table containing an Array as response in HTML
  4. How to insert multiple rows and columns in database using array
  5. How to display MySQL table data which is stored as an array?
  6. How can get all users by current user meta (array)?
  7. Not connecting to database in file with multiple MySQL connections
  8. Way to bulk make all my tags lowercase?
  9. $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
  10. How i can obtain all the post meta for a specific post as an array?
  11. Alter required message using comment form api
  12. multiple where condition in result query
  13. Advanced Custom Fields – display label and value only if value entered
  14. meaning of (array)function()
  15. Multiple meta_key in one global $wpdb;
  16. wp_force_remove_style’ not found
  17. Custom array from a query only write the last row of the query
  18. WordPress member notification
  19. 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
  20. Can’t Query Custom Table Using $wpdb Method
  21. How can I access string value in an array?
  22. Moving wordpress site from localhost to live server using GoDaddy cPanel
  23. How does WP work in conjunction with a web server?
  24. How to use if statement in an array? [closed]
  25. How to array only one key from another array
  26. WordPress Block developer from exporting Database via PHP
  27. Filtering a function’ output for a new continued function
  28. Get html data with javascript to php array and store to wordpress database
  29. $wpdb returns duplicate posts
  30. Update postmeta after theme switch
  31. How do I create a numbered list with PHP? [closed]
  32. Why is an array created in a function hooked to customize register populated when customizer is loaded but not when the front-end is loaded?
  33. Mixing variables into an array when inserting values
  34. Location of core code for database connection and get_header
  35. wpdb prepare insert table doesn’t work
  36. Should I use WordPress to skin a database website?
  37. php include not working in custom page
  38. How do I display offsite database info on my wordpress site?
  39. Creating Database Table vs. Adding MetaData to Post & User
  40. Make a database query using WordPress
  41. How to use array in function to get only value I want
  42. Error while setting role
  43. Get categories names as an array to use it in theme settings
  44. Force Users To Relogin
  45. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  46. WordPress Custom SQL Table with UserID Filter for results
  47. How to get the last category name of a child category?
  48. How to say if meta_value is greater than 0 in an array?
  49. How to use two meta_compare in an array?
  50. Warning: in_array() null given in PHP function
  51. Most commented posts by time period (last 12h, last 24h and etc)
  52. Use $wpdb or other PHP script method to find/replace in WP database
  53. email alert for product availability
  54. Foreach loop inside an array_merge
  55. How can I add a new row in a separate database when someone registers via WordPress?
  56. Issue with fetching mysql data and displaying results via shortcode in webpage
  57. Loop over Array and get the distinct ids
  58. Basic wpdb update question
  59. How to access or parse key/values that have “string”
  60. If Array Values Match Another Array’s Values, Then
  61. Hide posts if user is added to it WP_query
  62. Remove empty terms from array, sort alphabetically, update back to repeating field
  63. WordPress loop by meta key that is an array? and how loop multiple arrays
  64. Only show first image in foreach loop
  65. Conditional multidimensional arrays and array_map
  66. I can’t update my data through $wpdb
  67. A $_POST should occur when submit form but is not?
  68. Custom route and query
  69. Output: “Array”
  70. How can I get all values from my array in a loop in php? [closed]
  71. How to unserialize data from MySQL
  72. How to use mysql LIKE with wpdb?
  73. Getting posts to exclude from array
  74. Get all posts as an array ID => Name
  75. Pull MySQL data from multiple tables and merge into 1 PHP array
  76. I’m unable to call img path using single quotes in an array?
  77. Filter by field with array value in ACF on WP REST API
  78. extract serialized array to use for wp-query
  79. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  80. get users search not working with array
  81. WordPress WP_Query without query GET parameters
  82. How do I prepare strings for insertions as values into a MySQL table?
  83. Known Issues in WordPress When Upgrading PHP to ver 7
  84. Comapare get_user_meta value
  85. How can get all users by current user meta?
  86. Using CFDB7 vs Custom MySQL Database [closed]
  87. Get the id of all images in a post
  88. Output category list inside array
  89. how to make an array of post id’s in is_single
  90. How can I split my query result in 2 arrays?
  91. Multidimensional Array
  92. How to use AJAX in WordPress in MYSQL query?
  93. Separate array output into a
  94. add category to posts with tag wordpress
  95. array_rand not working correctly?
  96. How can I Use 2 databases with one WordPress install
  97. Get css class of menu item in custom menu structure
  98. Use variable in SQL statement
  99. Using wordpress function to retrieve data
  100. Dynamically adding filters
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)