Login   Register  
PHP Classes
elePHPant
Icontem

File: export_file.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of raju mazumder  >  Export To Excel  >  export_file.php  >  Download  
File: export_file.php
Role: Example script
Content type: text/plain
Description: php file
Class: Export To Excel
Generate HTML tables from MySQL query results
Author: By
Last change:
Date: 6 years ago
Size: 570 bytes
 

Contents

Class file image Download
<?php
include_once('databasecon.php');//to make database connecti

$cap="<table align=center border=1px><th>PERSONAL DETAILS</th>";//CAPTION OF THIS REPORT
$title="<tr><td><b>NAME</b></td><td><b>E-MAIL</b></td><td><b>CITY</b></td></tr>";//TABLE HEADER

$tmp_per_res=mysql_query("select * from personalinfo");
while(
$row=mysql_fetch_array($tmp_per_res,MYSQL_BOTH))
{

$body.="<tr><td>".$row['vName']."</td><td>"
        
.$row['vEmail']."</td><td>"
        
.$row['vCity']                            
        .
"</td></tr>";
                    

}
echo 
$cap.$title.$body."</table>";                        
                        
?>