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",