Saturday, 1 June 2013
Mysql datadase to Excel Sheet convertsion PHP script
PHP script for mysql database to excel can convert automatically the file run in browser.
Database, User name, Password, Table Name are included/mention here. Consider user requirements.
<?php
ob_start();
mysql_connect('localhost','root','');
mysql_select_db('test');
$sql = "SELECT * from log_attempts";
$res = mysql_query( $sql) or die();
$count = mysql_num_fields($res);
// fetch table header from database
$header = '';
for ($i = 0; $i < $count; $i++){
$header .= mysql_field_name($res, $i)."\t";
}
// fetch data each row, store on tabular row data
while($row = mysql_fetch_row($res)){
$line = '';
foreach($row as $value){
if(!isset($value) || $value == ""){
$value = "\t";
}else{
$value = str_replace('"', '""', $value);
$value = '"' . $value . '"' . "\t";
}
$line .= $value;
}
$data .= trim($line)."\n";
$data = str_replace("\r", "", $data);
}
$name=date('d-m-y').'-list.xls';
header("Content-type:application/vnd.ms-excel;name='excel'");
header("Content-Disposition: attachment; filename=$name");
header("Pragma: no-cache");
header("Expires: 0");
// Output data
echo $header."\n\n".$data;
?>
Subscribe to:
Post Comments (Atom)
OWASP - Top 10 Policies
Top 10 Web Application Security Risks There are three new categories, four categories with naming and scoping changes, and some consolidat...
-
Ng7- NGXPermission - Role Based app access ---------------------------------------------- To install this library, run: $ npm install ...
-
Module Federation The Module Federation is actually part of Webpack config. This config enables us to expose or receive different parts of t...
No comments:
Post a Comment