CREATE PROCEDURE smsg_sele_login_user
(
@password varchar(80),
@phoneno varchar(256)
)
AS
select USERID
from users
where phoneno=@phoneno
and password=@password
GO

$sp_login_user=$conn->prepare('{call smsg_sele_login_user}');
$sp_login_user->bindParam('@password',$password);
$sp_login_user->bindParam('@phoneno',$phoneno);
$sp_login_user->execute();
print_r($sp_login_user->fetchAll());