monitor mysql table, execute php script


random_min = 3

random_max =10

Monitor table zoxyl.device_status

mysql> select ip,port,imsi,st from device_status;


| ip | port | imsi | st |


| [login to view URL] | 5A | 611050110505312 | Registered |

| [login to view URL] | 3A | 611050110505309 | Registered |

| [login to view URL] | 2A | 611050110006368 | Registered |

field to monitor is st

if st changes from anything to Registered

find its balance query by

select balance from general,device_status where prefix=left(imsi,7);


php /var/www/html/gateway/[login to view URL] --ussd --ns --gw [ip] --ports [port number] --ussd-code ['balance']

But this should not be executed everything. it should randomly execute every 3 to 10 times conditons are found. 3-10 are defined on top of script

Taidot: MySQL, Perl, Python, Shell Script, tietojärjestelmäarkkitehtuuri

Näytä lisää: php script pull html data, php script excel html, php script parse html xml, php mysql trigger after insert, execute php from mysql, mysql trigger send email php, mysql stored procedure call php script, how to execute trigger in php, execute php script from mysql trigger, mysql run php, how to run a php script in mysql, mysql table viewer php, php script word html, execute php script automatically, php script write html file, free php script text html script, export mysql table pdf php, php script output html file, php script clean html, php script xls html web server

Tietoa työnantajasta:
( 105 arvostelua ) dix hills, United States

Projektin tunnus: #17651561

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Dear Hiring Manager, We can help you in the project to create a script from random things and perform operation from mysql database.. I am good in: php, codeigniter, laravel, jquery, google map api, MySQL. Let Lisää

$35 USD 1 päivässä
(49 arvostelua)

I'm available today to do this task. I'm interested to do this task. Let me know if You are interested or not

$30 USD 1 päivässä
(32 arvostelua)

Interesting script. Can we talk? Thanks

$30 USD 1 päivässä
(14 arvostelua)

Dear Client, We are expertise in php, core php, CMS, HTML5, CSS3, bootstrap, WordPress, OpenCart, Magento, PSD to HTML, Angular JS, Node JS photoshop, OPencart, Codeignitor, Laravel and many other technologies. We have Lisää

$50 USD 1 päivässä
(51 arvostelua)

Hey There, Only PHP script? I can write it based on Bash, you can run it just like PHP command. We can run it with Linux cronjob. For more information, let's discuss over chat. Regards, Daniel

$30 USD 1 päivässä
(3 arvostelua)
$34 USD 3 päivässä
(1 arvostelu)

Hello, I have gone through your details. I am Full time developer also have 11+ years experience on PHP, WORDPRESS, MYSQL, JAVASCRIPT, JQUERY, CSS, HTML5. I will provide you clean, modular, robust code to implement Lisää

$40 USD 1 päivässä
(4 arvostelua)

Je suis un étudiant néanmoins j'ai de fortes connaissances en base de données. Je me vois le plus idéal pour votre projet d'après mes connaissances théorique et pratique dans le domaine.

$25 USD 10 päivässä
(0 arvostelua)

Dear Employer, I have 2 + years experience in MySQL PHP technology. I would like to complete your project. Please provide me with more information about the deadlines, if you are interested Thanks and Regards, F Lisää

$25 USD 1 päivässä
(0 arvostelua)
$30 USD 1 päivässä
(0 arvostelua)

Apachi solutions (PVT) Ltd is an IT based solution provider company work from last 15 years. Our offices are located in U.k , U.S.A, Dubai, and Pakistan. We have strong portfolio and having big name in market. we provi Lisää

$35 USD 1 päivässä
(0 arvostelua)

Hi Sir, I can deliver this project successfully.I think I’m a great fit for this project because I have an interest in project and can deliver on time, according to your specifications. I have 8+ years of work expe Lisää

$30 USD 1 päivässä
(0 arvostelua)

Today's organizations are increasingly dependent on Information Technology (IT) for achieving their business goals. Many organizations rely on IT to help them compete in new ways. Organizations need workers who are com Lisää

$25 USD 1 päivässä
(0 arvostelua)