X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B7656D1B45D for ; Fri, 30 Jan 2004 16:42:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 00685-09 for ; Fri, 30 Jan 2004 12:42:24 -0400 (AST) Received: from hosting.commandprompt.com (215.commandprompt.com [207.173.200.215]) by svr1.postgresql.org (Postfix) with ESMTP id B6563D1B447 for ; Fri, 30 Jan 2004 12:42:23 -0400 (AST) Received: from commandprompt.com (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i0UGgMm23366; Fri, 30 Jan 2004 08:42:22 -0800 Message-ID: <401A8967.1040106@commandprompt.com> Date: Fri, 30 Jan 2004 08:42:15 -0800 From: Robby Russell Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-php@postgresql.org Cc: Aldo Leyva Alvarado Subject: Re: Triggers, Rules and email References: <401A7CF0.9020302@commandprompt.com> <001a01c3e74a$33dca440$3d0000c0@pegasus> In-Reply-To: <001a01c3e74a$33dca440$3d0000c0@pegasus> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/32 X-Sequence-Number: 2548 Aldo Leyva Alvarado typed this on 01/30/2004 08:00 AM: > Yes, I want to see an example!!!!!! > > > Aldo Leyva > ----- Original Message ----- > From: "Robby Russell" > To: > Sent: Friday, January 30, 2004 10:49 AM > Subject: Re: [PHP] Triggers, Rules and email > > > >>scott.marlowe typed this on 01/20/2004 09:59 AM: >> >>>On Tue, 20 Jan 2004, Paul wrote: >>> >>> >>> >>>>Anyone know if I can create a trigger or a rule in Pgsql that will send >>>>an email in the event of an attempt to update a database field no-one >>>>should be updating? >>> >>> >>>Sure, that would involve installing the pl language of your choice as an >>>untrusted language. PHP can be installed that way as a pl, btw, then > > you > >>>can just use the mail() trigger function in it. >>> >>>http://www.commandprompt.com/entry.lxp?lxpe=294 >>> >>> >> >>Yes, plPHP can be used for this. If you want an example, let me know and >>I'll post one on the list. >> >>-Robby As requested, here is a simple function that takes 4 arguments ($arg0-3) and utilizes the php mail() function. I added the headers for an example of how easy it is to utilize plPHP in PostrgreSQL. CREATE OR REPLACE FUNCTION phpmail(text,text,text,text) RETURNS integer AS ' # Argument list $email_address = $arg0; $email_from = $arg1; $subject = $arg2; $body = $arg3; # # ..Typically, you would validate arguments here # Build email headers $headers = "From: $email_from\r\n"; $headers .= "Reply-To: $email_from\r\n"; $headers .= "X-Mailer: plPHP"; # Send email if (mail($email_address, $subject, $body, $headers)) { return 1; } else { return 0; } ' LANGUAGE 'plphp'; ############################################# # Usage ############################################# plphp_test=# SELECT phpmail('rrussell@commandprompt.com', 'webmaster@robbyrussell.com', 'Subject Line', 'This is the email body\n\nMore body. Testing email. Test!\n\n\n-Robby') as email; INFO: ret_val(long): 1 email ------- 1 (1 row) ############################################# # Output ############################################# webmaster@robbyrussell.com typed this on 01/30/2004 08:34 AM: > This is a body > > More body. Testing email. Test! > > > -Robby Feel free to join the plPHP mailing list as well. http://mail.commandprompt.com/mailman/listinfo/plphp Cheers, Robby Russell -- #------------------------------------------------------- # Robby Russell, | Sr. Administrator / Lead Programmer # Command Prompt, Inc. | http://www.commandprompt.com # rrussell@commandprompt.com | Telephone: (503) 667.4564 #-------------------------------------------------------