PHP MySQL erişim saklı yordam

0 Cevap php

: Ben saklı yordamı, burada kod oluşturma

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

0 Cevap