Need idea about Database trigger in php-mysql

[logicslab]

Hi Pals,

I am a PHP programmer like to know How I can implement

mysql Database Trigger in my code. Do you can give a "Hello world" sample

for same trigger idea. I am waiting your reply ASAP.

 

Thankfully

Anes P.A 

[The Little Guy]

http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html

[logicslab]

Hi the Little Guy,

I mean a practical sample which work in Both PHP and MySql like we study Hello world sample in php .... I need an implementation

code not any Stuff about Trigger details.

 

Thankfully

Anes

[The Little Guy]

That page does have implementation code, for example:

 

delimiter |

CREATE TRIGGER testref BEFORE INSERT ON test1
  FOR EACH ROW BEGIN
    INSERT INTO test2 SET a2 = NEW.a1;
    DELETE FROM test3 WHERE a3 = NEW.a1;
    UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
  END;
|

[logicslab]

hi The Little Guy,

Do I can Write this code directly in a PHP file to implement some trigger functionality. I really need it's usage in context of a real PHP

Program. So I ask I need a "sample" Hello world Code . If any one know it , pls Help me

 

thankfully

Anes P.A  :'(

[trq]

What The Little Guy has shown you is an SQL statement, SQL statements are executed via (amongst others) PHP's mysql_query() function. See the manual (here) for details of it's usage.

[logicslab]

Thanks Thorpe ,

I got the idea ... I am waiting for this answer YET ...  my Special thanks to The Little Guy Too... 

 

Thankfully

Anes P.A