已完成

Simple PHP mailer script from mysqli DB and update.

该项目成功由akkastech ,以 $25 USD的价钱在 天内完成。

为像这样的项目获取免费报价
雇主工作
项目预算
$10 - $30 USD
完成于
1 天
全部竞标
16
项目描述

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!

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online