Send HTML form data to Excel file then email to user

  • Hali: Closed
  • Zawadi: $20
  • Wasilisho Zilizopokelewa: 6
  • Mshindi: saddy007

Maelezo ya Shindano

DESCRIPTION:
I need the ability to send form results to an excel (.xls or xlsx) spreadsheet and then email the user that particular spreadsheet with all the new data in it.
I already have the HTML form built and I can provide an example of the excel file I want.

I need you to build me the code in php that will do all of this for me.


HOW IT SHOULD WORK:
When the internet user completes the form online, I will receive an email with the attached spreadsheet with the form results. (That's all)
Inside the spreadsheet will be all of the data that user entered into the form.



YOU ARE RESPONSIBLE FOR THE FOLLOWING:
- Create a php file which process my form (once it's sent) and make the form results go to Excel.
- Then sending that excel file as an email attachment to me.


TECHNICAL DETAILS:
- The form is already created. Is has 70 fields which are all numbers.

- Example of what is arriving today by email:
Age 1: 50
Age 2: 10

- Server supports
HTML / XHTML / CSS / JS / WAP / WML / XML
PHP
Perl Script
CGI Scripts
Phyton

- HTML Side:
The fields are select values like this:
<select name="age1" required="required" id="age1">
<option value="Ingrese valor" selected="selected"></option>
<option value="0">20</option>
<option value="1">30</option>
<option value="2">40</option>
<option value="3">50</option>
<option value="4">60</option>
<option value="5">70</option>
</select>

-PHP side (now):
username: $nombre
\nage1: $age1
\nage2: $age2
\nage3: $age3


UPDATES:
- Please feel free to send me demos. If I tried the code and it's succesfully, then you are the winner.
- The email attachment should go a defined email in the code. The user never enters his email.
- Lastly, the attachment name will be generate from a variable. Example:
name1.xls
name2.xls
- Responses should arrive in columns. Example
A1: response 1
A2: Response 2

B1: 10
B2: 20
Attached is an example.

Ujuzi unaopendekezwa

Maoni ya Muajiri

“Muhammad did an excellent job in a very short time. He also call me later to explain some details about the script he created and he reassured everything was working fine. 5 stars to him! ”

Picha ya Profaili ewhttp, Argentina.

Bodi ya Ufafanuzi ya Umma

  • saddy007
    saddy007
    • Miaka 8 iliyopita

    Can you please send me your server details so that I can check that?

    • Miaka 8 iliyopita
    1. saddy007
      saddy007
      • Miaka 8 iliyopita

      Are you working on localhost host or do you have your own online server?

      • Miaka 8 iliyopita
    2. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      online server

      • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    Here is the code ( http://creativecp.com/dev/export-csv/form_today.txt ). The code in in text format so just replace it in your file. Please make a backup of your previous file because as I was not able to check the code on your new file, therefore there might occur some errors.

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      When I sent the form, the site stays blank and it doesn't arrive anything to my email. I sending a picture "test_failed"

      • Miaka 8 iliyopita
    2. saddy007
      saddy007
      • Miaka 8 iliyopita

      Can you send me your server details?

      • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    or send me your complete screenshot of browser

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      I've already sent it by "test_failed.png". It's only a part (but the one you need)

      • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    Please award me the contest once you got it working

    • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    Try this for PHPexcel, http://creativecp.com/dev/export-csv/PHPexcel.zip

    • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    You have to include two PHP libraries, I'm attaching the URL for their zip, just extract those into the folder where the form is. Here is the PHPmailer ( http://creativecp.com/dev/export-csv/PHPmailer.zip ) and the second one is PHPexcel ( http://creativecp.com/dev/export-csv/PHPExcel.zip )

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      http://creativecp.com/dev/export-csv/PHPExcel.zip
      404 error not found

      • Miaka 8 iliyopita
    2. saddy007
      saddy007
      • Miaka 8 iliyopita

      http://creativecp.com/dev/export-csv/PHPexcel.zip

      • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    please read comment in my latest entry of excel file

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      I uploaded the actual code. Just replace the code to fit and we are done.

      • Miaka 8 iliyopita
    2. saddy007
      saddy007
      • Miaka 8 iliyopita

      Okay I'm working on it.

      • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    The file is opening perfectly on my side. Is there any way you can show me what you get?

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      I'm seeing the correct result now

      • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    Hi, I've updated the excel file as you've said. Please have a look. URL = http://creativecp.com/dev/export-csv/

    • Miaka 8 iliyopita
    1. saddy007
      saddy007
      • Miaka 8 iliyopita

      Is there any way you can send me that file or show me the picture so that I can check?

      • Miaka 8 iliyopita
    2. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      I'm seeing the correct result now

      • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    Please check my latest entry and read the description. I've uploaded the changes to my server and now it should work fine on your side. URL - http://creativecp.com/dev/export-csv/

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      It's working fine now. I uploaded an image with two minor changes.

      • Miaka 8 iliyopita
    2. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      I'll upload th HTML form, you code all the entries and we are done.

      • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    Hi, Please enter a valid excel file. the file you've provided doesn't contain anything. And secondly check the comment in first entry

    • Miaka 8 iliyopita
    1. saddy007
      saddy007
      • Miaka 8 iliyopita

      Can you please send me your html file that contains the form?

      • Miaka 8 iliyopita
    2. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      Muhammad. I uploaded an image in case you still cannot access the file (very strange). I can open it perfectly.

      • Miaka 8 iliyopita
  • ewhttp
    Mwenye Shindano
    • Miaka 8 iliyopita

    Hi all.
    Please feel free to send me demos. If I tried the code and it's succesfully, then you are the winner.

    The email attachment should go a defined email in the code. The user never enters his email.

    On the other hand, there was a mistake in the excel format in the brief. It said (XML) instead of saying XLS.

    Lastly, the attachment name will be generate from a variable. Example:
    name1.xls
    name2.xls

    Thanks!

    • Miaka 8 iliyopita
    1. hpdude
      hpdude
      • Miaka 8 iliyopita

      Yes, I know, the download option is just for your reference. Can you send a demo file or something on exactly how you want it to be like?

      • Miaka 8 iliyopita
    2. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      Sure. I attached the file before your answer =)

      • Miaka 8 iliyopita
  • hpdude
    hpdude
    • Miaka 8 iliyopita

    Do you want Excel CSV or XML ?

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      XLS or XLSX

      • Miaka 8 iliyopita
  • saddy007
    saddy007
    • Miaka 8 iliyopita

    It should only be .xml file OR can be any excel file?

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      it should be a readable format. Any format which I can open instantly. Perhaps .csv is not the best here

      • Miaka 8 iliyopita
  • Webwhizz
    Webwhizz
    • Miaka 8 iliyopita

    i can get this done, have you found a solution? or should i just send the code to you?

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      you should send the code

      • Miaka 8 iliyopita
  • ewhttp
    Mwenye Shindano
    • Miaka 8 iliyopita

    All: I have updated the details. Thanks

    • Miaka 8 iliyopita
  • arifjaunpur
    arifjaunpur
    • Miaka 8 iliyopita

    Is form already created or I have to create and How many fields in this form?

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      The form is already created. Is has 70 fields which are all numbers.

      Example of what is arriving today:
      Age 1: 50
      Age 2: 10

      • Miaka 8 iliyopita
  • kgajula
    kgajula
    • Miaka 8 iliyopita

    Hey, I can do it in 1 day, but can I use HTML & JAVA?

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      My server only supports the following:
      HTML / XHTML / CSS / JS / WAP / WML / XML
      PHP
      Perl Script
      CGI Scripts
      Phyton

      • Miaka 8 iliyopita
  • Webwhizz
    Webwhizz
    • Miaka 8 iliyopita

    That can be done soonest, all i need is for you to explain the job fully.

    • Miaka 8 iliyopita
    1. ewhttp
      Mwenye Shindano
      • Miaka 8 iliyopita

      What questions do you have? I'll be adding all the information in the brief as the questions arrived.

      • Miaka 8 iliyopita

Onyesha maoni zaidi

Jinsi ya kuanza kwa kutumia mashindano

  • Chapisha Shindano Lako

    Chapisha Shindano Lako Haraka na rahisi

  • Pokea wasilisho nyingi

    Pokea Wasilisho Nyingi Kutoka kote ulimwenguni

  • Tuza wasilisho bora zaidi

    Tuza wasilisho bora zaidi Pakua faili - Rahisi!

Tuma Shindano Sasa ama Jiunge nasi Leo!