A stored procedure has a header and a body using to declarative SQL statements stored inside the database catalog.

There are three diffrent ways to pass parameters in procedures :
1) IN-parameters
2) OUT-parameters
3) IN OUT-parameters

Database table
Create user table with name and email.

syntax to create stored procedure

Create config.php file

Call procedure in your php code

Insert stored procedure

Insert.php page