龙盟编程博客 | 无障碍搜索 | 云盘搜索神器
快速搜索
主页 > web编程 > php编程 >

php 扩展sqlsrv调用mssql存储过程

时间:2014-07-22 14:52来源: 作者: 点击:
分享到:
<无详细内容>
$serverName = "127.0.0.1";
	$connectionInfo = array( "UID"=>"sa","PWD"=>"","Database"=>"test");
	$conn = sqlsrv_connect( $serverName, $connectionInfo);
	if( $conn === false )
	{
	     echo "Could not connect.\n";
	     die( print_r( sqlsrv_errors(), true));
	}
	$spnumber = '10655****00';
	$chargenumber = '155****6789';

	//参数需要以如下数组方式赋值并标明类型,SQLSRV_PARAM_IN是输入类型,SQLSRV_PARAM_OUT是输出类型。注意要按照存储过程定义的顺序赋值
	$params = array( 
	                 array(&$spnumber, SQLSRV_PARAM_IN),
	                 array(&$chargenumber, SQLSRV_PARAM_IN)
	               );
	$tsql_callSP = "{call msgexpress_UnicomNewSubmit(?,?)}";
	$stmt3 = sqlsrv_query( $conn, $tsql_callSP, $params);
	if( $stmt3 === false )
	{
	     echo "Error in executing statement 3.\n";
	     die( print_r( sqlsrv_errors(), true));
	}
精彩图集

赞助商链接