midlandi

Hey All,

I have found a superb programmer/website developer.
How do i know he's good? I had need of some help today, quickly!
The result was...
Request..answered within 10 minutes
Price...very reasonable
Payment..once complete
Timescale...very,very fast.
Problems...NONE

Who?

Lewis
lewisphillips[at]gmail[dot]com

100% recommended.

http://www.iwebtool.com/webmasters/antispam/

__________________

anandkumarpal

hi all,

I am programming a web site. which need a functionalty which will fetch data from mysql and create a excel file on cllient system.

I tried many codes but it is not working.

can any one help me?.

Chart Music

Nice recommendation midlandi! The guy must of impressed you,

__________________
Eco Tours | Gift Baskets | Random Keyword

See a good post?
<--Give thanks by clicking left of post.

midlandi

Very true, I dont normally recommend this strongly but the guy is truly good and deserves recognition.

__________________

anandkumarpal

hi all,
can any one help this php code is not working with I.E. but it is working fine with firefox. I don't now what to change to make it compatible with IE.
php code is as follows:


<?php
session_start();
ob_start();
require_once('connection.php');
$connection=mysql_connect($server,$user,$pass);

mysql_select_db($db, $connection);
$query = "SELECT fname, lname FROM students";
$result = mysql_query($query,$connection) or die('Error, query failed');
$tsv = array();
$html = array();
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
$tsv[] = implode("\t", $row);
$html[] = "<tr><td>" .implode("</td><td>", $row) . "</td></tr>";
}
$tsv = implode("\r\n", $tsv);
$html = "<table>" . implode("\r\n", $html) . "</table>";
$fileName = 'mysql-to-excel.xls';
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$fileName");
echo $tsv;
echo $html;
mysql_close($connection);
?>

lewisphillips

Thanks for the review

With regards to the PHP generated XLS file, i think the issue here will turn out to be an isolated browser issue with your computer. I cant see anything wrong with your code at first glance and as it works in firefox, that implies that it is being parsed correctly.

If you send me a link to the said file, i will be happy to take a look to see if it works on my computer.