Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

9Lessons Blog:
Stored Procedure Lesson
Jul 05, 2010 @ 09:17:06

On the 9Lessons blog today there's a new post looking at stored procedures - how to create them and how to use them from your PHP code.

Are you writing Stored Procedures if not please take a look at this post. Stored procedures can help to improve web application performance and reduce database access traffic. In this post I want to explain how to create and call the stored procedures from database server.

He shows you how to create a sample table and stored procedure on the server side (selecting a username from a users table) and how it compares to a normal SQL query. Two different ways to input values into the procedure are shown as well.

tagged: tutorial stored procedure mysql