Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function jsa_export_func()
- {
- $filename = home_url . "\wp-content\plugins\jsa-database\csv\JSA-Download.csv";
- $fh = fopen( $filename, 'w' ) or die("Can't open file");
- global $wpdb;
- $results = $wpdb->get_results( $wpdb->prepare("SELECT ID, name, postdate, posttitle, location
- FROM wp_jsadb;", ARRAY_A ) );
- $headerDisplayed = false;
- foreach ( $results as $data ) {
- if ( !$headerDisplayed ) {
- fputcsv($fh, array_keys($data));
- $headerDisplayed = true;
- }
- fputcsv($fh, $data);
- }
- fclose($fh);
- exit();
- echo '<br/>' . "Right click and Save Target As: " . '<a href=" ' . $filename . ' " target="_blank">[DOWNLOAD CSV]</a>';
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement