如
存储过程:
create check_user(vusername varchar(20),vuserpwd varchar(40),out vusercount int )
begin
select count(*) into vusercount from user where user_name=vusername and user_passward=vuserpwd;
end;
在php文件中怎么调用?
------解决方案--------------------
create check_user(vusername varchar(20),vuserpwd varchar(40),out vusercount int )
begin
select count(*) into vusercount from user where user_name=vusername and user_passward=vuserpwd;
end;
送出查询( call check_user( 'user ', 'pass ',@vusercount) );
送出查询( select @vusercount );
$row = .....-> fetch_array();
print_r($row)