HELP, MSSQL STORED PROCEDURES
| From: | nabil | Date: | Sat, 14 Jun 2003 11:30:42 +0000 |
| Subject: | HELP, MSSQL STORED PROCEDURES | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28610@lists.php.net to get a copy of this message | ||
PLEASE HELP ME PHP PEOPLE,
I have a stored procedure on a remote Microsoft (stupid) SQL server..
and I have to connect to it remotely and I have only permission to execute
those specific procedure , and I only got the returned value...
My server that I will connect from is Linux, apache with MySQL database, and
my code ofcourse PHP....
How can i connect to microsoft SQL server from my php linux server..??? i
think ODBC is not excisted in Linux...
( I reserve to myself to be wrong)...
Please help me if I can , how can I connect to that server , and execute
them, and get the return values...
One of the stored procedures that i got a copy from the remote administrator
is :
Waiting for any comment ....
/////
--==========================================================================
=======
CREATE PROCEDURE ChangePasswd
@login varchar(32) ,
@oldpass varchar(16),
@newpass varchar(16)
AS
declare @chkpass int
set @chkpass = (select count(*) from subaccounts where login=@login and
password=@oldpass)
if @chkpass<>0
begin
update subaccounts set password=@newpass where login=@login and
password=@oldpass
select '0' as err
end
else
begin
select '1' as err
end
Go
--==========================================================================
=======
////