February 27, 2018
Hello, so in my project i will send command hcitool data scheduled every hour everyday depends on the schedule in MySQL table.
Example: Monday 10.00 - 13.00
Wednesday 15.00 - 17.00
Then my raspi will do hcitool command to capture bluetooth MAC address around it at monday 10, 12, 13 and wednesday 15, 16, 17.
The question is, do anyone know how to trigger it from MySQL?
January 29, 2014
Where is the MySQL table located? Is MySQL running on your raspi or somewhere else?
If its running on the raspi then one solution is a cron job that runs every hour. This triggers a script that compares the current time to the list stored in the database and takes action when they match.
What is the structure of your table? How are you going to represent the range of time and days?
Most Users Ever Online: 166
Currently Browsing this Page:
Guest Posters: 1
Newest Members:Advantagetreeexperts, laundrydaddyuk, techhhelp5, ken, tran, huldacormier
Moderators: cstapels: 460
Administrators: Hans: 405, lee: 457