Færdiggjort

Send SMS to multiple receivers

Knowledge :MariaDb 5 ,Javascript,Php,linux Centos

This is a first step of something must be integrating.

Starting from a table with cellular's receivers (ABBONATI table), through a web interface, generate 2 file ascci to send via FTP.

All components must be available in your system for executing test; I'll give you only ftp destination folder.

These are the two main tables with the main fields in DB

Table's name : ABBONATI

id (sequence),

to_num Char(25)

from_num Char(25),

PV Number(10,0)

email

StartDate date default Now,

Enddate date ,

NTX Number ,

NRIC Number

id to_num from_num PV email StartDate endate NTX NRIC

1 011111111111 12121212212 12 www@ddd 12/12/12 12 23

2 0222222222222 15151515151 15 2222@ddd 13/12/12 2 3

3 0333333333333 12121212212 12 232@sdsdsd 14/12/12 2 3

Table's name : SPEDIZIONI

id (sequence),

to_num Char(25)

from_num Char(25),

body Char(160),

expire Char (10) default '0000000048',

quality Char(2) default 'h ',

sent YYYYMMDDHHMMSS,

PV Number(10,0) default 9999999999,

FlagSpedito 1/0

id to_num from_num body expire quality Sent PV Falgspedito

1 011111111111 12121212212 Messaggi 1 0000000048 h 2016050512123456 12 1

2 0222222222222 15151515151 Messaggi 1 0000000048 h 2016050512123456 15 1

3 0333333333333 12121212212 Messaggi 1 0000000048 h 2016050512123456 12 1

5 011111111111 12121212212 Messaggi 1 0000000048 h 12 0

6 0222222222222 15151515151 Messaggi 1 0000000048 h 15 0

7 0333333333333 12121212212 Messaggi 1 0000000048 h 12 0

Step

1 login

2 User in a web's interface insert a message (max 160 GSM Characters), choosing receivers from ABBONATI

3 After the choice , some records are append to SPEDIZIONI with Flagspedito=0 and Send=Null

4 Using MySQL UDF sys_exec , the trigger after insert on SPEDIZIONI, creates 2 ascii file with the same name and different extension YYYYMMDDHHMMSS name 20190624232266.txt-20190624232266.txt.do_send,

5 These file are send to ftp folder

6 At the end of delivery the the flag=1 and sent=20190624232266 ( time of create file)

Note

Step 1 : create a secure login using php and mysql

Step3. : the 2 files must be fixed record = "%-25s%-25s%-160s%010d%-2s\n",

Evner: Apache, Javascript, Linux, MySQL, PHP

Se mere: send sms email address, send sms mms web site, smpp client tool send sms, send sms addcreditsphp, script send sms message, send sms mms message, send sms multiple recipients j2me, iphone cocoa objective send sms message, send sms text message server, j2me code send sms text message, java send sms message, send free multiple advertis sms, send sms message j2me source code, send sms message make number, send sms message mobile device bank program, send sms multiple numbers php, send sms message via python google app, access send sms message, net send sms message, send sms multiple numbers using

Om arbejdsgiveren:
( 3 bedømmelser ) Sesto San Giovanni, Italy

Projekt ID: #20071365

Tildelt til:

workandlive123

Hello, After reading this job description, I am convinced that I would be a perfect fit for this role. That is because of - I have good experience in SMS. - I am a PHP expert who has 12 years of experience with larave Flere

€30 EUR in 7 dage
(53 bedømmelser)
5.4
bluebear1888

How do you do? I am a creditist. I'm very happy to have a chance of bidding your project. I have read carefully the descriptions and understood clearly what you want. I have experience in development of the project Flere

€155 EUR in 3 dage
(28 bedømmelser)
4.8

13 freelancere byder i gennemsnit €153 på dette job

shaktistanwar

Hi, I have gone through the job description and I already worked the SMS sender project. Please have a look at my profile and come on chat so we can discuss it in detail. Do you have already SMS API? Do you want Flere

€294 EUR in 3 dage
(37 bedømmelser)
6.9
moderninfotech

Hi, We are having team of skillful and talented developers and designers in all the aspects and requirements regarding the project and also gone through the details and understand what exactly you want. I'm onl Flere

€177 EUR in 3 dage
(151 bedømmelser)
7.0
flance9

Hi there, Thank you for sharing your requirement. Hope you are doing good and having a nice day. We are a team of technocrats having 8+ years of experience in Web and Mobile design plus development and primarily deal Flere

€140 EUR in 7 dage
(28 bedømmelser)
6.6
ineedWorkJob

Greetings sir, I have read your project details and i will develop a script to send sms to multiple receivers. Sir, i can deliver this project sooner than you expect and will be over your satisfaction level. P Flere

€100 EUR på 1 dag
(131 bedømmelser)
6.7
stead121

Hello, Glad to meet you I have strong experience and skill in sending bulk sms using API. I will use PHP Curl to implement your requirements. After reviewing your project description carefully, I am confident to com Flere

€120 EUR in 5 dage
(45 bedømmelser)
6.0
alkajain2906

Hi, I have 5+years Experience in Website/Software Design & Website Development. I'm an Expert in: -Frontend & Backend Development -Python -Data Science -Machine Learning -JVM technologies -Jquery, PHP -Ion Flere

€155 EUR in 3 dage
(37 bedømmelser)
5.4
xiaomingming

Hello dear. I have read all description and very interested in this project. I m a senior web developer working for 6+ years and my skills and experiences are perfectly fitted on this project. It is my pleasure to wo Flere

€250 EUR in 7 dage
(4 bedømmelser)
5.4
ankitbagre2000

HELLO EMPLOYER I AM ANKIT , I already have read your description carefully. I have 3 plus years alot of experience in PHP ETC. My major skill are HTML I am reliable freelancer you want. Now I am free, I w Flere

€130 EUR in 3 dage
(35 bedømmelser)
4.9
albertpopov46

Hi Dear I read your requirements carefully. I have rich experience with Website development. I have developed Website and Web application projects for 7+ years. I also provide neat Website design. My skills are PHP, Flere

€140 EUR in 4 dage
(12 bedømmelser)
4.3
sharktiger

Hello! How are you? I've read carefully your job description. I have more than five years experience in Javascript, Linux, MySQL, PHP. Your satisfaction with the project is my top priority! If you give me a c Flere

€155 EUR in 3 dage
(15 bedømmelser)
4.3
y2ksw

Possiamo per favore discutere di questo progetto in chat o viva voce? Capisco che vuole mandare via dei SMS, ma non come ... io ho un servizio di invio SMS sia nazionale che internazionale, ma ci sono dei limiti dei qu Flere

€140 EUR in 7 dage
(0 bedømmelser)
0.0