How to get a database field value from a WordPress table? [closed]

In the first two cases, there’s an array wrapping the object that you have to attend to first. e.g. this should work:

$status = $user[0]->status;

As a sidenote:

In the last case, json_encode() doesn’t, as the name might suggest, turn data into an object with properties that you can access — it turns it into a JSON string. Not very useful here.

You can use json_decode() again to turn the string into an object — but of course why bother, since $user[0] is the object you want in the first place.

Related Posts:

  1. Deprecated: mysql_connect()
  2. dbDelta support for FOREIGN KEY
  3. is it possible to run some php code within a wordpress page?
  4. How to correctly submit a search form and display the result in an independent page
  5. Query both first_name and last_name from wp_usermeta at the same time
  6. How to use update and delete query in wordpress
  7. How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
  8. Does WordPress cache get_user_meta() results?
  9. simple wordpress ajax plugin not working when not logged in
  10. Using Echo in ShortCode – Stuck
  11. MySQL query performed 4 times inside loop
  12. Show only one post for each author ( Page loads too slow )
  13. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  14. Modern Tribe Calendar wp-query with meta query not working at all
  15. WP database error for comments_popup_link()
  16. No wp-config.php file on local install of wordpress – site still displays
  17. Use ajax to update_post_meta
  18. Insert all post IDs in new database table
  19. register_activation_hook isn’t adding table to DB
  20. Is the outdated PHP mysql extension a requirement for WordPress 4.6?
  21. What SQL / WordPress queries would need a nonce?
  22. Different database query in function.php using mysqli
  23. Query String being Removed Creating a Pagination Issue within a Custom Plugin
  24. Converting MYSQL to WordPress $WPDB
  25. Why is variable not working on custom sql query using wpdb?
  26. Get WooCommerce product details and transfer them to a custom DB table
  27. How can I export posts with featured images, without download them
  28. How to securely provide a $_POST var in WP_Query with PHP 7?
  29. Create WP_Query to search for posts by their categories or their parent/child categories
  30. What is a valid parent for get_terms()?
  31. WSoD being caused by this piece of code
  32. How to display data from custom table in wordpress phpmyadmin
  33. Calculating a large number of MYSQL queries as customshort codes, slow
  34. Update results, Before deleting the related category [closed]
  35. Sum the total amount of a specific product purchased per user and display in table
  36. Replacing mysql_escape_string in a custom plugin when moving to PHP7
  37. Weird 404 URL Problem – domain name being placed at end of urls
  38. database sent to a JSON file
  39. inserting a post from an extern php file but post content doesn’t show on wp site
  40. $wpdb->insert() does not Insert record in a table
  41. WordPress SQL injection
  42. multiple where condition in result query
  43. Grouping posts by a custom meta value
  44. Mixing variables into an array when inserting values
  45. wpdb prepare insert table doesn’t work
  46. Make a database query using WordPress
  47. Basic wpdb update question
  48. I can’t update my data through $wpdb
  49. Output: “Array”
  50. Pull MySQL data from multiple tables and merge into 1 PHP array
  51. Using CFDB7 vs Custom MySQL Database [closed]
  52. Using wordpress function to retrieve data
  53. Live search from database table
  54. form $_post action value gets truncated after it passes through two forms
  55. Adding data to custom wordpress database table
  56. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  57. Add row to custom database Table and delete all rows older than 1 day
  58. select a single val though a table in wordpress
  59. making php value numeric
  60. How to create Loop code for Menu using WordPress?
  61. Removal of all posts content in bulk, keeping the posts itself
  62. How to WP_Query posts order by parent title?
  63. Convert a column of a table containing an Array as response in HTML
  64. Please help! I have a problem with getting wordpress databas
  65. How to run complex query using PHP
  66. Error establishing a database connection (Set-up locally)
  67. Conditional formatting on data fetched from MYSQL
  68. Can I split a huge wp_postmeta table across different databases or servers?
  69. how to get data from two different table from wordpress database
  70. Passing Current User ID into SQL statement
  71. How to insert multiple rows and columns in database using array
  72. WordPress mysql deos not work with php7
  73. Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
  74. Windows Setup: Error establishing a database connection
  75. WP + MySql db / PHP
  76. The plugin generated 225 characters of unexpected output during activation
  77. WAMP SERVER Command Prompt SET PATH=%PATH%
  78. append data to mysql table via submit button coded in php – not working
  79. WordPress select query issue
  80. (Who to follow) Twitter widget
  81. How to do a MySql query in WordPress?
  82. How can get all users by current user meta (array)?
  83. Add two or multiple functions in WordPress Post or Page
  84. How can I display a query in a page?
  85. Send data from plugin to external database
  86. Processing forms with php to wordpress database
  87. How to properly send many mysql queries via php and what happens with ajax requests after they are sent?
  88. How to set max users to 17.000
  89. directorypress theme error mysql_error() [closed]
  90. How to connect database table to each registered wordpress user.
  91. Using the same shortcode to show any table from the database
  92. Cannot Upload Custom Header Image into WordPress Dashboard
  93. MySQL update text field with ‘
  94. Predefine Magazine Style Layouts
  95. I am unable to fetch json data from wp_db
  96. Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
  97. How to send push notification in android using php? [closed]
  98. How to set variable to specific field when querying
  99. Error resetting database index using ALTER TABLE in $wpdb->query
  100. Can’t insert into a database wordpress