Hello,
I need a script written in php made from scratch. Must have WAP, MySQL, and PHP experience.
The script will be designed so that a cell phone user can send an email from their phone to an email account and returns a picture that is stored in a mysql database back to the cell phone.
It will work like this:
-----email sent from cell phone with the keyword “dallas” in the body of the email.
-----email received by server.
-----script loops through the email acct every minute or two looking for new mail messages.
-----script finds the new email with the keyword “dallas”.
-----program records the incoming email address from the phone. i.e. [login to view URL]
-----script reads through the email and finds the keyword “dallas” and matches “dallas” with the dallas mysql querey. For example “select pic from dallas order by date, time limit 1”
-----script runs the query and finds the latest picture in the table “dallas”
-----script recalls the cell phone's email address and sends an email back to the cell phone's address with the dallas picture.
*There are about 20 tables right now, so about 20 different queries. All the queries look the same, but instead of “dallas” it might search for a different city. For example: “Houston” “select pic from Houston order by date, time limit 1”
Please include the keyword ***moblog*** in your response so I know your reply wasn't automated.
Must avoid using 3rd party software if possible.
Using moblog software found at [login to view URL]
If you know of a better way to do this, feel free to suggest.