Simple way of Exporting database to Csv format using php..

For Php Newbie.............

simple way of Exporting Data in Mysql Table To Csv Format:

<?php
$host = "localhost"; //hostname
$user = "root"; //admin
$password = ""; //password of Mysql
$database = "vino"; //database name
try {
if (mysql_connect($host, $user, $password)) {
dbconnection();
}
else {
throw new Exception('Unable to connect');
}
}

catch(Exception $e) {
echo $e->getMessage();
}

function dbconnection() {
mysql_select_db ("vino");
}

$query = ('SELECT * FROM tablename');
$result = mysql_query($query) or die(mysql_error());
header ('Content-Type: text/csv');
header ('Content-Disposition: attachment;filename=export.csv');
$row = mysql_fetch_assoc($result);

if ($row) {
echocsv(array_keys($row));
}

while ($row) {
echocsv($row);
$row = mysql_fetch_assoc($result);
}

function echocsv($fields) {
$separator = '';
foreach ($fields as $field) {
if (preg_match('/\\r|\\n|,|"/', $field)) {
$field = '"' . str_replace('"', '""', $field) . '"';
}
echo $separator . $field;
$separator = ',';
}
echo "\r\n";
}
?>

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*