Uncaught Error:调用成员函数查询

Question

我正在从MySQL移动到MS SQL服务器，并试图从表中获取一些数据。我连接，但不确定如何获取数据与sqlsrv。下面是我的查询:

$sql = "SELECT ACTID, ACTTYPE, ACTDATE FROM [PROSYS].[dbo].[ACTION]";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "id: " . $row["ACTID"]. " - Name: " . $row["ACTYPE"]. "DATE " . $row["ACDATE"]. "<br>";
}
} else {
echo "0 results";
}

但是当执行它时，我有这个错误:

Fatal error: Uncaught error:调用成员函数query(C:xampphtdocsconnection.php:15 Stack trace: #0 {main}C:xampphtdocsconnection.php第15行

Answer 1

我找到了一个从查询中获得结果的解决方案，我以后再处理这个连接:)

$conn_array = array (
"UID" => "sa",
"PWD" => "root",
"Database" => "nih_bw",
);
$conn = sqlsrv_connect('BILAL', $conn_array);
if ($conn){
echo "connected";
if(($result = sqlsrv_query($conn,"SELECT * FROM routines")) !== false){
while( $obj = sqlsrv_fetch_object( $result )) {
echo $obj->colName.'<br />';
}
}
}else{
die(print_r(sqlsrv_errors(), true));
}

我现在正试图在表格上显示，但有些列已经完成，其他列不能显示此警告

Notice: Undefined property: stdClass::$FAMILLE

我用它来显示

echo "<tr>";
echo "<td>" . $obj->ARTCODE. "</td>";
echo "<td>" . $obj->ARTDES. "</td>";
echo "<td>" . $obj->FAMILLE. "</td>";