./c0de/php/lsq.txt

0.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
<?php
//Neutralisd - Excel data extractor.
define(db_host, "localhost");
define(db_user, "user");
define(db_pass, "password");
define(db_link, mysql_connect(db_host,db_user,db_pass)); 
define(db_name, "db-name");
define(db_table, "dk-table");
mysql_select_db(db_name); 
 
 
$select = "SELECT username, password, email FROM users";
$export = mysql_query($select);
$fields = mysql_num_fields($export);
 
for ($i = 0; $i < $fields; $i++) { 
    $header .= mysql_field_name($export, $i) . "\t"; 
} 
 
while($row = mysql_fetch_row($export)) {
    $line = ''; 
    foreach($row as $value) {                                             
        if ((!isset($value)) OR ($value == "")) { 
            $value = "\t"; 
        } else {
            $value = str_replace('"', '""', $value); 
            $value = '"' . $value . '"' . "\t"; 
        } 
        $line .= $value; 
    }
    $data .= trim($line)."\n"; 
} 
$data = str_replace("\r","",$data); 
 
if ($data == "") { 
    $data = "\n(0) Records Found!\n";                         
} 
 
header("Content-type: application/vnd.ms-excel "); 
header("Content-Disposition: attachment; filename=extraction.xls");
header("Pragma: no-cache"); 
header("Expires: 0");
print "$header\n$data";
?>
 

Back