I need to execute a procedure sending a parameter by php but is not returning follow the code below:
//código em PHP
$figura = mysqli_query($conexao,"CALL 'spare_change'.'boxlabel'('".$template."')") or die("erro no update");
//A Procedure Criada
CREATE DEFINER='root'@'%' PROCEDURE 'boxlabel'(template varchar(20))
BEGIN
-- update prom.label_template set label_tpl_content = replace(label_tpl_content, ' eJz', 'eJz') where label_tpl_name = @template;
select * from prom.label_template where label_tpl_name = @template;
END
Where is the error in the code?