Can mysql triggers call php functions? can mysql triggers or stored procedures call php functions.
Write
I have a function. after a user sends a message insert in aap, I want to send an email reply using the trigger.
Because our website data sources include app and webpage reply emails on webpage
Reply to discussion (solution)
Mysql? Php method ?? No,
Depends on your needs ,???? In php, in php? Usage ratio? Okay.
MySQL is not allowed.
Sqlite can
This is the most stupid method to add a scheduled plan to scan table data and then send emails.
This can be implemented using PHP. isn't it possible for you to directly insert a database without bypassing PHP? it is not implemented in PHP code yet, so PHP can determine whether the insert is successful and then send an email.
Using mysql to call the php script is not very realistic. sending emails can also be implemented in your code. why do you want to implement it in the database.
I think I can write a php page with a long timeout, and then access this page with the built-in mysql trigger.
Because the data is inserted in the APP, the jsp development mail is used to send the data in php.