{"id":7347,"date":"2023-08-19T14:36:49","date_gmt":"2023-08-19T18:36:49","guid":{"rendered":"https:\/\/themespress.ca\/?p=7347"},"modified":"2023-08-20T09:59:23","modified_gmt":"2023-08-20T13:59:23","slug":"number-of-wordpress-media-query","status":"publish","type":"post","link":"https:\/\/themespress.ca\/en\/number-of-wordpress-media-query\/","title":{"rendered":"Number of WordPress Media Query"},"content":{"rendered":"

Number of WordPress Media Query<\/h2>\n\t
\n\t\t
\n\t\t\t

With this tutorial, we will create a query that will return the number of media (i.e. images) that have been uploaded in WordPress.<\/p>\n

Let’s start with image type. In our query below, we will create an SQL query that will fetch the number of images uploaded today. Le post mime type<\/strong><\/p>\n

.Here’s the SQL query inside a shortcode:<\/strong><\/p>\n\n\t\t<\/div>\n\t<\/div>\n

\/**************************** Count des images telechargees aujourd'hui ********************************\/\n\nfunction count_attachments_today() {\n    global $wpdb;\n\n    $today = getdate();\n    $year = $today['year'];\n    $month = $today['mon'];\n    $day = $today['mday'];\n\n    $count = $wpdb->get_var(\n        $wpdb->prepare(\n            "SELECT COUNT(ID) FROM $wpdb->posts\n            WHERE post_type = 'attachment'\n            AND post_mime_type LIKE 'image%%'\n            AND YEAR(post_date) = %d\n            AND MONTH(post_date) = %d\n            AND DAY(post_date) = %d",\n            $year, $month, $day\n        )\n    );\n\n    return '<div class="addo40px addocenter">' . $count . '<\/div>';\n}\nadd_shortcode( 'attachmentcounttoday', 'count_attachments_today' );<\/pre><\/div>
Number of WordPress Media Query<\/h2>\n\t
\n\t\t
\n\t\t\t
We will now do the same query, but this type for the video format. Once again, here’s the SQL query inside a shortcode:<\/strong><\/p>\n\n\t\t<\/div>\n\t<\/div>\n
\/**************************** Count des videos telechargees aujourd'hui ********************************\/\n\nfunction count_videos_attachments_today() {\n    global $wpdb;\n\n    $today = getdate();\n    $year = $today['year'];\n    $month = $today['mon'];\n    $day = $today['mday'];\n\n    $count = $wpdb->get_var(\n        $wpdb->prepare(\n            "SELECT COUNT(ID) FROM $wpdb->posts\n            WHERE post_type = 'attachment'\n            AND post_mime_type LIKE 'video%%'\n            AND YEAR(post_date) = %d\n            AND MONTH(post_date) = %d\n            AND DAY(post_date) = %d",\n            $year, $month, $day\n        )\n    );\n\n    return '<div class="addo40px addocenter">' . $count . '<\/div>';\n}\nadd_shortcode( 'videoattachmentcounttoday', 'count_videos_attachments_today' );\n<\/pre><\/div><\/div><\/div><\/div><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"Number of Wordpress Media Query With this tutorial, we will create a query that will return the number of media (i.e. images) that have been uploaded in Wordpress. Let's start
Read More<\/a><\/div>","protected":false},"author":81,"featured_media":7349,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[283],"tags":[],"class_list":["post-7347","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/7347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/comments?post=7347"}],"version-history":[{"count":0,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/7347\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media\/7349"}],"wp:attachment":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media?parent=7347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/categories?post=7347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/tags?post=7347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}