Send Sms using nexmo with queries from mysql - to be called by cron

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Twilio Sms from CDR - To be called by cron

Db asterisk user root no pass

Table cdr

select right(src,11),right(dst,7) from cdr where calldate > date_sub(now(),interval 1 hour) and (src like '1%' or src like '+1%') and (CHAR_LENGTH(src) = 11 or CHAR_LENGTH(src) = 12);

Send SMS to right(src,11)

Thanks for calling right(dst,7) .

More deals at [login to view URL]

select right(src,12),right(dst,7) from cdr where calldate > date_sub(now(),interval 1 hour) and (src like '33%' or src like '+33%') and (CHAR_LENGTH(src) = 11 or CHAR_LENGTH(src) = 12);

Send sms to select right(src,12)

Merci d'avoir appelé à RIGHT(dst, 7).

Plus d'offres sur [login to view URL]

Keep a database of the sms that have been sent

Dont send to same number more than 1 time per 30 days

Bash Scripting MySQL Perl PHP VoIP

Project ID: #17235988

About the project

16 proposals Remote project Active 5 years ago

Awarded to:

ast3r1sk

Hello dear sir, i can create such cron script for sending sms. I do with similar tsk before. Please contact me if you interested in .Thanks.

$100 USD in 3 days
(42 Reviews)
5.4

16 freelancers are bidding on average $163 for this job

keshavkalra90

Hello i hope you are doing great i will make your cron job with limitations too like if we sent some messages to one no it shouldn't sent again if time is no more than 30 days Let's connect i do know Twilio API' More

$135 USD in 3 days
(222 Reviews)
7.6
abugosia

Hello, I'm Abu Gosia. I'm interesting your project very well I'm good in Website Design, PHP, Laravel, Codeigneter, Wordpress, C#, .Net, MVC, Angular.js, ASP.NET expert. I m quite well experienced in these jobs. Le More

$222 USD in 7 days
(277 Reviews)
7.1
MyAwesomeTeam

Hello vjfromgt. .I have the ability to do it I have idea and solution for your project. also i have experience skills : MySQL,PHP, Bash Scripting, VoIP. I always: -Do project fast More

$165 USD in 3 days
(94 Reviews)
6.7
freelance4hire80

Hi I can come out a Perl script for you. ______________________________________________________________________

$200 USD in 3 days
(71 Reviews)
6.9
mamoona016

Hi i am ready to start work on YOUR Send Sms using nexmo with queries from mysql - to be called by cron. I will provide you 100% quality work and satisfied result. Moreover you don't have to pay anything in advance , More

$155 USD in 3 days
(74 Reviews)
6.6
arodrigue

I have done similar task before, of sending SMS from a DB running the script in a cron job, contact me and let discuss about it

$166 USD in 3 days
(106 Reviews)
6.5
SuperWeb94

Hello sir i have worked with Twilio SMS api before and i can build you a php script that will manage the database for sending sms using cron

$150 USD in 3 days
(60 Reviews)
5.5
khyatitankariya

Hi, I have read your description and i think your sms script is working fine. And i just need to work with you to stop sending mails to the same email address per month. So basically concept is to send each email ad More

$111 USD in 2 days
(19 Reviews)
5.5
ludiac

Hi there, We've reviewed your project description and we can send SMS using Nexmo. We've extensive experience in twilio and have recently worked on Nexmo as well. See our profile for project details. We can also sha More

$250 USD in 3 days
(20 Reviews)
5.8
Yonasi

Hi, We have in-house teams of creative designers and experienced developers working in Java, C++ and Php and React JS. We have built products such as an Electronic Medical Record software (EMR) for US based medical pr More

$30 USD in 1 day
(11 Reviews)
3.9
manjutactys

I have gone through your job post and I am quite confident that I can handle your task very well. I have prior experience with website CRON job. please share your best discussion time to move further.

$277 USD in 3 days
(4 Reviews)
3.8
stefanmahrcom

Hello! I worked many times before with nexmo and so I think I am the right person for your Project. Maybe you have further questions, so just contact me. Best greetings Stefan

$100 USD in 3 days
(2 Reviews)
1.1