Don't know if this will help, but this is how I offer web clients to "save
as excel" in cold fusion:
<cfif #ViewInExcel# is "Y">
<cfcontent type="application/vnd.ms-excel">
</cfif>
the key is to change the content like above. I am not sure how to do this
in PHP. But I am sure if you look around you will find it.
Then just output the table, with each field broken up by <td> tags.
No html tags or headings nothing but the table, TD, and TH tags need to be
output. I have just recently started working in php, if I get a minute to
put a example together in php I'll let you know.
This will ask them if they want to save the file or open the file.
The thing is you have to tell the client browser it is a type of file that
it recognizes.
Hope that helps, good luck.
Todd Hackathorn
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 2:33 PM
To: [EMAIL PROTECTED]
Subject: need to know how to export database to CSV format
I have a php website connecting to mysql database.
How can i have a user export his database through the webpage to csv format?
I would like the user to have a button he can press that would pop up a
"save as" screen so he can save his database.
I need to also be able that he can only save HIS OWN entries (PERSON_ID =
*******)
Can anyone direct me to a link that shows how you do that or explain to me
how to do this?
thanks very much
Noam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
