Skip to content
Read For Learn
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP

How to return/export only data showing on screen in custom post type view all screen

<?php
//edit.php?s&post_status=all&post_type=shirts&action=-1&m=0&slug=03-02-2020&filter_action=Filter&paged=1&action2=-1 
//$parse_uri = explode('wp-content', $_SERVER['SCRIPT_FILENAME']);
//require_once($parse_uri[0] . 'wp-load.php');
header("Content-Description: File Transfer");
header("Content-Type: application/csv");
header('Content-Disposition: attachment; filename="wp.csv"');
header('Pragma: no-cache');
header('Expires: 0');

global $post;

//https://developer.wordpress.org/reference/classes/wp_query/
$post_status = isset($_REQUEST['post_status']) && $_REQUEST['post_status']=='all' ? 'any' : 'publish';
$date = explode('-',$_REQUEST['slug']);
$posts_per_page = $_REQUEST['action2'];
$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;

$arg = array(
    'post_type' => $_REQUEST['post_type'],
    'post_status' => $post_status,
    'posts_per_page' => $posts_per_page,
    'paged' => $paged,
    'date_query' => array(
        'column' => 'post_date',
        'year' => $date[2],
        'month' => $date[1],
        'day' => $date[0],
    )
);

$posts = new WP_Query($arg);

if($posts->have_posts()){

    $file = fopen('php://output', 'w');

    fputcsv($file, array('COLUMN ONE', 'COLUMN TWO'));


    while ( $posts->have_posts() ){
        $posts->the_post();

        $color = get_post_meta( $post->ID, 'user-color', true );
        $size = get_post_meta( $post->ID, 'user-size', true );

        fputcsv($file, array($color, $size));
    }

    fclose($file);

}
?>

Related Posts:

  1. Export entries and multiple custom field meta to .csv?
  2. Query all posts where a meta key does not exist
  3. Can the Next/Prev Post links be ordered by menu order or by a meta key?
  4. what is the correct way to compare dates in a WP query_posts meta_query
  5. Advanced search form with filters for custom taxonomies and custom fields
  6. Meta query with boolean true/false value
  7. Get post with multiple meta keys and value
  8. Correctly delete posts with meta and attachments [duplicate]
  9. Storing revisions of metadata for custom post type
  10. Custom field values deleted when trashing custom post type
  11. How to get all custom fields of any post type
  12. Update CPT meta data using REST API
  13. Admin Area Custom Type Search By Meta Fields Without Title & Content
  14. Echo all meta keys of a custom-post TYPE
  15. Custom Post type – how to get checkbox to update meta field to null
  16. How can I filter posts by post_parent in the admin?
  17. How do I Paginate Search Results for Custom Post Types?
  18. Ordering posts having multiple post-meta date fields
  19. Custom Post Type with Input fields to seperate table on database.
  20. How do I remove all the metaboxes for a custom post type?
  21. Custom Queries: Joining On Meta Values From Two Custom Post Types
  22. Gutenberg how to make attribute to save to meta
  23. How to programmatically create a connection with [Plugin: Posts 2 Posts] on cpt publish?
  24. Post metadata deletes itself
  25. How to create a mini directory in WordPress?
  26. How Can I save multiple records in same meta key?
  27. Get all posts from custom post type and insert in select input as metabox
  28. Detect meta value changes when post is updated (post_updated)
  29. Search everything (posts, pages, tags, cpt, meta)
  30. Permalinks using event date (year & month) instead of publication date
  31. Custom Post Type: Set post_title equal to a custom post type field
  32. I can’t set meta_key in my custom post type query
  33. Grossly inefficient wordpress loops!
  34. Compare 3 custom fields and sort by oldest
  35. How Do I Use WP_Query to Run This Database Query as Search Result?
  36. WordPress Admin Panel search posts with custom post meta values along with title
  37. Creating a custom post type upon registration
  38. How to Update post status using meta data in Custom post TYpe
  39. Rest Api v2 orderby meta_key in custom post type
  40. bulk Update post_meta with default values
  41. Reason action hook won’t work with update_post_meta from frontend form? Alternative?
  42. Can’t sort order of wp_query with 2 meta keys
  43. Showing Meta Data for Custom Post Types?
  44. How to get source of custom meta image?
  45. Having trouble with custom post type / meta box
  46. Query for posts from any post type but only add instock products
  47. How can I include meta box content when searching?
  48. update a post meta from a single table cell TablePress
  49. update custom post type meta from a shortcode
  50. Custom Meta Boxes – Nonce Issue – Move to trash issue
  51. Displaying Meta Box Image
  52. Custom post type category not displaying in custom post type
  53. How to make custom post meta wp_editor translatable?
  54. Automatically adding meta data to posts or multiple query help
  55. How to keep a check box in custom meta box for custom post type checked by default for add new post?
  56. How to add multiple featured image in meta box in post editor?
  57. Show metabox in custom-post-template depending on taxonomy term?
  58. ACF Upload Image in repeater from front-end with custom form? – add_post_meta()
  59. Best practice for adding posts in bulk
  60. update_post_meta() whenever custom post type is updated
  61. Formatting custom meta box date from YYYY/MM/DD to a more readable alternative
  62. Trigger “unsaved changes” dialog for custom post meta changes
  63. Using date stored as custom field to filter posts displayed in admin
  64. Conditionally Query Custom Post Types by Post Meta for Blog Home Page?
  65. Displaying custom posts only if custom meta box’s date is not expired
  66. Displaying Metabox value (custom post type taxonomy)
  67. How do I sort a custom post type admin column using two meta keys?
  68. Add Post Url to Manage Edit Screen
  69. Export Custom Post Type posts with all Custom Fields and Custom Texonomy associated with it
  70. How to best delete orphan wp_postmeta
  71. How can I display my custom metaboxes on a custom post template?
  72. Display all custom post type posts and order them by an optional meta_key
  73. Meta Box Only in CPT Edit Page, Not in Add New
  74. get_post_meta is returning image id
  75. Custom Post Type, Saving Multiple Checkboxes
  76. get_template_part() – post-meta not working?
  77. How can I get_post_meta() in the most efficient way?
  78. need advice on how to do a lists using custom post types – taxonomy vs postmeta
  79. Count posts with specific term_meta
  80. Custom search for custom post meta with pre_get_posts interferes with WP search
  81. Create a random unique 6 digit number as custom field for custom post type
  82. how to interconnect custom post types?
  83. WordPress Orderby Numeric Value Not Working
  84. Custom Post Status Transition Issues With Get Post Meta
  85. Replace title column in post list with post meta value
  86. Metadata for a taxonomy – is there any WordPress way of doing this?
  87. My theme saves their custom post type’s metadata as a serialized array, how to access the keys?
  88. List all images from a single post meta value
  89. Does WordPress limit the length of slug names for Post Meta or Terms?
  90. orderby in custom WP Query does not work
  91. Populate Custom Fields in a Custom Post Type?
  92. Insert Multiple Post with Same Publish Button
  93. Update CPT post meta with update_post_meta and cron job
  94. Custom meta box data array: foreach not working correctly?
  95. Undefined Variable – Custom Post Type Meta
  96. Ordering posts in Search & taxonomy by post_meta
  97. Insert post metadata for all posts in CPT at once if metadata no existent
  98. Display custom post type from dynamic custom field
  99. Show the same Article Available in Other Categories
  100. how to delete all users and posts based on ‘user_meta’?
Categories custom-post-types Tags csv, custom-post-types, export, post-meta
dashboard widget form not submit mails
Curveball cloning WP site to new URL

Recommended Hostings

Cloudways: Realize Your Website's Potential With Flexible & Affordable Hosting. 24/7/365 Support, Managed Security, Automated Backups, and 24/7 Real-time Monitoring.

FastComet: Fast SSD Hosting, Free Migration, Hack-Free Security, 24/7 Super Fast Support, 45 Day Money Back Guarantee.

Recent Added Topics

  • Bug in translation system: load_theme_textdomain() returns true, files are available and accessible but the language defaults to english
  • Custom Elementor controls not appearing in the widget Advanced tab using injection hooks
  • Get the name of the template/*html file used
  • Trying to Add Paging to Single Post Page
  • Sharing media files between live and staging servers
  • How to display the description of a custom post type in the dashboard?
  • Critical error on image display
  • Copying WP data and files into new install?
  • How to determine the DirectAdmin WordPress backup date?
  • How to get list of ALL tables in the database?
© 2026 Read For Learn
  • Database
    • Oracle
    • SQL
  • algorithm
  • asp.net
  • assembly
  • binary
  • c#
  • Git
  • hex
  • HTML
  • iOS
  • language angnostic
  • math
  • matlab
  • Tips & Trick
  • Tools
  • windows
  • C
  • C++
  • Java
  • javascript
  • Python
  • R
  • Java Script
  • jQuery
  • PHP
  • WordPress