<?php



$clave = $_POST['pass'];
if ($clave != "alfabeta"){
echo "La clave es incorrecta";
}else{


// Database Connection


$host="localhost";
$uname="tic_web";
$pass="tic_web";
$database="guias";
$db_table_name="registro";

/*
$db_host="localhost";
$db_user="root";
$db_password="";
$db_name="tutorias";
$db_table_name="registro";
*/
$connection=mysql_connect($host,$uname,$pass); 

echo mysql_error();

//or die("Database Connection Failed");
$selectdb=mysql_select_db($database) or die("Database could not be selected");	
$result=mysql_select_db($database)
or die("database cannot be selected <br>");

	
// Fetch Record from Database

$output			= "";
$table 			= $db_table_name; 
$sql 			= mysql_query("select * from $table");
$columns_total 	= mysql_num_fields($sql);

// Get The Field Name

for ($i = 0; $i < $columns_total; $i++) {
	$heading	=	mysql_field_name($sql, $i);
	$output		.= '"'.$heading.'";';
}
$output .="\n";

// Get Records from the table

while ($row = mysql_fetch_array($sql)) {
for ($i = 0; $i < $columns_total; $i++) {
$output .='"'.$row["$i"].'";';
}
$output .="\n";
}

// Download the file

$filename =  "registros.csv";
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename='.$filename);

echo $output;
exit;
}

?>
