How to save html and text in the database?

  1. Just use the wpdb insert and update API, no escaping or sanitizing needed as per the doc, just the raw data.

Data: (array) Data to replace (in column => value pairs). Both $data columns
and $data values should be “raw” (neither should be SQL escaped).

Something like:

    $wpdb->insert(
      $wpdb->prefix . "myTable",
      array(
        "doiBody" => $_POST['doi-body']
      ),
      array( "%s" )
    );
  1. No wpautop use is needed if you are outputting into the wp_editor textarea, just an esc_attr( $output ) would be sufficient I believe.

Hope this helps somehow.

Related Posts:

  1. wpdb get_results() and prepare when to use prepare?
  2. sanitize_text_field and apostrophe problem
  3. wpdb->insert: do I need to prepare against SQL injection?
  4. How do I check for a duplicate record before inserting using wpdb
  5. WPDB prepare – like % – placeholders?
  6. $wpdb->update multiple rows, like IN in normal SQL
  7. Matching database content types to PHP types
  8. Avoiding “Usage of a direct database call is discouraged”
  9. dbDelta does not create Table, but returns success
  10. passing variables as parameters to stored procedures via wpdb from php-script
  11. wp-content/db.php : where is this file?
  12. Quotes in table name
  13. WPDB->insert with special characters
  14. How Can I Use $wpdb in PayPal IPN file?
  15. $wpdb->query() multiple query support
  16. Is there a (better) way to access $wpdb results?
  17. Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
  18. how to execute different sql query in non-sanitized $wpdb->get_results function
  19. $wpdb not returning data
  20. $wpdb Query Result not coming but in phpmyadmin it works [closed]
  21. WPDB update row with != in where clause
  22. How to email user after inserting the username in database in WordPress
  23. Create an array with a string key from wpdb->get_results
  24. How to fetch an array in $wpdb?
  25. $wpdb – do you have to use foreach even if there will always only be one result?
  26. Need help writing a $wpdb query
  27. get the number of queries made on a page(inside my plugin)
  28. Doing a loop with multiple DBs simultaneoulsy
  29. $wpdb->insert query changes to SHOW COLUMNS query Output
  30. Fixing wpdb->get_results and wpdb->prepare?
  31. How does the WXR file differ from the WPDB?
  32. Rolling Back from current WordPress version to previous one
  33. WPDB If primary key already exists, add +1 to integer field
  34. What is wrong with this wpdb update?
  35. using $wpdb to insert a form into a post
  36. Programmatically Creating Page using $wpdb and getting 404 error
  37. wp_create_user not properly entering password
  38. Constructing a dynamic WPDB query with multiple LIKEs
  39. Foreach loop not working as expected – custom tables and references while submitting a form
  40. Query insert query executing multiple times
  41. Undefined offset: 0
  42. Connect to separate database using $wpdb and authenticate user
  43. How to access PostgreSQL using WPDB?
  44. how to use $wpdb->prepare to update a custom table
  45. Counting posts with argument without retrieving the posts
  46. how to assign content to a different author while loading content
  47. $wpdb->insert inserting only f character in custom table
  48. Why does wpdb->update delete other meta?
  49. Increment integer field in database when WHERE needs to be dynamic [closed]
  50. Create new database through static page code
  51. Custom $wpdb returns unexpected time based results
  52. Register custom table for WP to use in a plugin
  53. wpdb->get_row is selecting the variable as a column name
  54. WordPress “wpdb->update” – Append Text Value
  55. Display category names on edit user profile using $wpdb
  56. Need help converting get_user_meta [keys] into own array
  57. Can’t call WPDB inside RSS template
  58. wpdb and acf via wp rest api
  59. WPDB SQL Ignore `post_status` Parameter
  60. Save sql file after doing insert wpdb
  61. wpquery properties last_query and last_result : should these be public or private?
  62. Can I use wpdb to insert query results into a post?
  63. $wpdb->prepare error after WordPress update [duplicate]
  64. Query and get meta as object(stdClass) on wp postmeta table?
  65. How do I query a table?
  66. check that the data exists before sending it to wpdb
  67. How to pass an input value into wpdb->Prepare
  68. wpdb->insert with special chars failing with collation utf8mb4_unicode_520_ci
  69. no result returns when using $wpdb->get_results with where clause
  70. SQL queries to another wordpress site
  71. PHP | left join avg query give me Array()
  72. update not working using wpdb
  73. get_posts() SQL Injection
  74. og:image functions.php
  75. $wpdb select returns empty array
  76. Show error messages to a user when database insert fails
  77. Debugging db calls: $wpdb->insert works on test site, not on identical production site
  78. Intermittent problem writing update_user_meta
  79. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  80. Combine posts and postmeta
  81. wpdb get_row database query inquiry
  82. Depreciated Call -> Function wpdb::escape()
  83. How do I update post based on meta_key in another table?
  84. wpdb insert working in one function, but not another
  85. Inserting and updating rows with wpdb indreases integer fields by 1 point sometimes
  86. Retrieve a list of users based on some conditions
  87. wp_commentdata: error in documentation?
  88. Echo only gives me the first part of string
  89. wp-postratings: list current user’s unrated posts
  90. wpdb select from using array as search parameters
  91. esc_sql inserting weird chars to DB
  92. Error inserting row into table
  93. Retriving array size from serialized data
  94. How to update user profile or inputing any data to the wp db from external site?
  95. Can’t get expected result from a wpdb query
  96. Get comments after specific date
  97. selecting row using wpdb which contain special symbols
  98. get only 1 wpdb and get taxonomy, post to next page [closed]
  99. Query Problem in Clustom Plugin
  100. WP Recommended Table Exclusions?