blocks|key|1231940|text|如果您的MySQL中有事务日志，则可以创建用于创建日志实例的触发器。cronjob可以监视此日志，并根据触发器创建的事件调用php脚本。那就是如果你完全无法控制你的插入。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1231941|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you have transaction logs in you MySQL, you can create a trigger for purpose of a log instance creation. A cronjob could monitor this log and based on events created by your trigger it could invoke a php script. That is if you absolutely have no control over you insertion.

blocks|key|1231955|text|我发现了这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1231956|http://forums.mysql.com/read.php?99,170973,257815#msg-257815|offset|length|1231957|DELIMITER+$$
CREATE+TRIGGER+tg1+AFTER+INSERT+ON+`test`
FOR+EACH+ROW
BEGIN
\!+echo+"php+/foo.php"+>>+/tmp/yourlog.txt
END+$$
DELIMITER+;|code-block|syntax|javascript|1231958|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1O|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|H|7|W|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|C]]]]

I found this:

<a href="http://forums.mysql.com/read.php?99,170973,257815#msg-257815" rel="nofollow noreferrer">http://forums.mysql.com/read.php?99,170973,257815#msg-257815</a>

<pre><code>DELIMITER $$
CREATE TRIGGER tg1 AFTER INSERT ON `test`
FOR EACH ROW
BEGIN
\! echo "php /foo.php" &gt;&gt; /tmp/yourlog.txt
END $$
DELIMITER ;
</code></pre>

blocks|key|1446864|text|对于长轮询的情况，我正在考虑这个问题，我不希望php脚本必须不断轮询数据库。轮询需要在某个地方进行，内存可能是最好的。因此，如果触发器可以以某种方式将信息放入类似memcache的内容中，那么php可以轮询，这将大大降低总体上的密集度。我只需要一个让mysql使用memcache的方法。可能转换为具有特定用户id的预定义变量。一旦检索到数据，php就可以重新设置var，直到数据库再次设置它。不过，对时间问题不太确定。也许是第二个变量，用来存储先前选择的键。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1446865|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I was thinking about this exact issue for a case with long polling where I didn't want the php script to have to continually poll the db. Polling would need to be done somewhere, memory would probably be best. So if somehow the trigger could put the info into something like memcache, then php could poll that would would be much less intensive overall. Just need a method for mysql to use memcache. Perhaps into a predefined variable with a specific user id. Once the data is retrieved php could reset the var until the db sets it again. Not sure about timing issues though. Perhaps a second variable to store the previous key selected.

blocks|key|1446910|text|为了从数据库获取通知，我使用websocket编写了一个命令行脚本，以每秒检查最新更新的时间戳。这在服务器上运行为一个无限循环。如果有变化，所有连接的客户端都会收到通知。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1446911|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In order to get a notification from the database I wrote a command line script using websocket to check for the latest updated timestamp every second. This ran as an infinite loop on the server. If there is a change all connected clients will can be sent a notification.

blocks|key|1446969|text|cronjob可以监视此日志，并根据触发器创建的事件调用php脚本。也就是说，如果你完全无法控制你的插入..如果您的MySQL中有事务日志，则可以创建用于创建日志实例的触发器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1446970|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

A cronjob could monitor this log and based on events created by your trigger it could invoke a php script. That is if you absolutely have no control over you insertion.. If you have transaction logs in you MySQL, you can create a trigger for purpose of a log instance creation.

blocks|key|1447050|text|我不知道这是否可能，但我总是想象自己能够用MySQL中的CSV存储引擎做到这一点。我不知道这个引擎的细节：http://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html，但是你可以查看一下，在你的操作系统中有一个文件监视器，如果文件被修改了，它就会触发一个PHP调用。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1447051|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html^0|1H|1Q|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I don't know if it's possible but I always pictured myself being able to do this with the CSV storage engine in MySQL. I don't know the details of this engine: 
<a href="http://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html</a> but you can look into it and have a file watcher in your operating system that triggers a PHP call if the file is modified.

blocks|key|1232232|text|尽可能远离存储过程。它们很难维护，而且是非常陈旧的东西;)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1232233|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Run away from store procedures as much as possible. They are pretty hard to maintain and are VERY OLD STUFF ;)

Is there any way how to invoke a PHP page / function when a record is inserted to a MySQL database table? We don't have control over the record insertion procedure. Is there a trigger mechanism which can call a PHP script back?

Invoking a PHP script from a MySQL trigger

SQL数据库

数据库

服务器

MySQL

有没有办法在向MySQL数据库表中插入记录时调用PHP页面/函数？我们无法控制记录插入过程。有没有可以回调PHP脚本的触发器机制？

问从MySQL触发器调用PHP脚本
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从MySQL触发器调用PHP脚本EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问从MySQL触发器调用PHP脚本
EN