How is the data stored in the database?

This is a serialized array. PHP is able to read them as if they were regular arrays (or objects, in some cases) by using the serialize and unserialize functions (WordPress does this for you).

All you need with WordPress to do is use get_option (or comparable WordPress function calls to retrieve data) and use the array/object as normal.

I would recommend you avoid editing the data raw in the database, since can really mess things up (I know from experience 🙂 ).

Related Posts:

  1. Getting wrong relationship value in $args in wp_Query?
  2. Activation hook not creating table
  3. Is the usage of ON DELETE CASCADE wrong or not allowed on wordpress?
  4. Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
  5. WordPress database error for query INSERT INTO
  6. How to connect to AWS RDS external database (not for the core WordPress db)
  7. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  8. Using AND and bracket grouping in SQL not working
  9. Two different wordpress sites – same server and IP address. Gaining Access to database 1 of 2
  10. What might be the reason of Couldn’t fetch mysqli_result on another domain?
  11. WordPress database error: [Query was empty] – using $wpdb->prepare()
  12. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  13. WordPress doesn’t create table on plugin activation
  14. pull data from wordpress database
  15. How to filter get_adjacent_post()?
  16. Should I use wpdb prepare?
  17. Post meta vs separate database tables
  18. Update Option Stored in Multi-Dimensional Array
  19. Default table collation on plugin activation?
  20. How does WordPress handle MySQL row lock errors?
  21. Writing a plugin that notify my friends of new post that mentions(@) them
  22. Does using set_transient() function can lead to MySQL problems?
  23. Not sure the best way to save custom plugin data
  24. The ideal place for storing persistent PHP objects
  25. What is the correct way for plugins to create tables with special charset/collation considerations?
  26. What is the added “complexity” of custom tables?
  27. Plugin development with unit tests
  28. Formatting of curly brackets array from WP database to get more readable output
  29. How to modify post content before writing to database?
  30. Hello dolly type plugin that allows people to add their own
  31. Custom Plugin Database relations
  32. Database for development
  33. Is there a naming convention for database tables created by a plugin?
  34. Passing array of strings to a SQL statement in a WordPress plugin
  35. How to edit mySQL wp_posts table from plugin php?
  36. What for the tables ending with the meta used in database of wordpress?
  37. $wpdb -> Batch insert from XML File?
  38. query users by role
  39. Get a custom table to an array
  40. How to Create database table when Plugin installed/activated, and delete database when Plugin deleted
  41. Subscribe to author?
  42. I’m designing a plugin to create database indexes. Suggestions?
  43. How should I store a log for my plugin
  44. How to create database table, add data, update and delete using wpdb via plugins?
  45. Are there any scripts, classes, and/or functions built-in to WP for a plugin to export/import its saved data from wp_options?
  46. Help With MySQL to WPDB Query Conversion
  47. How to perform a heavy and long process in cron jobs?
  48. Form doesnt save to database
  49. Update results, Before deleting the related category [closed]
  50. Is using custom table to suit business needs instead of transients a big hit to page load speed?
  51. WordPress Backend HA (Automatic failover)
  52. How to add user details to different tables immediately after user registration
  53. mysql_real_escape_string() vs. esc_sql() in WordPress
  54. Optimising a big WordPress site
  55. dbDelta not installing database
  56. Is it necessary to do validation again when retrieving data from database?
  57. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  58. What is the best way to store a few fields?
  59. Adding columns to core tables
  60. How to query custom db table?
  61. Delete data from database using row action
  62. How do I have now a duplicated user entry if this is not allowed (and I cannot replicate it)?
  63. $wpdb->prepare with LIKE and sprintf
  64. wpdb prepare insert table doesn’t work
  65. DB Query not working in Plugin
  66. Auto-complete or auto-suggest from stored data in database
  67. Brainstorm – Slow Query from Plugin Need to Speed It Up
  68. Save temporary registration data
  69. $wpdb->update Issue
  70. Integrating Custom Database with WordPress
  71. How to display results from a data table with an encrypted user id?
  72. dbdelta failing with error: “WordPress database error Table ‘wp_2_myPlugin’ already exists
  73. Error code when migrate
  74. Why User_login key doesn’t work with wp_update_user()
  75. How to get inserted row IDs for bulk/batch insert with wpdb query?
  76. Why is that only the first row getting inserted into Mysql table when i import csv file on backend custom plugin?
  77. Error Connecting to Database WHEN Installing WordPress on XAMPP [Tried All the Usual Stuff] (Pics Included)
  78. WordPress Fatal error: Uncaught Error: Call to undefined function dbDelta()
  79. Is it possible to replace MySQL with JSON files for WordPress
  80. Use admin-post to submit form data to external database
  81. Insert Data into Database
  82. Update database record in plugin
  83. How to store in the database directly the translation?
  84. Organising and completing posts (mark as read and hide)
  85. $wpdb Mysql trigger problem
  86. Ajax not working to insert, query and result data
  87. Custom MySQL query to pull out Advanced Custom Fields?
  88. Associating special meaning with user id 0
  89. $wpdb how can i save my postmeta table before querying it
  90. What method should I use to store my plugin data (multi level menus with options on each item)
  91. How to add additional field in a table row after creating a table?
  92. WordPress plugin tables become corrupt
  93. Post data in wp-admin to external database
  94. How can I get a plugin to hook ‘dbdelta_queries’ — a filter used during version update?
  95. How can I delete the options from DB when the plugin is deleted?
  96. How to create a database table in WordPress using PHP
  97. Can I log the searches that are returning 404 in the DB?
  98. Programmatically creating posts based on external JSON feed (asynchronously)
  99. Making a user platform reachable by a qr code on a pin-back-button [closed]
  100. multiple record insert creating many duplicate records

Leave a Comment