944,126 Members | Top Members by Rank

Community Center > IT Professionals' Lounge > web based database question
Ad:
Permalink
Aug 30th, 2007
0

web based database question

Expand Post »
Hi,

I am a student on my year work placement and I have been asked to develop a web based database for a company. I think my design is ok but I am a bit confused in a part...

The company wish to save emails in the database to and from customers, is this possible or how would i go about doing this? I have read quite a lot but i can't find anything that is what i need. It is not that the emails will hold information for an order specifically, there will not ba a email form or template, just generally saving the messages and dates etc. so other members of staff know what has been said to the customer etc.

Any ideas would be greatly appreciated!

Thanks
Similar Threads
GLT
Reputation Points: 18
Solved Threads: 0
Junior Poster in Training
GLT is offline Offline
98 posts
since Aug 2007
Permalink
Sep 27th, 2011
-1
Re: web based database question
softwares to be used include wampserver,dreamweaver,fireworks
Reputation Points: 10
Solved Threads: 0
Newbie Poster
edwards1 is offline Offline
1 posts
since Sep 2011
Permalink
Sep 27th, 2011
0
Re: web based database question
You can just create a webpage(more like a suggestion or complaint box) with maybe four text-boxes. That would include one for the customers name, the other for an email(when a reply is to be sent), the third for subject, and the fourth for comments.

When this is done, you can create a table where contents of these four text-boxes are saved in the database. It should not give you much problems saving the message because its the same INSERT statement since all you want to do is just to save the messages

Hope you have a great stay at your workplace
Goodluck!
Reputation Points: 43
Solved Threads: 67
Veteran Poster
Netcode is offline Offline
1,016 posts
since Jun 2009
Permalink
Oct 14th, 2011
0
Re: web based database question
As per the previous suggestion, you could provide a form where the information can be pasted and saved to the DB. This makes some sense if the process is selective and the volume isn't too high. It is also possible to read from a mailbox directly and then save the data without any human intervention. In that case you could store it under the email ID and that would be the link back to the customer.
Reputation Points: 210
Solved Threads: 228
Nearly a Posting Virtuoso
chrishea is offline Offline
1,389 posts
since Sep 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in IT Professionals' Lounge Forum Timeline: I got my new server today
Next Thread in IT Professionals' Lounge Forum Timeline: PHP, JSP, ASP.NET Which one best for web development ?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC