dongxiao1591 2015-09-09 15:32
浏览 86
已采纳

从SQL Server检索数据并将其转换为json格式?

I am using PHP 5.6.0 and connected to my local SQL Server. I was able to retrieve the data, but it is in an array format. I would like to convert it into a json format.

What I get:

(     
    [date] => 2013-02-05 16:02:02.000000
    [timezone_type] => 3
    [timezone] => America/New_York
)

What I want:

(
    "date" : "2013-02-05 16:02:02.000000",
    "timezone_type" : "3",
    "timezone" : "America/New_York"
)

Here is my code:

$sql = "SELECT * FROM table";
$stmt = sqlsrv_query($conn, $sql);

$result = array(); 

do {
    while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
    $result[] = print_r($row); 
    }
} while (sqlsrv_next_result($stmt));


echo json_encode($result);


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

My understanding is that json_encode should convert my data but it doesn't seem to work that way.

Thank you!

  • 写回答

3条回答 默认 最新

  • drot98385 2015-09-09 15:57
    关注

    I guess there were two mistakes in your code. First one is

    $result[] = print_r($row); 
    

    You are executing a function and pushing values in array at same time. You should push value in array here. Like

    $result[] = $row;
    

    And Second one is, not printing the JSON varibale after encoding it. So your code would be

    $sql = "SELECT * FROM table";
    $stmt = sqlsrv_query($conn, $sql);
    
    $result = array(); 
    
    do {
        while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)){
           $result[] = $row; 
        }
    } while (sqlsrv_next_result($stmt));
    
    
    sqlsrv_free_stmt($stmt);
    sqlsrv_close($conn); //Close the connnectiokn first
    
    echo json_encode($result); //You will get the encoded array variable
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 为什么apriori的运行时间会比fp growth的运行时间短呢
  • ¥15 帮我解决一下膳食平衡的线性规划模型的数据实例
  • ¥40 万年历缺少农历,需要和阳历同时显示
  • ¥250 雷电模拟器内存穿透、寻基址和特征码的教学
  • ¥200 比特币ord程序wallet_constructor.rs文件支持一次性铸造1000个代币,并将它们分配到40个UTXO上(每个UTXO上分配25个代币),并设置找零地址
  • ¥15 关于Java的学习问题
  • ¥15 如何使用chatgpt完成文本分类任务?
  • ¥15 已知速度v关于位置s的等式,怎么转化为已知位置求速度v的等式
  • ¥15 我有个餐饮系统,用wampserver把环境配置好了,但是后端的网页却进去,是为什么,能不能帮远程一下?
  • ¥15 R运行没有名称为"species"的插槽对于此对象类"SDMmodelCV"