Database Systems with SQL - Full Course - Database Systems - PHP Database Programming with Stored Procedure Calls for Web - APPFICIAL

5.0 (0)

6 learners

What you'll learn

This course includes

4.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

appficial php database php programming database php mysql php php mysql php stored procedure php stored procedure call calling a stored procedure in php prepare statement in php php query php database programming

Full Transcript

Stored procedure calls A PHP script is able to call a stored procedures from database by using a prepared statement. The values are bound to the stored procedure's IN parameters. Stored procedures that have either OUT or INOUT parameter required a call with an SQL user-defined variable. To fetch the value of the variable and get the output parameter value, another query is required. The code explained: RMovieCount counts the number of R rated movies in the database Movie table The prepared statement uses a CALL statement to call count with the rating “R". execute() calls count. The OUT parameter quantity is assigned to the @count variable. A second query fetches the value of @count. Subscribe to Appficial for more programming videos coming soon. Also, don't forget to click LIKE and comment on the video if it helped you out!

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Welcome