filmov
tv
Database Systems - PHP Database Programming with Stored Procedure Calls for Web - APPFICIAL
Показать описание
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!
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!
0:12:55
0:08:50
0:03:30
0:01:55
0:05:50
0:14:21
0:00:13
0:00:44
0:05:56
0:00:18
0:05:14
0:00:40
0:07:09
0:00:09
0:00:16
0:02:51
0:06:41
0:00:40
0:00:15
0:00:43
0:01:00
0:00:49
0:00:11
0:41:18