在一个命令中使用php从sql server获取所有列 - Obtain all of the columns from sql server using php in one command?

Obtain all of the columns from sql server using php in one command?

本文关键字：sql php server 获取一个命令 | 更新日期: 2023-09-27

是否有办法从sql server表中获取所有数据。我想要实现的是我有一个sql表5列。它们有x个元素，但是它们都有x个元素。举个例子，我有五列A B C D E。它们都有10个条目或20个条目。

现在我知道如何为其中一个运行查询

    $serverName = "server"; //serverName'instanceName
    $connectionInfo = array( "Database"=>"db", "UID"=>"u/n", "PWD"=>"pass");
    $conn = sqlsrv_connect( $serverName, $connectionInfo);
    $sql = "SELECT A FROM Table";
    $query = sqlsrv_query($conn, $sql);
    if ($query === false){  
        echo "Could not link to SQL Server";
    }
    $i = 0;  
    while ($row = sqlsrv_fetch_array($query))
    {   
        $A[$i] = "$row[A]";
        $i++;
    }        
    sqlsrv_free_stmt($query);
    sqlsrv_close( $conn );

所以在这段代码中，我得到了列A的值，它们存储在长度为$ I的$A数组中。我的问题是，我可以(如果是的话，如何)在不复制代码的情况下一次对所有列执行此操作。我知道

$sql = "SELECT * FROM Table";

但是之后该怎么办呢?

这样不行吗?

$serverName = "server"; //serverName'instanceName
$connectionInfo = array( "Database"=>"db", "UID"=>"u/n", "PWD"=>"pass");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
$sql = "SELECT * FROM Table";  //change this to select * like you would in SQL
$query = sqlsrv_query($conn, $sql);
if ($query === false){  
    echo "Could not link to SQL Server";
}
$i = 0;  
while ($row = sqlsrv_fetch_array($query))
{   
    $A[$i] = "$row[A]";
    $B[$i] = "$row[B]";
    $C[$i] = "$row[C]";  //add rest of the columns similarly
    $i++;
}        
sqlsrv_free_stmt($query);
sqlsrv_close( $conn );