create and use mysql stored procedure with php. When creating php web application that need to have database support we usually create sql queries in in the php code itself and use these code for getting our work done. But mysql provide an easy way to put all sql code in mysql itself, instead of putting the sql codes in php. This feature is called stored procedure. By using stored procedure our web application will more faster than putting the codes in php.