Display recent posts on another site

I’m not sure what you’re doing with the above script, but here are some random suggestions:

  • Avoid using the root user, for security reasons create another database user with less powers.
  • Avoid using deprecated mysql_* calls.
  • Use WP_Query() or get_posts() instead of hardcoded SQL queries.
  • Use global $wpdb object if you really must use hardcoded SQL queries.
  • Remove the <?php … ?> spam
  • Try doing this within WordPress itself, instead of creating an extenral script.php file.
  • You don’t seem to be using the $blog_url, $query_result, $num_rows, … variables.
  • There are other ways like WP REST API, XML-RPC, RSS, JSON

Related Posts:

  1. Add inline HTML to posts published within last 24hrs
  2. meta_query not working properly
  3. Show one post per author and limit query to 8 posts
  4. How to target the default Recent Posts and Recent Comments widgets with pre_get_posts?
  5. Order posts by meta value and Date
  6. WP_Query with offset and ‘orderby’ => ‘rand’, offset not working
  7. Reset WordPress Post Query to default
  8. 2 column recent post query not respecting float right [closed]
  9. How to add a recent post function to a text widget I created for practice?
  10. date_query problem
  11. order by numeric value for meta value
  12. numberposts? showposts? posts_per_page?
  13. $GLOBALS[‘wp_the_query’] vs global $wp_query
  14. Some doubts about how the main query and the custom query works in this custom theme?
  15. How to query posts based on lat-lng coordinate as post meta?
  16. How to query only for products with status “in stock” in WooCommerce? [closed]
  17. WP_Query displaying ALL posts
  18. Does WordPress sanitize arguments to WP_Query?
  19. How to trigger 404 for custom query var?
  20. How to combine tax_query and date_query in WordPress
  21. How to get any tag ID
  22. wp_query display posts from same category of the post
  23. Targeting specific pages in the loop
  24. WordPress custom archive page
  25. Include Sticky Posts in Page Post Count for custom query
  26. Query sticky posts with thumbnails
  27. Show all parents and children in custom post type in right order
  28. Why is this coming back as null? Thats wrong. There is one post
  29. Retrieve featured image (thumbnail) url from multiple posts with one query
  30. How to implement time filter to show random post 1 month for one category and 3 months for other categories
  31. Can you order posts from wp_query by two custom meta fields?
  32. Retreaving all images attached to current post
  33. wp_query() get_col error
  34. Pagination working everywhere but the index page
  35. How to select posts from one category but exclude posts in another category?
  36. How do I search inside specific taxonomies in WordPress
  37. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  38. How can you get first post, last post and post count in a category?
  39. What’s the purpose / logic of split_the_query in WP_Query->get_posts
  40. WP_query posts closest to todays date
  41. if statement in wp_query arguments
  42. Need wp_query to return all children and grandchildren
  43. How to use offset in WP_Query
  44. difference between like ‘%%%var%%’ and ‘%var%’
  45. WP Query Category Atribute Not Working
  46. How to build a WP_Query using mulitple tags and using AND or OR operator between them
  47. new WP_Query to get max price meta value not working
  48. wp_query should show stickies first
  49. WordPress custom post type with meta – how to retrieve with wp_query
  50. Pagination links missing for first link (1) and previous button? How to get pagination links to work?
  51. wordpress search word, “hello world” ===> ‘hello+world’ ===> ‘hello’, ‘world’
  52. Order by meta value (numeric value lower to higher)
  53. WP_Query with different postmeta filter for each categories
  54. Wp query show post by author name or post title or post content
  55. wordpress ajax relationship query
  56. Shouldn’t I be able to modify the main query by this filter?
  57. Admin Page Post Id wp_reset_postdata not working
  58. Multiple queries and performance – wp_query
  59. WP_Query for a taxonomy with different taxonomy types
  60. Display single most recent post in category on every page of category archive
  61. Executing query_posts after wp_insert_post
  62. Redirect Search to Form When No Product Results Are Found
  63. Show menus to one admin username
  64. inserting content of 1 Post to in another with a template hierarchy
  65. get_posts custom field
  66. wp_query posts with custom fields number smaller than
  67. is_404() – where does this get set?
  68. Max Posts and Memory Limit
  69. WordPress | WP_Query does not return anything with s=a
  70. WP_Query Pagination
  71. WP_Query orderby
  72. Using Ajax and WP_Query to load more posts on category page fails
  73. I have problems with the search query using multiple post types
  74. How to check if logged in user have pending custom post?
  75. How can I re-query post_type and rewrite the url?
  76. Different query result on local and server
  77. meta_query compare > not working
  78. How can I show only last year posts in wordpress archive?
  79. WP_Query about meta_key and its array value
  80. I can’t get post based on its postmeta value and key
  81. Change database image location for transportability
  82. Combine Tax Archive and Meta_Query in WP_Query
  83. Get posts by birthday
  84. How to add in WP_Query to every 3 posts displayed? [duplicate]
  85. Paginate nested query of child posts
  86. how to avoid reloading/refresh the page when displaying the post of wp_list_categories
  87. Issue in If else condition [closed]
  88. Pagination not working with WP_QUERY
  89. Get Current CPT taxonomy category in shortcode
  90. Custom Content Slider stop duplicate
  91. Extract video content from post to display on front page
  92. Sort Posts with custom meta key by default which is currently set as optional
  93. wp_query pagination links producing 404
  94. Pagination problem with multiple loops on the same page
  95. Carousel slider with WP_Query to show 3 posts on each slide
  96. how to use transient method?
  97. WP_Query – meta fields numeric
  98. How to query posts from single post format on Genesis framework
  99. How to replecate the _fields parameter in custom REST api endpoint
  100. WP Query returning all posts when Meta_query is null