MySQL+ execute external commands when certain events, perhaps?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
3 views
In short there is a commercial PHP script in the code which intrude not(zend), but you need to add a small functionality. Here the idea arose to write a script( in Python for example) that adds the desired functionality and run it when the main script enters the data in the database. Therefore, the question arose whether it is possible in mysql to put a command on insert/update in specific table, ideally with the transfer of certain values of the added data as parameters to the script?

In the database record will be added with a specific description of the content in the folders of FS and link to these folders, the script has to create a report file based on the folder content and save it in the root of this folder.

Well the extra question about how far such a revision might cost?
by | 3 views

3 Answers

0 like 0 dislike
as mentioned above, it is possible to cover up the table you are interested in triggers, to collect with their help needed to script data and populate a separate table, a kind of "scheduler" for the external script that the cron will pick up the job and generate the required reports. if the solution with the "scheduler" and Kron is not suitable and you want to "rialtaym," dig in the direction of the "external stored procedure" on signatures they are written starting with the 3rd, afaik, the version, and for a fresher can try any plugin from here External Language Stored Procedures, you can use them to write in languages other than C (Java, Perl, and something else), though it works mysteriously, and if possible, it is best to write the old fashioned way on signatures without any additional plugins.
by
0 like 0 dislike
There are "triggers", maybe this will suit you. Googling "MySQL triggers", information on this topic a lot even in Russian.
by
0 like 0 dislike
If commercial script paid then contact their support, they are obliged to help You. If not paid — desander :)
by
110,608 questions
257,186 answers
0 comments
27,386 users