Web form using php to import into Access db

[carlmty]

Hi everyone:

I need to make a web form in php, that sends me the results by mail, ok, that is the easy part, I know how to do it, the thing I don't know, is that I need that the results get formated to import them into Access, as a delimited text with | delimiter.

I already have the web form, but the results that send by mail are not formatted to import them into Access, here is an example what I need, to ilustrate my question better:

Web form: (What the user see and must fill)

Name: John
Last name: Doe
Sec last name: Doyle
Gender: 0 (Where 0 is Male and 1 is Female)
Marital status: 1 (Where 0 is Single, 1 is Married, 2 is divorced, etc)

This is what I get by mail, instead of that, what I need to have is this:

(Table definitions for Access)

name|last|sec|gender|marital

But with the user info in it, like this:
John|Doe|Doyle|0|1

And once I have this message in my mail, I can copy, paste it in text, save it into one file, and then, go to Access and import the file.

Also, because is a convention of the application made it by Access (I didn't develop that application) I need to include the * asterisk at the beginning and end of web form, just to keep things in order, and not mixup them.

The questions are:
1.- How can I convert or transform automatically the mail message to have it ready when arrives to my mail, in order just to copy, paste and import into Access?

2.- How can I include the * asterisk at the beginning and the end of each web form is send by users?

Thanks in advance.

[daphreeek]

I assume you have access to the mailing php script. if not - make one 🙂

just open it and find the bit that makes the message (it will look kinda like what the e-mail you get at the moment looks like) and change it to something like this:

$message_body = "*$name|$last|$sec|$gender|$marital*";

that is assuming those are the correct variable names - if not, its simple to change them 🙂

• matt

[carlmty]

Hi matt

Thanks for your answer, but I'm a completely newbie in php, and I don't have or don't know how to make the mailing script 😕

I do understand how to change things in php scripts, but don't know how to make a brand new one from scratch.

So please, tell me where can I find this mailing.php script, because I already check in php section in hotscripts.com, and found just mailing lists manager, also I already did a Search in this forums and couldn't find anything about it.

Thanks again

[daphreeek]

Set the names of the input boxes to name, last, sec, gender, and marital. Then set the action of the form to mailme.php

Now make a new text file called mailme.php and put the following in it:

<?php
if (("[e-mail]", "New Database Info", "*$name|$last|$sec|$gender|$marital*"))
   echo "The e-mail has been sent!";
else
   echo "There was an error sending your e-mail!";
?>

That should do the trick 🙂

• matt

[carlmty]

Hi again Matt:

I did the things as you told me, and it sends me a parse error:

Parse error: parse error in /home/resource/public_html/mailme.php on line 2

I suppose this is because I need some function to send mails within the php script.

So, now I'm searching for a good send mail php script, in order to integrate it in the mailme.php file.

Any suggestions of a good mailer script, suitable to easy integrate with the piece of code you send me, would be very appreciate it.

When I find it, I will need your help, if it's not to much to ask 🙂 , to integrate or call it from the mailme.php script.

Thanks again

[daphreeek]

oops - sorry. my mistake - i missed the mail command 🙂

try this:

<?php 
if (mail("[e-mail]", "New Database Info", "*$name|$last|$sec|$gender|$marital*")) 
   echo "The e-mail has been sent!"; 
else 
   echo "There was an error sending your e-mail!"; 
?> 

sorry bout that 🙂

• matt

[carlmty]

Thanks Matt, now is working like charm 😉