Invoking a PHP script from a MySQL trigger

by

The trigger is executed on the MySQL server, not on the PHP one (even if those are both on the same machine).

So, I would say this is not quite possible — at least not simply.

Still, considering this entry from the MySQL FAQ on Triggers :

23.5.11: Can triggers call an external application through a UDF?

Yes. For example, a trigger could
invoke the sys_exec() UDF available here:
https://github.com/mysqludf/lib_mysqludf_sys#readme

So, there might be a way via an UDF function that would launch the php executable/script. Not that easy, but seems possible. 😉

More Related Contents:

  1. Create mysql trigger via PHP?
  2. Php mysql tabs don’t output [closed]
  3. Update Mysql except when field not null
  4. How can I prevent SQL injection in PHP?
  5. UTF-8 all the way through
  6. SQL injection that gets around mysql_real_escape_string()
  7. Can I mix MySQL APIs in PHP?
  8. jQuery Validate remote method usage to check if username already exists
  9. Pagination using MySQL LIMIT, OFFSET
  10. How to call a MySQL stored procedure from within PHP code?
  11. Best way to check if mysql_query returned any results?
  12. mysql_fetch_array return only one row
  13. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  14. Insert multiple rows with PDO prepared statements
  15. a better approach than storing mysql password in plain text in config file?
  16. mysql query result in php variable
  17. mysql_real_escape_string is undefined
  18. Unknown database error in PHP but it exists in PHPMyAdmin
  19. Can I blindly replace all mysql_ functions with mysqli_?
  20. How do detect that transaction has already been started?
  21. return multiple response data in one response
  22. CakePHP Database connection “Mysql” is missing, or could not be created
  23. MySQL Alter Table Add Field Before or After a field already present
  24. mysql error ‘TYPE=MyISAM’
  25. Storing datetime as UTC in PHP/MySQL
  26. Auto Increment skipping numbers?
  27. PDO bindParam into one statement?
  28. Is mysql_real_escape_string enough to Anti SQL Injection?
  29. How to make mysqli connect function?
  30. Using PHP to upload file and add the path to MySQL database

Leave a Comment