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!

技能: PHP

查看更多: 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

项目ID: #12157593

已悬赏给:

akkastech

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 更多

$25 USD 在1天内
(6条评论)
3.1

15名威客为此工作的平均竞标价是$45

diastark

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 更多

$60USD 在1天里
(148条评论)
6.4
swsinfotech

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. 更多

$103USD 在1天里
(46条评论)
5.4
techcristaglobal

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 reelme.co which is best application i have made. my clients are so hap 更多

$50USD 在1天里
(16条评论)
4.7
phpfreelancer86

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 更多

$30USD 在1天里
(41条评论)
4.8
angeledugo

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 更多

$30 USD 在2天内
(13条评论)
4.5
cloneify

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 1www.artistprovider.com 2 www.viratpost.co. 3 http://www.palminnhotel 更多

$45 USD 在2天内
(24条评论)
4.6
$61USD 在1天里
(20条评论)
4.6
avi2105

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, 更多

$30USD 在1天里
(22条评论)
4.1
itsea

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

$25USD 在1天里
(22条评论)
3.6
rlo56467a9097547

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 在0天内
(16条评论)
3.8
pankaj91

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: http://projects.webaccentors.com/assist247/home.p 更多

$100 USD 在3天内
(25条评论)
3.9
$30USD 在1天里
(11条评论)
3.2
lchabana

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.

$30USD 在1天里
(0条评论)
0.0
vanushpetrosyan8

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 更多

$25USD 在1天里
(0条评论)
0.0
$25USD 在1天里
(1条评论)
0.0