User Assistant You can add a taxonomy selection control to your Elementor widget by modifying the `register_controls()` method. Here’s how you can add an option to choose the taxonomy (`leistung`) for filtering `projekte`: ### Updated Code: <?php class Elementor_ProjectSliderWidget_Widget extends ElementorWidget_Base { public function get_name() { return 'project_slider'; } public function get_title() { return esc_html__( […]
User function export_posts_to_csv() { ini_set('max_input_vars', 95000); global $wpdb; set_time_limit(0); ini_set('memory_limit', '15024M'); // Get category filter (if any) $catex = isset($_GET['catex']) ? intval($_GET['catex']) : -1; $sqlcon = ''; $sqlj = ''; if ($catex !== -1) { $sqlcon = $wpdb->prepare(" AND tt.taxonomy = 'category' AND t.term_id = %d", $catex); } else { $sqlcon = " AND tt.taxonomy […]
User function export_posts_to_csv() { global $wpdb; // Get category filter (if any) $catex = isset($_GET['catex']) ? intval($_GET['catex']) : -1; $sqlcon = ''; $sqlj = ''; if ($catex !== -1) { $sqlcon = $wpdb->prepare(" AND tt.taxonomy = 'category' AND t.term_id = %d", $catex); } else { $sqlcon = " AND tt.taxonomy = 'category' AND t.term_id != […]
User Currently I've applied all data set export for plantname category But currently its exporting 19350 records at a time, May be there are some server resources or more needs in sql query optimization Correct above sentence Assistant Currently, I have applied the export for the entire dataset in the "plantname" category. However, it is […]
User sqlj = " JOIN $wpdb->term_relationships tr ON (p.ID = tr.object_id) JOIN $wpdb->term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id) JOIN $wpdb->terms t ON (tt.term_id = t.term_id)"; // Query all records $querystr = "SELECT DISTINCT p.ID, p.post_title AS title, p.post_modified FROM $wpdb->posts p $sqlj WHERE p.post_type = 'post' AND p.post_status = 'publish' $sqlcon ORDER BY p.post_date DESC"; […]
User There are 31000 records but it's download in csv only 18000 wordpress download csv Assistant The issue of incomplete CSV downloads in WordPress (e.g., exporting 18,000 records out of 31,000) often arises due to limitations on server resources or plugin settings. Here are the key areas to investigate and resolve this issue: ### 1. […]
User Assistant Your PHP script to generate and download a CSV seems to have some logical issues that might be causing the empty CSV file. Let’s debug the potential causes: ### Issues and Fixes: 1. **Query Results:** Ensure the `$pageposts` query is returning data. You can add a `var_dump($querystr)` and `var_dump($pageposts)` to verify the SQL […]
User This site can’t be reached The webpage at https://www.backyardgardener.com/download-csv/?pagen=1&$previousRows=0&catex=65 might be temporarily down or it may have moved permanently to a new web address. ERR_INVALID_RESPONSE Assistant The error `ERR_INVALID_RESPONSE` usually indicates an issue with the server response. Here's how you can troubleshoot and resolve the issue: ### 1. **Check Server Logs** – Look at […]
User Assistant The issue with your code not downloading all 32,000 records lies in how PHP handles memory, execution limits, and output buffering for large datasets. Here's how to address it: ### Adjustments to Ensure Large Record Sets Are Processed 1. **Pagination**: Fetch records in smaller batches to prevent memory exhaustion. 2. **Remove `ob_flush` and […]
User Assistant To handle large datasets when exporting over 50,000 rows in WordPress, you need to address both memory limitations and ensure efficient processing. Here's an improved version of your script: ### Key Adjustments: 1. **Chunk Processing:** Instead of loading all data into memory, process the data in chunks using pagination. 2. **Memory and Time […]