Menu
Community /Pin to ProfileBookmark
@NogDogApr 27.2011 — #In normal use, PHP web apps are "pull only", you cannot push data to the browser from your PHP script on the server unless the browser has asked for it via a HTTP request. This is one reason that most chat applications use something like a Flash or Java applet on the client side that can "listen" for data from the chat server. Therefore, I suspect (but don't claim to know for sure) that if you want to do what you are describing, you'll either need to use some sort of applet on the client side and possibly some sort of socket programming on the PHP side (?), or else bite the bullet and go with the JavaScript periodic HTTP request technique. But like I said, I'm by no means 100% sure about this.
As far as MySQL triggers, a bit of Googling would seem to suggest that you cannot directly call an external script from a trigger. It seems the most common approach is to have the trigger use the SQL "INTO OUTFILE" command to write pertinent data to a file on the server, then have a cron job (or a daemon process) look for such a file and if found process it through whatever script (including acommand line PHP script ) you want.
PHP Chat with no SetInterval function
Basically i want to know if there is a way to send data from server to client when on server something happens (for example mysql insertion)..
The script must run to all sessions.
I don’t want to call a javascript function every X min to check if data has changed.
Another one question:I want to write a mysql trigger to run a php script.How i will do that?
Thanks in advance!!
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogApr 27.2011 — #In normal use, PHP web apps are "pull only", you cannot push data to the browser from your PHP script on the server unless the browser has asked for it via a HTTP request. This is one reason that most chat applications use something like a Flash or Java applet on the client side that can "listen" for data from the chat server. Therefore, I suspect (but don't claim to know for sure) that if you want to do what you are describing, you'll either need to use some sort of applet on the client side and possibly some sort of socket programming on the PHP side (?), or else bite the bullet and go with the JavaScript periodic HTTP request technique. But like I said, I'm by no means 100% sure about this.As far as MySQL triggers, a bit of Googling would seem to suggest that you cannot directly call an external script from a trigger. It seems the most common approach is to have the trigger use the SQL "INTO OUTFILE" command to write pertinent data to a file on the server, then have a cron job (or a daemon process) look for such a file and if found process it through whatever script (including a