Email to DB help

[sassenach]

Hi,

 

I would like clients to write out a new email or reply to an email that will be sent to a specific email address in my server, then to save that email content in my MySql DB.

How do I do that?

 

Thanks

[allworknoplay]

Ummm this is kinda of a loaded question.

 

You create a table in the DB to store emails created. When they submit the email, it inserts the data to the DB,

while sending out email.

 

 

 

 

[sassenach]

I know i have to create a table in the DB.

The question is, what do I do in the cPanel in order to catch the emails sent to a specific email address, as well as storing the data using PHP to my DB?

Make sense?

[allworknoplay]

I know i have to create a table in the DB.

The question is, what do I do in the cPanel in order to catch the emails sent to a specific email address, as well as storing the data using PHP to my DB?

Make sense?

 

I'm sorry I'm  not familiar with cPanel....

[sassenach]

thanks

[Cosizzle]

cPanel is just a bunch of tools or GUI to help run and admin your site. You'll want to use phpmyadmin to build up the database and store records. Like allworknoplay said - this isnt a simple 123 step process, there are several things you must do to get all this, they're not hard but they're not as simple as click a button and saying 'Do this'

[sassenach]

i use phpmyadmin for my site, so that is not a problem for me to build tables, etc.

Cosizzle, are there any tutorials i can learn from in order to start this email to db?

thanks

[Cosizzle]

Well first off you want to break down the task.

I would like clients to write out a new email or reply to an email that will be sent to a specific email address in my server, then to save that email content in my MySql DB.

 

1. clients to write out a new email

2. sent to a specific email address in my server (in your database)

3. save that email content

 

So each step you should think of it as its own project, and build upon them, think of it as a house; You need a plan, you need frame work, you need to build then you put the finishing touches on it.

 

So you have your plan now you need to start the frame work.

1. Create a Database that

          a. Holds specific emails

          b. saves a email address and its content.

2. Create a from through html and php that will:

          a. take an email address

          b. take the message

          c. submit it

3. Configure how the submission is handled. ie. where is the email going, where is the email address being stored, where is the message stored.

 

So to start you'll want to create your tables in mysql (through phpmyadmin)

 

TABLE_1 [stored_address]

Columns: stored_email_id, email_address

 

TABLE_2[client_address]

Columns: client_id, client_email, client_message, stored_email_id