stored procedure in MYsql access in PHP
Posted
by
xcodemaddy
on Stack Overflow
See other posts from Stack Overflow
or by xcodemaddy
Published on 2011-01-12T07:47:29Z
Indexed on
2011/01/12
7:53 UTC
Read the original article
Hit count: 466
Hi.. I am creating stored procedure ,here code :
CREATE PROCEDURE `dbnm`.`getlogin`
(
IN uid INT,
IN upass VARCHAR(45)
)
BEGIN
if exists(select uphno,pass from user_master where uphno=uid and pass=upass)then
***true
else
***false
end if;
END $$
DELIMITER ;
i want return value(**true or **false) in stored procedure
from PHP by calling sp
PHP code:
$res = $mysqli->query('call getlogin("1","rashmi")');
how to acesss boolean value in PHP from sp? Thanks
© Stack Overflow or respective owner
