Simple PHP mailer script from mysqli DB and update.
该项目成功由akkastech ，以 $25 USD的价钱在 天内完成。为像这样的项目获取免费报价
项目预算$10 - $30 USD
Hi, have a simple DB with columns id,cell, msg, sent. Db name is osticket, table name is ost_sms_msg (so you code directly in, I will do user and password etc)
I would like a simple php script that selects all rows that are Null in the sent column.(could be more than one) It must send an email for each row with variables for cell as the subject field and msg as the body of the mail. The email address sent to will be fixed.
It must update the sent column with a DateTime stamp of the current date/time once that email is sent. Therefore it is 1 mail per row sent, each with its own subject and body as per the row in DB.
The purpose is to send to a mailTOsms server. Will be run a cron job.
Obviously if no rows returned, then no email.
PHP version is 5.
I will only pay balance once i have the raw code and it works!
This is urgent, however i have a fair amount of Sql skill, a little PHP.. no chancers please!
- The New York Times
- Wall Street Journal
- Times Online