SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Evangelist
    Join Date
    Mar 2011
    Location
    Bellingham, WA
    Posts
    450
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Plain Jane mysql to excel via PHP

    Hello!

    I have a webpage that's dynamically generating student names, scores on exams, and names of assignments; users (aka teachers) will be able to view specific information from the database based on information specific to them. In particular, the headers are names of dynamically generated assignment names, then each row will have a student's info: name and then scores for the generated assignments.

    Student Name | First Assignment | Second Assignment
    Joe Shmoe | 3 | 4
    Mikey Mike | 8 | 11

    I've got it set up so that it works on the webpage, but it would be super helpful if my users can also download the information to an excel spreadsheet. Could someone point me in the right direction in the best way to get started on this, namely dynamically pulling the info from my database and then plopping it into a .csv file?

    Thanks so much,

    Eric
    Last edited by kreut; Mar 23, 2011 at 15:54. Reason: bad formatting

  2. #2
    SitePoint Addict MrBaseball34's Avatar
    Join Date
    Sep 2002
    Location
    Round Rock, Texas
    Posts
    275
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Did you ever think about using Google to find code snippets for the term "PHP table to CSV"? Thousands of links.
    MrBaseball34
    Hook'Em Horns!

  3. #3
    SitePoint Evangelist
    Join Date
    Mar 2011
    Location
    Bellingham, WA
    Posts
    450
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Sorry....I surely should have Googled it first: I was getting a bit frustrated with other aspects of my site and wasn't thinking clearly. But, I took your advice and I'm 99% there. If I can't figure out the other 1%, maybe I'll send out another post.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •