环境: php 5.6.3 + Apache
<?php
header("Content-type:text/html;charset=UTF-8");
$serverName = "127.0.0.1"; //数据库服务器地址
$uid = "gamedata"; //数据库用户名
$pwd = "00000000"; //数据库密码
$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"game2018");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn == false)
{
echo "连接失败!";
die( print_r( sqlsrv_errors(), true));
}else{
echo "连接成功!"."<br>";
}
$query = sqlsrv_query($conn, "select count(*) from test_zf where userid=123");
$row = sqlsrv_fetch_array($query);
echo "充值次数: " . $row["0"]."<br>";
//调用存储过程,并填充参数
$id=3;
$userid=123;
$name="搞事";
$name=iconv("utf-8", "gbk", $name); //解决中文乱码
$params = array(
array(&$id, SQLSRV_PARAM_IN),
array(&$userid, SQLSRV_PARAM_IN),
array(&$name, SQLSRV_PARAM_IN)
);
$tsql_callSP = "{call [dbo].[test_php](?,?,?)}"; //调用存储过程,并填充参数
$stmt3 = sqlsrv_query( $conn, $tsql_callSP, $params);
if( $stmt3 == false )
{
echo "出现错误了:1:提示过程参数过多 仔细看是不是连接错库了"."<br>";
die( print_r( sqlsrv_errors(), true));
}
echo "11111111111111";