SQLSRV不工作

Question

我试图通过SQLSRV函数从SQL查询中填充日期格式的下拉列表，但它不起作用。请帮帮忙。

<?php

$serverName1 = "kk12334";
$connectionInfo1 = array( "Database"=>"Fruits");
$conn1 = sqlsrv_connect( $serverName1, $connectionInfo1);
$sql1="SELECT [ArrivalDate] as ADate, [ArrivalCompany] as ACompany from Fruits";
$stmt1 = sqlsrv_query( $conn1, $sql1 );

while ($data=sqlsrv_fetch_array($stmt1, SQLSRV_FETCH_ASSOC))

{ 

$checkdate= $data[ADate];
$checkacct=$data[ACompany];

$checkdateDisplay = $checkdate . "-" . $checkacct;
$checkdateDisplay = substr($checkdate, 5, 2) . "-" . substr($checkdate, 8, 2) . "-" .  substr($checkdate, 0, 4) . "_:_" . $checkacct;
echo "<option value='$checkdateDisplay'>$checkdateDisplay</option>\n";

}

?>

Answer 1

您的连接数组没有遵循正确的语法，并且遗漏了重要信息：

$connectionInfo = array( "Database"=>$myDB, "PWD"=>$myPass, "UID"=>$myUser);

此错误会阻止代码连接到您的数据库。您必须同时提供用户名(UID)和密码(PWD)。