want to update my database via email,
for exm i have 3 fields in db, 1-Id, 2-Name, 3-Marks
i wants to update this records by sending a email,
how can i update it,
artland.mehul
0
Newbie Poster
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
If you would like to update a database table by sending an email, one of the options that would appear to be appropriate is that you can actually send an email to an established email address/mailbox. Then, with a program, have it routinely log into the email mailbox and when there is an email present, retreive it, parse it, then take the infromation extracted from the message and upload it to the DB table. This can easily be done using POP3, many programming languages have libraries/built-in methods to do this.
This would require that the email itself has content in a standardized format. For example, the subject line may require some flags present or something that your program could recognized. Same goes for the content. You need your program to read through the content so it can retreive the content and know how to take that information and upload it to the proper fields.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.