Home >Backend Development >PHP Tutorial >Analysis: PHP calls MsSQL stored procedure and uses built-in RETVAL to obtain the return value in the process_PHP tutorial
Analysis: PHP calls MsSQL stored procedure and uses built-in RETVAL to obtain the return value in the process_PHP tutorial
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-07-21 15:01:04916browse
[PHP code]
Copy code The code is as follows:
$stmt = mssql_init('P__Global_Test' , $conn) or die("initialize stored procedure failure");
mssql_bind($stmt, "RETVAL", $returnValue, SQLINT4, true);
mssql_execute($stmt, false);
if ( $returnValue == 0 ){
echo 'ABCD'; 🎜>
[Stored Procedure]
Copy code
The code is as follows: CREATE PROCEDURE dbo.P__User_JudgeResume(
)set nocount on
set @Message = ''
if not exists( select * from _Test )
begin
return 0
end
else
begin
return 1
end
set nocount off
GO
set @Message = ''
if not exists( select * from _Test )
begin
return 0
end
else
begin
return 1
end
set nocount off
GO
http://www.bkjia.com/PHPjc/328010.html
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Analyze the operation of mysql using the mysqli extension library in PHP_PHP tutorialNext article：Analyze the operation of mysql using the mysqli extension library in PHP_PHP tutorial