{"id":1494,"date":"2022-02-14T21:29:55","date_gmt":"2022-02-14T15:59:55","guid":{"rendered":"https:\/\/myfreeonlinetools.com\/blog\/?p=1494"},"modified":"2022-02-14T21:29:55","modified_gmt":"2022-02-14T15:59:55","slug":"mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail","status":"publish","type":"post","link":"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/","title":{"rendered":"MySql query for fetch\/ retrieve category data in WordPress with image thumbnail"},"content":{"rendered":"<h2>MySql query for fetch WP post_id, post_title, post_date &amp; name with using thumbnail for a particular WordPress category.<\/h2>\n<p>WordPress also provides some methods for retrieving post data with thumbnails but you can also fetch them with MySQL query. Also, do with same with MySql join in array format. If you are required to display WordPress data on another website use the MySql query. Show below SQL query which you can show thumbnail image with post data.<\/p>\n<p>&nbsp;<\/p>\n<pre>$query = $db-&gt;query(\"SELECT wp_posts.id,\r\n       wp_posts.post_title,\r\n       wp_posts.post_date,\r\n       wp_terms.name,\r\n       (SELECT guid\r\n        FROM   wp_posts\r\n        WHERE  id = wp_postmeta.meta_value) AS image\r\nFROM   wp_posts,\r\n       wp_postmeta,\r\n       wp_term_relationships,\r\n       wp_terms\r\nWHERE  wp_posts.id = wp_term_relationships.object_id\r\n       AND wp_terms.term_id = wp_term_relationships.term_taxonomy_id\r\n       AND wp_terms.name = 'Business Tips'\r\n       AND wp_posts.post_status = 'publish'\r\n       AND wp_posts.post_type = 'post'\r\n       AND wp_postmeta.post_id = wp_posts.id\r\n       AND wp_postmeta.meta_key = '_thumbnail_id'\r\nORDER  BY wp_posts.post_date DESC\r\nLIMIT  8\");\r\n\r\n$response=array();\r\n\t\t\t\t\r\n\t\twhile($row = $query-&gt;fetch_assoc())\r\n\t\t{\r\n\t\t\t$remove[] = \"'\";\r\n\t\t\t$remove[] = '\"';\r\n\t\t\t\/\/$remove[] = '?';\r\n\t\t\t$remove[] = chr(054);\r\n\r\n\t\t\t$response[] = str_replace( $remove, \"\", $row );\r\n\t\t\t\/\/$response[] = mb_convert_encoding($row,'HTML-ENTITIES','UTF-8');\r\n\t\t}\r\n\t\t\r\n\t\theader('Content-type: application\/json; charset=utf-8');\r\n\t\techo json_encode($response);<\/pre>\n<p>Above code will learn you write custom PHP, MySql code to fetch blog post data with thumbnail. Its also use for writing WordPress plugins which requires data to be a beautiful way or you can also create REST API in JSON format to use in other websites or other website applications.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySql query for fetch WP post_id, post_title, post_date &amp; name with using thumbnail for a particular WordPress category. WordPress also provides some methods for retrieving post data with thumbnails but [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[46,29,24,26],"tags":[],"class_list":["post-1494","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php","category-wordpress","category-wordpress-2"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySql query for fetch\/ retrieve category data in WordPress with image thumbnail - MyFreeOnlineTools<\/title>\n<meta name=\"description\" content=\"MySql query for fetch WP post_id, post_title, post_date &amp; name with using thumbnail for a particular WordPress category.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySql query for fetch\/ retrieve category data in WordPress with image thumbnail - MyFreeOnlineTools\" \/>\n<meta property=\"og:description\" content=\"MySql query for fetch WP post_id, post_title, post_date &amp; name with using thumbnail for a particular WordPress category.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/\" \/>\n<meta property=\"og:site_name\" content=\"MyFreeOnlineTools\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/LearnSchoolOnline\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-02-14T15:59:55+00:00\" \/>\n<meta name=\"author\" content=\"myfreeonlinetools\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"myfreeonlinetools\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/\"},\"author\":{\"name\":\"myfreeonlinetools\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c\"},\"headline\":\"MySql query for fetch\/ retrieve category data in WordPress with image thumbnail\",\"datePublished\":\"2022-02-14T15:59:55+00:00\",\"dateModified\":\"2022-02-14T15:59:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/\"},\"wordCount\":146,\"publisher\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\"},\"articleSection\":[\"MySQL\",\"PHP\",\"Wordpress\",\"WordPress\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/\",\"name\":\"MySql query for fetch\/ retrieve category data in WordPress with image thumbnail - MyFreeOnlineTools\",\"isPartOf\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#website\"},\"datePublished\":\"2022-02-14T15:59:55+00:00\",\"dateModified\":\"2022-02-14T15:59:55+00:00\",\"description\":\"MySql query for fetch WP post_id, post_title, post_date & name with using thumbnail for a particular WordPress category.\",\"breadcrumb\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/myfreeonlinetools.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySql query for fetch\/ retrieve category data in WordPress with image thumbnail\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#website\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/\",\"name\":\"MyFreeOnlineTools\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/myfreeonlinetools.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\",\"name\":\"MyFreeOnlineTools\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png\",\"contentUrl\":\"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png\",\"width\":387,\"height\":79,\"caption\":\"MyFreeOnlineTools\"},\"image\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c\",\"name\":\"myfreeonlinetools\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g\",\"caption\":\"myfreeonlinetools\"},\"description\":\"Live in Delhi, Working in Gurgaon as Web Designer and Graphic Designer. Developed and Design myfreeonlinetools for online free tools. Also having youtube channel Name with LearnSchoolOnline. Traveling, watching movies, coding are the hobbies.\",\"sameAs\":[\"https:\/\/myfreeonlinetools.com\/\",\"https:\/\/www.facebook.com\/LearnSchoolOnline\/\",\"https:\/\/www.youtube.com\/learnschoolonline\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySql query for fetch\/ retrieve category data in WordPress with image thumbnail - MyFreeOnlineTools","description":"MySql query for fetch WP post_id, post_title, post_date & name with using thumbnail for a particular WordPress category.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/","og_locale":"en_US","og_type":"article","og_title":"MySql query for fetch\/ retrieve category data in WordPress with image thumbnail - MyFreeOnlineTools","og_description":"MySql query for fetch WP post_id, post_title, post_date & name with using thumbnail for a particular WordPress category.","og_url":"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/","og_site_name":"MyFreeOnlineTools","article_author":"https:\/\/www.facebook.com\/LearnSchoolOnline\/","article_published_time":"2022-02-14T15:59:55+00:00","author":"myfreeonlinetools","twitter_card":"summary_large_image","twitter_misc":{"Written by":"myfreeonlinetools","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/#article","isPartOf":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/"},"author":{"name":"myfreeonlinetools","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c"},"headline":"MySql query for fetch\/ retrieve category data in WordPress with image thumbnail","datePublished":"2022-02-14T15:59:55+00:00","dateModified":"2022-02-14T15:59:55+00:00","mainEntityOfPage":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/"},"wordCount":146,"publisher":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization"},"articleSection":["MySQL","PHP","Wordpress","WordPress"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/","url":"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/","name":"MySql query for fetch\/ retrieve category data in WordPress with image thumbnail - MyFreeOnlineTools","isPartOf":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#website"},"datePublished":"2022-02-14T15:59:55+00:00","dateModified":"2022-02-14T15:59:55+00:00","description":"MySql query for fetch WP post_id, post_title, post_date & name with using thumbnail for a particular WordPress category.","breadcrumb":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/myfreeonlinetools.com\/blog\/mysql-query-for-fetch-retrieve-category-data-in-wordpress-with-image-thumbnail\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/myfreeonlinetools.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySql query for fetch\/ retrieve category data in WordPress with image thumbnail"}]},{"@type":"WebSite","@id":"https:\/\/myfreeonlinetools.com\/blog\/#website","url":"https:\/\/myfreeonlinetools.com\/blog\/","name":"MyFreeOnlineTools","description":"","publisher":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/myfreeonlinetools.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization","name":"MyFreeOnlineTools","url":"https:\/\/myfreeonlinetools.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png","contentUrl":"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png","width":387,"height":79,"caption":"MyFreeOnlineTools"},"image":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c","name":"myfreeonlinetools","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g","caption":"myfreeonlinetools"},"description":"Live in Delhi, Working in Gurgaon as Web Designer and Graphic Designer. Developed and Design myfreeonlinetools for online free tools. Also having youtube channel Name with LearnSchoolOnline. Traveling, watching movies, coding are the hobbies.","sameAs":["https:\/\/myfreeonlinetools.com\/","https:\/\/www.facebook.com\/LearnSchoolOnline\/","https:\/\/www.youtube.com\/learnschoolonline"]}]}},"_links":{"self":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts\/1494","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/comments?post=1494"}],"version-history":[{"count":0,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts\/1494\/revisions"}],"wp:attachment":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/media?parent=1494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/categories?post=1494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/tags?post=1494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}