stored procedure in MYsql access in PHP
- by xcodemaddy
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
