using postgresql functions from php

From: RobertD(dot)Stewart(at)ky(dot)gov
To: pgsql-general(at)postgresql(dot)org
Subject: using postgresql functions from php
Date: 2004-12-07 19:35:58
Message-ID: 06AF099D94D33B4D9120504521D6539D0FC6E917@agency33.state.ky.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have created a function in postgresql

CREATE OR REPLACE FUNCTION public.insert_vpn_masteraccount(varchar, varchar,
varchar, varchar, varchar, varchar, varchar, varchar, varchar)

RETURNS varchar AS

'

DECLARE

BEGIN

insert into masteraccount(fname,midint,lname,username,atype)
values($1,$2,$3,$4,$5);

insert into passwd(u_id,currentpwd) values((select max(u_id) from
masteraccount where username=$4),$6);

insert into ipinfo(u_id,ipaddress,atype) values((select max(u_id) from
masteraccount where username=$4),$7,$5);

insert into userinfo(u_id,agency,user_email) values((select max(u_id) from
masteraccount where username=$4),$8,$9);

return masteraccount.u_id where masteraccount.username=$4;

END;

'

LANGUAGE 'plpgsql' VOLATILE;

I can insert data using this function with a sql statement by typing

select
insert_vpn_masteraccount('tom','d','johnson','tomd.johnson','V','1234','DHCP
','AGR','idontcare(at)care(dot)com'

this works fine

but when I try to do it from a php web page using

$enter = $db_object->query("SELECT
insert_vpn_masteraccount('$fname','$mi','$lname','$acc_type','$passwd','$ip'
,'$agency','$contact')");

This does not work

Can anyone help me?

Thanks

Robert Stewart

Network Eng

Commonwealth Office of Technology

Finance and Administration Cabinet

101 Cold Harbor

Work # 502 564 9696

Cell # 502 330 5991

Email RobertD(dot)Stewart(at)ky(dot)gov <mailto:RobertD(dot)Stewart(at)ky(dot)gov>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-12-07 20:06:28 Test
Previous Message Joshua D. Drake 2004-12-07 18:35:03 Re: Fwd: 8.0 vs. 7.4 benchmarks