微信小程序 wxchart获取数据库中的数据

<?php
header("Content-type: text/html; charset=utf-8");
  include_once "conn.php";

  $sql1 ="select * from (select edate date from eat group by edate order by edate desc) a limit 6";
  $sql2 ="select * from (select sum(eheat) heat from eat group by edate order by edate desc) a limit 6";
 
  if(fun_conn($sql1)){
    $result= fun_conn($sql1);
    $date = array();
    while($row = mysqli_fetch_assoc($result)){
        $date[]=substr($row["date"], -5); //只取日期中的月和日
    }  
  }else{
      $date[] = 'fail';
  }

  if(fun_conn($sql2)){
    $result= fun_conn($sql2);
    $heat = array();
    while($row = mysqli_fetch_assoc($result)){
        $heat[]=(int)$row["heat"];
    }   
  }else{
      $heat[] = 'fail';
  }
  echo json_encode(array_reverse($date));
  echo ':'; //分割符，便于在小程序端将数据分割
  echo json_encode(array_reverse($heat));die; 

在小程序端接收到数据后将其分

但有两对双引号

用substring截取

小程序不支持indexOf但是支持lastIndexOf

虽然这样挺麻烦的，但是我一时想不到什么比较好的做法就先这样🙁