Export PHP Result To Excel 2003

[furqan219]

Hi, How I can Export PHP Result which shown in table to excel using a Export Button on the Same Page.

:)

[furqan219]

This code show the result in a table cells so i need to add a excel button which export the data in excel file for the use. please help and thanks in advance.

<?php
$con = mysql_connect("localhost","xxxx","xxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$a= $_POST["SiteId"];
mysql_select_db("onm", $con);

$result = mysql_query("SELECT * FROM sitepinfo
WHERE SiteId='$a' ");


while($row = mysql_fetch_array($result))
  {
  echo "<table cellpadding=2 cellspacing=2 width=100%>
<tr>


</tr>";
  echo "<tr>";
  echo "<th bgcolor=#5D9BCC >SiteID</th>";
  echo "<td bgcolor=#FEE9A9>" . $row['SiteId'] . "</td>";
  
  
 
  

  echo "</tr>";
  echo "<tr>";
			
						
  echo "<th bgcolor=#5D9BCC>Alias</th>";
  echo "<td bgcolor=#FEE9A9>" . $row['Alias'] . "</td>";
  
    echo "</tr>";
	
	
	
	 echo "<tr>";
  echo "<th bgcolor=#5D9BCC>Address</th>";
  echo "<td bgcolor=#FEE9A9>" . $row['Address'] . "</td>";
    echo "</tr>";
	
	 echo "<tr>";
  echo "<th bgcolor=#5D9BCC>Region</th>";
  echo "<td bgcolor=#FEE9A9>" . $row['Region'] . "</td>";
    echo "</tr>";
	
		
	 echo "<tr>";
	echo "<th bgcolor=#5D9BCC>Agreement</th>";
	 echo "<td bgcolor=#9BCB5D><a href=".$row['pdf'].">".$row['pdf']."</a></td>";
	  

	  echo "</tr>";
	  
	  
	    echo "<tr>";
	echo "<th bgcolor=#5D9BCC>Purchase Order</th>";
	 echo "<td bgcolor=#CB9B5D><a href=".$row['pdf'].">".$row['pdf']."</a></td>";

	  echo "</tr>";
	  
	   echo "<tr>";
	 echo "<td bgcolor=#9B5DCA><a href='update.php?id={$row[SiteId]}'>".stripslashes(Update)."</a>
	   </td>";
	
	  echo "</tr>";
	  
	  echo "<tr>";
	 echo "<td bgcolor=#9B5DCA><a href='delete.php?id={$row[SiteId]}'>".stripslashes(delete)."</a>
	   </td>";
	
	  echo "</tr>";
  }
echo "</table>";


mysql_close($con);

?>

[almostbob]

excel file format is proprietary,
excel can read/write .csv comma separated values
php can read/write .csv comma separated values

a bunch of tutorials on creating the button to do so http://www.google.com/search?hl=en&q=php+export+mysql+table+as+.csv+tutorial&meta= have no idea how myself

[furqan219]

<?
// Connect database. 
mysql_connect("localhost","","");
mysql_select_db("tutorial");

// Get data records from table. 
$result=mysql_query("select * from name_list order by id asc");

// Functions for export to excel.
function xlsBOF() { 
echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0); 
return; 
} 
function xlsEOF() { 
echo pack("ss", 0x0A, 0x00); 
return; 
} 
function xlsWriteNumber($Row, $Col, $Value) { 
echo pack("sssss", 0x203, 14, $Row, $Col, 0x0); 
echo pack("d", $Value); 
return; 
} 
function xlsWriteLabel($Row, $Col, $Value ) { 
$L = strlen($Value); 
echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L); 
echo $Value; 
return; 
} 
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");;
header("Content-Disposition: attachment;filename=orderlist.xls "); 
header("Content-Transfer-Encoding: binary ");

xlsBOF();

/*
Make a top line on your excel sheet at line 1 (starting at 0).
The first number is the row number and the second number is the column, both are start at '0'
*/

xlsWriteLabel(0,0,"List of car company.");

// Make column labels. (at line 3)
xlsWriteLabel(2,0,"No.");
xlsWriteLabel(2,1,"Company");

$xlsRow = 3;

// Put data records from mysql by while loop.
while($row=mysql_fetch_array($result)){

xlsWriteNumber($xlsRow,0,$row['id']);
xlsWriteLabel($xlsRow,1,$row['name']);

$xlsRow++;
} 
xlsEOF();
exit();
?>

[furqan219]

above code is not working

[almostbob]

.xls is proprietary and contains more than just the data, not sure if your functions are accurate, but they appear to match what I have seen before

excel can read/write .csv comma separated values
php can read/write .csv comma separated values
which is great if the data is all you need, not sure if equations transfer

a bunch of tutorials on creating writing .xls with phphttp://www.google.com/search?php .xls tutorial have no idea how myself

(Good Luck)

Try a couple of PEAR files:

http://devzone.zend.com/article/3336

Should work.

[chrishea]

Excel can read HTML and open it as a spreadsheet. My Desktop Write utility takes advantage of this to create Excel, Word and other types of output. Get it here:
http://innovationsdesign.net/wb_2.7/pages/tech-resources/downloads.php