数据库更改时启动PHP文件？

Question

I have a database that has 20 rows each row I had set a Boolean value to it, so it is by default zero and when a row gets viewed its value changes to 1

I want the database to send any kind of signal that when 10 rows their value change from zero to 1, a certain PHP file fires up and starts a process that will affect only these 10 rows
How can I do that?

Thanks in advance

Answer 1

I would say, query from the php file every set amount of time to your database

The other way, database to execute a php file is almost impossible.

If you are using mySQL as database, a trigger could invoke the sys_exec() UDF available here: https://github.com/mysqludf/lib_mysqludf_sys#readme

So, there might be a possibility, actually, via an UDF function that would launch the php executable/script; not that easy, but seems possible ;-)