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(
I don't think mysql triggers produce output. What they can do is set certain variables each time they're activated. You can extract these variables if you know the name using select statement. Eg: select @var1 as 'total_clicks'
if you have written select statement in the trigger then it can definitely produce an output..i want to know how to capture the output produced by the trigger using php. you can think it as the select statement you have mentioned above can be the part of the trigger too