DaniWeb Forum Index > Web Development > PHP

Php, Mysql and Excel

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jan 2008

Posts: 74

Reputation: Vai is an unknown quantity at this point

Solved Threads: 5

Vai

Offline

Junior Poster in Training

Php, Mysql and Excel

Jul 10th, 2008

I am trying to write or find scripts that will:

1- create a script that will allow someone to Unsubscribe to a mailing list based on email address.

2- export data to a predefined excel file which will be used to print mail labels.

I have looked and looked and have found nothing which works properly.

Thank you for any and help.

Vai

•

Join Date: Jun 2007

Posts: 1,227

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 167

kkeith29

Offline

Nearly a Posting Virtuoso

Re: Php, Mysql and Excel

Jul 10th, 2008

do you have a mailing list setup that someone can unsubscribe from. if not, i recommend using www.mailing-manager.com. they will have everything you need.

i have a class to export mysql database to excel file. i have a working example if you need one.

•

Join Date: Jan 2008

Posts: 74

Reputation: Vai is an unknown quantity at this point

Solved Threads: 5

Vai

Offline

Junior Poster in Training

Re: Php, Mysql and Excel

Jul 10th, 2008

Keith,

If you have the a working example of exporting mysql data to excel I would appreciate that. The mailing list signup works almost flawlessly.... I just need to get the unsubscribe part working.

Thanks bud

•

Join Date: Jun 2007

Posts: 1,227

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 167

kkeith29

Offline

Nearly a Posting Virtuoso

Re: Php, Mysql and Excel

Jul 11th, 2008

catch me on skype sometime tomorrow and I will give you the url and credentials to the site. i would post it here but the example is in one of my administrative centers for a site that hasn't gone live yet and I don't want everyone having access.

also, send me your mailing list script so i can add the unsubscribe part.

Last edited by kkeith29; Jul 11th, 2008 at 1:38 am.

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: Php, Mysql and Excel

Jul 11th, 2008

•

If you have the a working example of exporting mysql data to excel I would appreciate that.

A simple example.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
$file="test.xls";
$test="<table border=1><tr><td>Cell 1</td><td>Cell 2</td></tr></table>";
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$file");
echo $test;
?>
<?php
$file="test.xls";
$test="<table border=1><tr><td>Cell 1</td><td>Cell 2</td></tr></table>";
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$file");
echo $test;
?>

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Jan 2008

Posts: 74

Reputation: Vai is an unknown quantity at this point

Solved Threads: 5

Vai

Offline

Junior Poster in Training

Re: Php, Mysql and Excel

Jul 11th, 2008

Nav33n,

That works to open an xls file, w/ cell 1- cell2 but what do I need to do to have actual data displayed from the database?

Thanks again

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: Php, Mysql and Excel

Jul 11th, 2008

Instead of

Help with Code Tags

PHP Syntax (Toggle Plain Text)

 
$test="<table border=1><tr><td>Cell 1</td><td>Cell 2</td></tr></table>";

fetch the data from the database and use it.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$text = "Name \t Age \n"; //header
while($row = mysql_fetch_array($result)) {
 $text.=$row['name']."\t".$row['age']."\n"; //records
}
$text = "Name \t Age \n"; //header
while($row = mysql_fetch_array($result)) {
 $text.=$row['name']."\t".$row['age']."\n"; //records
}

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Jun 2008

Posts: 849

Reputation: R0bb0b is on a distinguished road

Solved Threads: 67

R0bb0b

Offline

Practically a Posting Shark

Re: Php, Mysql and Excel

Jul 11th, 2008

•

Originally Posted by nav33n

Help with Code Tags

php Syntax (Toggle Plain Text)
$test="<table border=1><tr><td>Cell 1</td><td>Cell 2</td></tr></table>";
$test="<table border=1><tr><td>Cell 1</td><td>Cell 2</td></tr></table>";

Wow! That really works! I've always done just plain csv files, I didn't know you could use html. You've made my day.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
$file="test.xls";
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$file");
?>
<table cellpadding="0" cellspacing="0">
	<tr>
		<td>cell one</td>
		<td>cell two</td>
		<td>cell three</td>
		<td>cell four</td>
	</tr>
	<tr>
		<td colspan="4" align="center"><b>cell one</b></td>
	</tr>
	<tr>
		<td>cell one</td>
		<td>cell two</td>
		<td>cell three</td>
		<td>cell four</td>
	</tr>
</table>
<?php
$file="test.xls";
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$file");
?>
<table cellpadding="0" cellspacing="0">
	<tr>
		<td>cell one</td>
		<td>cell two</td>
		<td>cell three</td>
		<td>cell four</td>
	</tr>
	<tr>
		<td colspan="4" align="center"><b>cell one</b></td>
	</tr>
	<tr>
		<td>cell one</td>
		<td>cell two</td>
		<td>cell three</td>
		<td>cell four</td>
	</tr>
</table>

Freaking cool man! Thx.

“Be who you are and say what you feel because those who mind don't matter and those who matter don't mind.” - Dr. Seuss

-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.