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

Nº del 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
(35 comentarios)

13 freelancers están ofertando el promedio de $48 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 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 [login to view URL] which is best application i have made. my clients are so hap Más

$50 USD en 1 día
(30 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)

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
(57 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
(51 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)

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 [login to view URL] 2 3 [login to view URL] Más

$45 USD en 2 días
(26 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
(38 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: [login to view URL] 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)