Simple PHP mailer script from mysqli DB and update.

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!

Habilidades: PHP

Ver más: update status script php, simple update script php, update script php simple, php mysql simple update script, update file script php, save current date time mysql php, php script current date time, software write mq4, software write chip epson, useful software write book, bash script current date time, software write web specs, script php mailer inbox 2009, free software write user guide, software write edid, free software write company profile, software write websites idea, adobe pro current date time script, software write book images, software write books, software write protection, free software write book, software write book, linux shell script current date time, update database script php

Información del empleador:
( 1 comentario ) Midrand, South Africa

ID de proyecto: #12157593

Adjudicado a:


Hey there! Welcome to Akkas Technologies! Hope you are doing well. This is Awais, I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. Why do I say that? I Más

$25 USD en 1 día
(31 comentarios)

14 freelancers están ofertando el promedio de $46 para este trabajo


Hello Sir/Mam, We have good experience of PHP,JOOMLA,HTML,HTML5,CSS,Ajax,jquesry,JavaScript,Mysql,Graphic Design,Website Design, Android,mobile application,Photoshop, Banner Design ,Flayer mail,Logo Design,wordpress,M Más

$60 USD en 1 día
(169 comentarios)

Hello Sir, I've reviewed your requirement and I'm ready to work with you. I will provide quality work as well full support for any query. I'm giving you trust for good quality work. I have almost 7+ years of expe Más

$30 USD en 1 día
(119 comentarios)

Hi, I am expert Website designer. I have read your Project design requirement and interested to work on your project. I want to know more details about your project. I am ready to start work on your project quickly. Más

$103 USD en 1 día
(50 comentarios)

Hello sir, I have more than 5+ Year of experience in android and PHP. i have done many fantastic application in android. One of my best till now is [url removed, login to view] which is best application i have made. my clients are so hap Más

$50 USD en 1 día
(28 comentarios)

Hi, Hope you doing good? I am experienced PHP developer having expertise in e-commerce domain using Zen Cart, Wordpress, Codeigniter, OsCommerce, CreLoaded, MVC framework, Prestashop, Opencart, HTML5, Bootstrap, Más

$30 USD en 1 día
(50 comentarios)

Hi, i am full time freelancer , not company or agency. please let me know if you are interested to work with me i would like to do that mail functionality work for you. thanks sagar

$25 USD en 1 día
(49 comentarios)

Hi, I'm Ing of systems With over 10 years of experience developing large-scale applications and providing web technology solutions for freelancers , small, medium and large businesses. experience working with the pr Más

$30 USD en 2 días
(25 comentarios)

Hi, how are you If you are interested I can help with this project and I can do right now If you agree send me a message Thanks for your time

$66 USD en 0 días
(35 comentarios)

I am a experience developer who have worked on many projects Like below mentioned websites Love to discusses it with you Few of my projects [url removed, login to view] 2 3 [url removed, login to view] Más

$45 USD en 2 días
(25 comentarios)

Hello, We are interested to work with you, as we have expertise in Responsive Web Design, WordPress Plugin Development and Customization. Recent HTML/SCSS work: [url removed, login to view] Más

$100 USD en 3 días
(31 comentarios)
$30 USD en 1 día
(13 comentarios)

I suppose this Is a job that can be completed pretty quickly. Allow me to come to your aid and assist you with getting this right. Let me know.

$30 USD en 1 día
(1 comentario)

Greetings to my dear Job Poster I'm a php( laravel, codeigniter, yii) developer with most of works are on Wordpress, Magento and Laravel. For evaluating my jobs and ensuring that I am the expert that you were looki Más

$25 USD en 1 día
(1 comentario)