0

I'm trying to call a procedure from my database to my a website by php but i cant get i t working. herese the procedure:

DROP PROCEDURE IF EXISTS NewCannon; 
 DELIMITER //
CREATE PROCEDURE NewCannon(subPlaceName varchar(32), model char(4), status enum('on','off','unplugged','broken'),effect smallint)
BEGIN
insert into Cannon (subPlaceName, model, status, effect) values (subPlaceName, model, status, effect);
END; //
DELIMITER ;
LeonardChallis
  • 7,759
  • 6
  • 45
  • 76
lanarn
  • 21
  • 3
  • More to the point probably would be the PHP code that's not work g, including a description of "not working." Please edit your question to include that and also format the code properly – Sami Kuhmonen Nov 03 '16 at 12:56
  • 1
    Might be similar to [How To Call A MySQL stored Procedure within PHP code](http://stackoverflow.com/questions/3966747/how-to-call-a-mysql-stored-procedure-from-within-php-code) – shoieb0101 Nov 03 '16 at 13:00
  • test worked fine from mysql side, http://i.imgur.com/iDbcEoA.jpg , see YCS error avoidance (detection) via http://stackoverflow.com/q/22662488 – Drew Nov 03 '16 at 13:12

0 Answers0