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>
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 |