<?
/*
1.会员注册
请求格式:
API地址/api_manage.aspx?action=registration&username=用户名&ip=IP地址&domain=公司名&safecode=加密串
返回格式:
注册成功后返回 ”登录票据|0”
注册失败后返回 ”失败原因|非0整数”
jb5888.com
[2014/9/22 12:22:42] Rock no: jb5888
123456
*/
function &Registration($username,$ip,$domain,$safecode)
{
$serverName = "127.0.0.1";
$connectionInfo = array( "UID"=>"sa","PWD"=>"123456","Database"=>"QPGameUserDB");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false )
{
echo "Could not connect.\n";
die( print_r( sqlsrv_errors(), true));
}
$strAccounts = $username; //用户帐号
$strPassword = md5("123456");//用户密码
$strPasswordBank =md5("123456");// 用户密码
$strSpreader = "";//推广员名
$nFaceID = 2;//头像标识
$cbGender =1;//用户性别
$strClientIP=$ip ;//连接地址
$strMachineSerial=$domain;//机器标识
//参数需要以如下数组方式赋值并标明类型,SQLSRV_PARAM_IN是输入类型,SQLSRV_PARAM_OUT是输出类型。注意要按照存储过程定义的顺序赋值
$params = array(
array(&$strAccounts, SQLSRV_PARAM_IN),
array(&$strPassword, SQLSRV_PARAM_IN),
array(&$strPasswordBank, SQLSRV_PARAM_IN),
array(&$strSpreader, SQLSRV_PARAM_IN),
array(&$nFaceID, SQLSRV_PARAM_IN),
array(&$cbGender, SQLSRV_PARAM_IN),
array(&$strClientIP, SQLSRV_PARAM_IN),
array(&$strMachineSerial, SQLSRV_PARAM_IN),
);
$tsql_callSP = "{call GSP_GP_RegisterAccounts(?,?,?,?,?,?,?,?)}";
$stmt3 = sqlsrv_query( $conn, $tsql_callSP, $params);
if( $stmt3 === false )
{
echo "Error in executing statement 3.\n";
die( print_r( sqlsrv_errors(), true));
return $stmt3;
}
else
{
return $stmt3;
}
}
?>
php mssql 存储过程
最新推荐文章于 2022-03-05 11:01:56 发布