Php, Mysql and Excel

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 425,796 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,148 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 727 | Replies: 8 | Solved

•

Join Date: Jan 2008

Posts: 70

Reputation: Vai is an unknown quantity at this point

Rep Power: 1

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

Location: Valley Center, Kansas

Posts: 554

Reputation: kkeith29 is on a distinguished road

Rep Power: 3

Solved Threads: 57

kkeith29

Offline

Posting Pro

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: 70

Reputation: Vai is an unknown quantity at this point

Rep Power: 1

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

Location: Valley Center, Kansas

Posts: 554

Reputation: kkeith29 is on a distinguished road

Rep Power: 3

Solved Threads: 57

kkeith29

Offline

Posting Pro

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 12:38 am.

•

Join Date: Nov 2007

Location: Bangalore, India

Posts: 3,098

Reputation: nav33n has a spectacular aura about

Rep Power: 8

Solved Threads: 240

nav33n

Offline

Posting Sensei

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;
?>

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

*PM asking for help will be ignored*

•

Join Date: Jan 2008

Posts: 70

Reputation: Vai is an unknown quantity at this point

Rep Power: 1

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

Location: Bangalore, India

Posts: 3,098

Reputation: nav33n has a spectacular aura about

Rep Power: 8

Solved Threads: 240

nav33n

Offline

Posting Sensei

Re: Php, Mysql and Excel

Jul 11th, 2008

Instead of

Help with Code Tags

(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
}

•

Join Date: Jun 2008

Location: Phoenix, AZ

Posts: 769

Reputation: R0bb0b is on a distinguished road

Rep Power: 2

Solved Threads: 63

R0bb0b

Offline

Master Poster

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>