I know how to call stored procedure on php. I am not familiar with trigger. But with trigger can php and trigger interact? Let say you run an sql query on php, can you also run trigger after the sql query on php have been run?
@arrielmabaleSep 07.2010 — #You can still execute php scripts after the sql runs and check which are affected, dont give too much load on your sql give some to you php scripts ^_^
@ht1815Sep 07.2010 — #Triggers are like stored procedures, but they're run when an event occurs on the database, rather than on demand. They're "triggered" by events, hence the name. So, PHP and triggers don't interact directly. Rather, PHP code interacts with the database, causing an event, which will then run a trigger.
For example, you could write a trigger to run a piece of code every time a record is inserted into a particular table. You insert the record with your PHP code, which causes the database to invoke the trigger. But, you don't run the trigger directly with PHP.