Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Nov 2005
    Posts
    27
    Member #
    11781
    Pretty sure this is fairly straitforward - I'm setting up a site for a friend which involves people filling in HTML questionnaires and the data being dumped in (what else?) a MySQL table. She'll need to get at the data quite regularly in XLS format so I need convenient little PHP script that could either save the data as an XLS file on me webserver or that could serve the binary file up directly.

    Any ideas?

    Authentication may be an issue and I don't know how to use HTTPS so it might be useful to send it as an attachnent to a predetermined email address if this changes matters.

  2.  

  3. #2
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    phpMyAdmin can export tables in formats Excel can read.

    http://www.phpmyadmin.net/
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!

  4. #3
    Senior Member
    Join Date
    Jun 2005
    Location
    Atlanta, GA
    Posts
    4,146
    Member #
    10263
    Liked
    1 times
    And you might want to look into the PEAR library's Spreadsheet_Excel_Writer.

  5. #4
    Junior Member
    Join Date
    Nov 2005
    Posts
    27
    Member #
    11781
    That's ace. Reckon the PEAR thing'll do just what I want. Cheers


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 11:40 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com