php sqlsrv 取值,PHP中的sqlsrv函数-用法

$dateBase,"UID"=>$user,"PWD"=>$passWord);

$conn=sqlsrv_connect($server,$connInfo);

if($conn==false)

{

echo "数据库连接失败！

";

die(print_r(sqlsrv_errors(),true));

}

//$sql="SELECT MessageTime FROM Home_NonCustomers";

$sql="SELECT convert(char,MessageTime,23) as MessageTime FROM Home_NonCustomers";

$stmt=sqlsrv_query($conn,$sql);

if($stmt==false)

{

echo "数据表连接失败！

";

die(print_r(sqlsrv_errors(),true));

}

if(sqlsrv_fetch($stmt)==false)

{

echo "数据表查询失败！

";

die(print_r(sqlsrv_errors(),true));

}

//$name=sqlsrv_get_field($stmt,1,SQLSRV_FETCH_ASSOC);

//$name=sqlsrv_get_field($stmt,2,SQLSRV_PHPTYPE_STRING(SQLSRV_ENC_BINARY));

//$name=sqlsrv_get_field($stmt,0,SQLSRV_PHPTYPE_DATETIME);

$name=sqlsrv_get_field($stmt,0,SQLSRV_PHPTYPE_STRING(SQLSRV_ENC_CHAR));

//$name=iconv("utf-16le","utf-8",$name);

echo "输出-";

echo "$name:";

while($row=sqlsrv_fetch_array($stmt,SQLSRV_FETCH_NUMERIC))

{

echo "输出";

echo $row[0];

echo $row[2];

//echo $row['MessageContent'];

}

sqlsrv_free_stmt($stmt);

?>