MySQL Forums :: Triggers :: Creating a trigger via PHP program

Do it like this with mysqli php extension:
<?php
$db=new mysqli($host, $user, $password, $db);
$trigger="CREATE TRIGGER trigger1 BEFORE INSERT ON table1
FOR EACH ROW
BEGIN
IF NEW.VALUE1 = 1 THEN
SET NEW.VALUE2 = 'one';
ELSEIF NEW.VALUE1 = 2 THEN
SET NEW.VALUE2 = 'two';
END IF;
END;
";
$db->multi_query($trigger);
?>