Simple PHP mailer script from mysqli DB and update.

Este proyecto fue completado exitosamente por akkastech por $25 USD en un día.

Obtén cotizaciones gratis para un proyecto como este
Presupuesto de Proyecto
$10 - $30 USD
Completado En
1 día
Ofertas Totales
Descripción del Proyecto

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!

Completado por:
Habilidades Requeridas

Buscando hacer algo de dinero?

  • Establece tu presupuesto y período de tiempo
  • Describe tu propuesta
  • Consigue pago por tu trabajo

Contrata Freelancers que también oferten en este proyecto

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