how to call mysql procedure in php

how to call mysql procedure in php

i created a procedure in mysql
enter code hereDELIMITER // enter code herecreate procedure
insert_trans_id (IN $Project_Code varchar(100),IN $user_name
varchar(100),IN $item_name varchar(100),IN $Unit_Name varchar(100),IN
$item_size1 varchar(50),IN $item_qty1 int,IN $l_name varchar(100) ) enter
code here begin enter code here declare $p_id int; enter code here declare
$user_id int; enter code here declare $i_id int; enter code here declare
$unit_id int; enter code here declare $item_size varchar(50);
enter code here declare $item_qty int; enter code here declare $loc_id int;
enter code here set @item_size = ($item_size1); enter code here set
@item_qty = ($item_qty1); enter code hereset @p_id = (SELECT id FROM
project_master WHERE Project_Code enter code here= $Project_Code) ; enter
code hereset @user_id = ( SELECT u_id FROM user WHERE user_name =
$user_name); enter code here set @i_id =(SELECT id FROM item_master WHERE
item_name = $item_name); enter code hereset @unit_id = (SELECT id FROM
unit_mstr WHERE Unit_Name = $Unit_Name); enter code hereset @loc_id =
(SELECT id FROM location_mstr WHERE l_name = $l_name);
enter code herePREPARE STMT FROM
enter code here"INSERT INTO project_transaction_header(project_id, u_id,
item_Id, unit_id,Size, Qty, location_id, Created_On, Created_By,
Modified_on, Modified_By)
VALUES(p_id,user_id,i_id,$unit_id,item_size,item_qty,loc_id,'system',now(),'system',now()
)"; enter code here EXECUTE STMT USING
@p_id,@user_id,@i_id,@$unit_id,@item_size,@item_qty,@loc_id; END `
its working fine in phpmyadmin but i don,t now how to call same procedure
in php help me if possible example needed