store procedure in php

[it_1]

Hi friends,

any body just give how to call store procedure from php with mysql function not using mysqli function...

[somedude3488]

Usually its mysql_query("call prodecure_name(params)"); .

Why couldn't you find this with a search engine? Its simple.

[dev.vini]

DELIMITER $$
CREATE PROCEDURE `inserttest`(IN name VARCHAR(100), IN class VARCHAR(100))
BEGIN
	INSERT INTO test set `name`=name, `class`=Class;
	
END$$
DELIMITER ; 
///////////// way to call the store proceedure

CALL inserttest('TEST','class');