PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
i am facing a big problem.it is related to handling of triggers by php.suppose i have stored a trigger in mysql server.let it be that its an "after" trigger.now when we try to update a table then a trigger is called. i want to know how can we capture the result produced by that trigger using php.since i am only passing the update query, i really don't know what is happening behind the scene(i.e. when is the error executed and what is the output of the trigger.though the output of a stored procedure can be easily captured(because in the case of procedure we directly call the procedure in our query), but what we will be do in case of trigger?..pleaseee help me..i am really confused:((
It's not clear why you want to know that. Provide real-world scenario where getting some kind of results from trigger would be useful. I bet there are better ways to achieve what you're trying to achieve.
the reason is that capturing the result of the trigger is part of my mtech project work and i am not getting even a slightest idea about how to do it:(
Triggers are meant to modify the incoming data or update/alter other tables to reflect the incoming data. They don't return anything. You'll have to select their results afterward.