首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >mysqli_stmt_bind_result的SQLSRV均衡器

mysqli_stmt_bind_result的SQLSRV均衡器
EN

Stack Overflow用户
提问于 2018-06-01 22:24:38
回答 1查看 220关注 0票数 0

我正在处理一个注册/登录表单,这是我第一次使用SQLSRV (因为Azure数据库),但我似乎找不到用于SQLSRV的mysqli_stmt_bind_result版本,有人能帮我吗?提前谢谢你,托马斯

EN

回答 1

Stack Overflow用户

发布于 2018-06-01 22:31:51

我认为你的函数是sqlsrv_fetch_array()

你可以查看这个简单的例子:

代码语言:javascript
复制
<?php
$server = 'server\instance,port';
$cinfo = array(
    "Database"=>'master',
    "UID"=>'user',
    "PWD"=>'password'
);

$conn = sqlsrv_connect($server, $cinfo);
if( $conn === false )
{
    echo "Error (sqlsrv_connect): ".print_r(sqlsrv_errors(), true);
    exit;
}

$sql = 
    "SELECT 'SUSER_SNAME' AS [NAME], CONVERT(varchar(128), SUSER_SNAME()) AS [VALUE]".
    "UNION ALL ".
    "SELECT 'SUSER_NAME' AS [NAME], CONVERT(varchar(128), SUSER_NAME()) AS [VALUE]".
    "UNION ALL ".
    "SELECT 'USER_NAME' AS [NAME], CONVERT(varchar(128), USER_NAME()) AS [VALUE]".
    "UNION ALL ".
    "SELECT 'USER_ID' AS [NAME], CONVERT(varchar(128), USER_ID()) AS [VALUE]";
$stmt = sqlsrv_query($conn, $sql);
if( $stmt === false ) {
    echo "Error (sqlsrv_query): ".print_r(sqlsrv_errors(), true);
    exit;
}

while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    echo $row['NAME'].": ".$row['VALUE']."</br>";
}

sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
?>

使用参数的示例:

代码语言:javascript
复制
...
$sql = "SELECT * FROM Gebruikers WHERE username = (?) AND password = (?)";
// $params definition:
// - A literal value.
// - A PHP variable.
// - An array with the following structure:
// array($value [, $direction [, $phpType [, $sqlType]]]) where $direction is one of the following: SQLSRV_PARAM_IN, SQLSRV_PARAM_OUT, SQLSRV_PARAM_INOUT. The default valueis SQLSRV_PARAM_IN.
$params = array(
    array($vusername, SQLSRV_PARAM_IN),
    array($vpassword, SQLSRV_PARAM_IN)
);
$stmt = sqlsrv_query($conn, $sql, $params);
if( $stmt === false ) {
    echo "Error (sqlsrv_query): ".print_r(sqlsrv_errors(), true);
    exit;
}
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    $vusername = $row['username'];
    $vpassword = $row['password'];
}
'''

你可以阅读更多的here

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/50645613

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档