php - 如何使字符串数组在php中将其发送为JSON格式？

Question

This question already has answers here:

How can I split a comma delimited string into an array in PHP?
                                
                                    （7个答案）
                                
                        
                                3个月前关闭。
            
                    
我有一列名为 emi_date的列，它以类似于 ,的逗号分隔的 10-9-2017,10-10-2017,10-11-2017形式存储日期。
当我从表中获取所有数据时，它看起来像

{
    "success": 1,
    "data": {
        "0": {
            "no_of_month": "3",
            "emi_date": "10-9-2017,10-10-2017,10-11-2017",
        },
    },
    "message": ""
}

但我需要 emi_date作为这样的数组

{
    "success": 1,
    "data": {
        "0": {
            "no_of_month": "3",
            "emi_date": [
                       "10-9-2017",
                       "10-10-2017",
                       "10-11-2017"
             ]

        },
    },
    "message": ""
}

我的代码看起来像这样

<?php
    include "connection.php";

    extract($_REQUEST);

    $data = array();
    $resArr = array();

    $query = customSelectQuery("select ltc.*, c.*  FROM loan_to_customer ltc 
                                LEFT JOIN customer c ON ltc.customer_id = c.customer_id
                                WHERE ltc.customer_id = $loan_number");

    if(sizeOf($query)>0){
        $d = array();
        foreach($query as $row){
            $d[] = array(
                "loan_amount" => $row['loan_amount'],
                "no_of_month"=>$row['no_of_month'],
                "emi_date" =>$row['emi_date'],

            );
        }
    }
    $resArr= array("success"=>1,"data"=>$d,"message"=>"");
    header('Content-Type: application/json');
    echo str_replace("\/","/",json_encode($resArr,JSON_UNESCAPED_UNICODE));

?>

最佳答案

使用explode()这样做：

"emi_date" => explode(',',$row['emi_date']),

关于php - 如何使字符串数组在php中将其发送为JSON格式？ ，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/58248095/

上一篇：mysql - inner join in mysql需要很长时间

下一篇：php - 我想通过最后一个 ID 回显 CodeIgniter 中的最后一个值

Answer 1

使用explode()这样做：

"emi_date" => explode(',',$row['emi_date']),