| 1 | <?PHP |
| 2 | include_once('/var/www/secure.php'); |
| 3 | function mysqli_field_name($result, $field_offset) |
| 4 | { |
| 5 | $properties = mysqli_fetch_field_direct($result, $field_offset); |
| 6 | return is_object($properties) ? $properties->name : null; |
| 7 | } |
| 8 | if ($_COOKIE['level'] == 'admin'){ |
| 9 | $q = "SELECT date_time_signed, signed_name_as, VTRID, petition_id, VoterList_table FROM signatures where signature_status = 'verified' ORDER BY id"; |
| 10 | }else{ |
| 11 | $q = "SELECT date_time_signed, signed_name_as, VTRID, VoterList_table FROM signatures where petition_id = '$_COOKIE[petition_id]' and signature_status = 'verified' ORDER BY id"; |
| 12 | } |
| 13 | |
| 14 | $r = $petition->query($q); |
| 15 | |
| 16 | $fields = mysqli_num_fields ( $r ); |
| 17 | |
| 18 | for ( $i = 0; $i < $fields; $i++ ) |
| 19 | { |
| 20 | $header .= mysqli_field_name( $r , $i ) . "\t"; |
| 21 | } |
| 22 | // https://www.php.net/manual/en/mysqli-result.fetch-row.php |
| 23 | while( $row = $r->fetch_row() ) |
| 24 | { |
| 25 | $line = ''; |
| 26 | foreach( $row as $value ) |
| 27 | { |
| 28 | if ( ( !isset( $value ) ) || ( $value == "" ) ) |
| 29 | { |
| 30 | $value = "\t"; |
| 31 | } |
| 32 | else |
| 33 | { |
| 34 | $value = str_replace( '"' , '""' , $value ); |
| 35 | $value = '"' . $value . '"' . "\t"; |
| 36 | } |
| 37 | $line .= $value; |
| 38 | } |
| 39 | $data .= trim( $line ) . "\n"; |
| 40 | } |
| 41 | $data = str_replace( "\r" , "" , $data ); |
| 42 | |
| 43 | if ( $data == "" ) |
| 44 | { |
| 45 | $data = "\n(0) Records Found!\n"; |
| 46 | } |
| 47 | |
| 48 | header("Content-type: application/octet-stream"); |
| 49 | header("Content-Disposition: attachment; filename=petition_signatures_".time().".xls"); |
| 50 | header("Pragma: no-cache"); |
| 51 | header("Expires: 0"); |
| 52 | print "$header\n$data"; |