[RESOLVED] saving a php table as excel

david_brown

Hey Everyone -

Quick question -

Using PHP - I query by SQL database - build a table looking something like this

		?> <td> <?php echo $fname; ?> &nbsp; </td> <?php
		$lname = $row[3];
		?> <td> <?php echo $lname; ?> &nbsp; </td> <?php
		$address = $row[4];
		?> <td> <?php echo $address; ?> &nbsp; </td> <?php
		$county = $row[5];
		?> <td> <?php echo $county; ?> &nbsp; </td> <?php
		$x = $row[6];
		?> <td> <?php echo $x; ?> &nbsp; </td> <?php
		$y = $row[7];
		?> <td> <?php echo $y; ?> &nbsp; </td> <?php
		$SLA_start = $row[9];
		?> <td> <?php echo $SLA_start; ?> &nbsp; </td> <?php
		$summary = $row[21];
		?> <td> <?php echo $summary; ?> &nbsp; </td>  <?php

I would like to add a download button/Link to download the table (I just queried) and save it as a excel.... - (well have the option there for people to download)

Any suggestions?

THANKS EVERYONE!! (In advance)

Kind Regards
David Brown

dagon

save as csv is your best option, excel and almost everything else can read that.

fputcsv

Krik

I don't think you can make an xls file with PHP. You can make it a CSV file, as CSV is just a text file with the values separated by a comma and Excell can read it as spead sheet.

You will want to look into the [man]filesystem[/man] functions for creating a file with php.

dagon

Krik;10962394 wrote:
I don't think you can make an xls

you can, but its a pain, and not worth it.

dagon

Krik;10962394 wrote:
I don't think you can make an xls file with PHP. You can make it a CSV file, as CSV is just a text file with the values separated by a comma and Excell can read it as spead sheet.

You will want to look into the [man]filesystem[/man] functions for creating a file with php.

W3Schools.com for HTML, Javascript, and CSS

lol, and a whole lot of misinformation and garbage.