function cloud_export_skebby() { global $wpdb; $rows = cloud_lista_ordini(); $separator = ";"; $end_line = "\r\n"; $export = ""; $export .= "nome" . $separator; $export .= "cognome" . $separator; $export .= "soprannome" . $separator; $export .= "email" . $separator; $export .= "sesso" . $separator; $export .= "compleanno" . $separator; $export .= "indirizzo" . $separator; $export .= "citta" . $separator; $export .= "stato" . $separator; $export .= "cap" . $separator; $export .= "note" . $separator; $export .= "var1" . $separator; $export .= "var2" . $separator; $export .= "var3" . $separator; $export .= "numero" . $separator; $export .= "gruppi" . $separator; $export .= "altro numero" . $end_line; if (!empty($rows)) { foreach ($rows as $row) { $export .= $row->nominativo . $separator; $export .= $separator; $export .= $separator; $export .= $row->mail . $separator; $export .= $separator; $export .= $row->data_nascita_b . $separator; $export .= $row->indirizzo . $separator; $export .= $row->localita . ' - ' . $row->provincia . $separator; $export .= $separator; $export .= $separator; $export .= $separator; $export .= $separator; $export .= $separator; $export .= $row->mail . $separator; $export .= $row->telefono . $separator; $export .= $separator; $export .= $separator; $export .= $end_line; } //foreach } //empty header("Content-type: application/csv;charset=UTF-8"); header("Content-Disposition: inline; filename=lista_contatti_skebby.csv"); echo $export; exit; }
<style> .dataTables_filter{ text-align:right; } .dataTables_paginate{ text-align:center; } .dataTables_paginate a{ margin:5px; } .wp-list-table tr:hover{ background-color:#eeeeee; } </style> <h1>Lista ordini</h1> <?php $rows = cloud_lista_ordini(); ?> <table id='tbl_lista_ordini' class="wp-list-table widefat fixed posts"> <thead> <tr> <th>Stato</th> <th>Servizio</th> <th>Dettaglio serv.</th> <th>Data</th> <th>Bambino</th> <!-- th>Genitore</th> <th>Telefono</th --> <th>Catering</th> <th>Servizi</th> <th>Ultima modifica</th> <th></th> </tr> </thead>