Axeia Posted July 12, 2009 Share Posted July 12, 2009 Okay, I know the normal query stuff quite well.. but this is a bit above my current level of knowledge. Is it possible to create a trigger on a table that watches for deletes/inserts/updates on a table and when one occurs send a curl request? This would be used to create a 'one account' system for 2 sites on separate servers. Preferably this would be done on a mysql database, but one of the 2 sites does use postgresql.. it just doesn't have PHP installed which would make things rather complicated. Quote Link to comment https://forums.phpfreaks.com/topic/165732-set-trigger-to-send-a-curl-request/ Share on other sites More sharing options...
celsoendo Posted July 14, 2009 Share Posted July 14, 2009 hmmm... I think this is not possible with pure mysql. But there is a workaround to do this... See: http://www.php-trivandrum.org/code-snippets/invoke-shell-from-mysql-trigger.html Quote Link to comment https://forums.phpfreaks.com/topic/165732-set-trigger-to-send-a-curl-request/#findComment-874959 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.