Add Default WordPress Formatting To Data From External SQL Tables?

You can run the the_content filters on your data.

foreach ($results as $r) {
  echo apply_filters('the_content',$r); 
}

That should get you the same formatting as in your posts.

http://codex.wordpress.org/Function_Reference/apply_filters

Related Posts:

  1. Completely strip any hidden formatting when pasting into TinyMCE
  2. Modify site URL via functions.php of a theme
  3. How to center oEmbedded content
  4. Mystery line break
  5. Database & Post Search
  6. Displaying posts on a page that have been assigned a value in a database
  7. Add HTML to Page Content
  8. Changing WooCommerce Display Price Based on User Role & Category [closed]
  9. How to add headers to outgoing email?
  10. LESS CSS enqueue_style with add_filter to change rel attribute
  11. Remove Editor From Homepage
  12. Remove description from on Home
  13. What do add_filters() and apply_filter() do?
  14. What to use instead of the content_save_pre filter?
  15. Moving sharedaddy buttons (in Jetpack) to the top of a post?
  16. How can I customize the wp_list_categories
  17. How can I reliably and globally disable wptexturize?
  18. Customise Jetpack Publicize text
  19. Can’t change a label in woocommerce with the normal filter
  20. filter the_title problem in nav
  21. Add classname to the_category() function?
  22. Filter the URL of next_posts_link & previous_posts_link
  23. Custom search page and search by title, content and tag
  24. Sensei LMS Hooks to Remove Content
  25. How to re-enable a filter after disabling with __return_false
  26. Ignore dots when searching in the media library?
  27. Exclude One Category and its Subcategories using WP_LIST_FILTER
  28. Explanation for remove_filter used in the below code [closed]
  29. Gutenberg disable the “block” tab in right sidebar
  30. Where is this inline CSS code [closed]
  31. When to use actions and when to use filters
  32. add_filter to ‘woocommerce_before_main_content’ [closed]
  33. Editing
  34. add_filter to apply_filters that exists within class
  35. Echoing Categories only if they’re a child of a given category
  36. Add ‘data-text’ attribute to TagCloud HTML
  37. Why in archive page doesn´t show read more button with excerpt?
  38. Removal of Jetpack OG Tags from old blog site
  39. Adding a title prefix with the the_title filter
  40. How to modify an existing meta description?
  41. Don’t see add_filter result in the site front page
  42. How can I include an existing custom sitemaps listing in wp-sitemap.xml?
  43. Display Externally Retrieved Data within a Custom Template
  44. Can the wordpress color palettes by changed through Javascript?
  45. Filter on the_content doesn’t update the content being searched via register_rest_route
  46. Where to add_filter in theme functions.php?
  47. Cannot change the definition of AUTOMATIC_UPDATER_DISABLED
  48. How do I add a checkmark to my-sites save settings hook
  49. tag removed not using a filter
  50. WordPress Image update filter
  51. How to remove this filter?
  52. Why does WordPress strip custom HTML that are form elements and theme SVG icons?
  53. Trouble using remove_filter to override function in parent theme
  54. Load Posts’ individual body content on index starting at char 200 of each post
  55. How can you wrap add_filter with a if is_home() statement?
  56. How to combine multiple body classes
  57. Prepending character(s) to a custom tag title?
  58. How to replace username with email address in users table
  59. Modify existing plugin function with add_filter
  60. include specific Pages to wp_list_pages with filter
  61. why require – does not load filter
  62. term_link filter rewrite link only applying half of condition?
  63. How to change dynamically page title according to variable data?
  64. How can I filter tag_description()?
  65. What is the action hook to use if you want to capture the new password during password change?
  66. Get_template_part inside filter?
  67. Email Obfuscation: Is antispambot() Acceptable? [closed]
  68. WordPress overwrites UNC
  69. Need to return shortcode text instead of the output
  70. Change tags url to search different site
  71. How to optionally append components to the output of a gutenberg block?
  72. Dashboard filter based on custom fields URL response code
  73. Custom SQL query slows down when using multiple OR … LIKE … in posts_where filter
  74. I want to add string array to this function to filter displayed option in drpodown [closed]
  75. Drop down filter sort posts by latest, last 7 days and monthly
  76. Function not returning correct value for found_posts filter
  77. Unable to defer loading of jquery
  78. Remove style tags from head
  79. How to wrap pattern-matches from the_content in [wiki]-shortcode tags
  80. how to develop a filter in wordpress to let the user filter the page content depends on the date (newest to oldest etc…)?
  81. Print only parent categories of post in custom RSS feed
  82. Login logout below menu bar
  83. Use add_filter inside another function
  84. Add HTML to the bottom of each post in a post list
  85. How to filter reading/visibility posts based on role?
  86. Admin view: filter posts by whether they have specific taxonomy attached
  87. Filter posts by categories ajax is showing all the posts
  88. URL to filter posts by post meta similar to shop/?product_cat=”painting”
  89. Incrementing content with extra text after save/publish
  90. Filter and validate user role in registration
  91. How to use a TinyMCE filter?
  92. Unable to get WordPress’s apply_filters(‘site_url’) to return a https scheme
  93. String Replace Caching & Chance of Collisions
  94. Admin filter/error if post title is too long
  95. How we make the filter for fornt end user
  96. Sanitizing a custom query’s clauses
  97. How can I display wp_link_pages before a shortcode, if it is used, or display after content?
  98. confusion with add_filter
  99. How to create a list of terms who’s posts also have a predefined external term?
  100. Limit total tags in the_content