Exporting a HTML Form to Excell

Discussion in 'PHP' started by Traffic_Masters, Oct 9, 2010.

  1. #1
    Hello and thanks for clicking my thread.

    Im trying to make my admin job a little easier, basically what I do is take student data that has been written down on paper and enter it 2 times, Once onto the works Database using a javascript webform the IT team created then into an excel file for our office to keep track of which student is booked in for a course.

    I've created a HTML form and im trying to set it up so all I need to do is enter the students data into this form and it automatically enters it into an excel file then onto the works database.

    Im new to PHP and HTML so I dont want someone to write this script for me, I want to learn myself, Im just looking for some friendly advice/pointers.

    So to summarize I type the data into

    My html form

    Which copys the data into my works HTML form

    Then into the excel file on then next again row

    Again, thanks for reading

    Stephen
     

    Attached Files:

    Traffic_Masters, Oct 9, 2010 IP
  2. JoelLarson

    JoelLarson Peon

    Messages:
    61
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    For PHP, you submit the form to a PHP page. The PHP page then parses the data that's set in $_POST (you can see by using var_dump($_POST) ). Then follow the instructions on this website to learn how to take the data and make it into an excel format:
    http://www.the-art-of-web.com/php/dataexport/
    Code (markup):
    You'll import it into Excel using CSV (Comma Segmented Values).
     
    JoelLarson, Oct 9, 2010 IP
  3. Traffic_Masters

    Traffic_Masters Well-Known Member

    Messages:
    351
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    130
    #3
    JoelLarson, thank you very much for the reply.

    I started on the php page lastnight writing it to the CSV file, I will continue today.

    Thanks again for the link ill post an update later on
     
    Traffic_Masters, Oct 10, 2010 IP
  4. articlesdirectory

    articlesdirectory Greenhorn

    Messages:
    57
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    18
    #4
    JoelLarson i have visited the link you entered in code area. I analysed it and found it in good of its health. I modified it according to my requirement and running the script. can you help me to give me a code in which we may resize the image of every type and can avoid from image blurring. I have also the script but it doesnot work for some type of image extension.

    Hoping for the best and waiting for your kind reply.
    Muddasar Khan
     
    articlesdirectory, Oct 10, 2010 IP