php原生读写mysql，新增数据并获取添加的数据的json格式

php原生读写mysql，新增数据并获取添加的数据的json格式

代码如下：

    $sql = "INSERT INTO device_list_equipment(dev_id,name,password,supplie,model,remark) VALUES ('{$dev_id}','{$name}','{$rate}','{$supplier}','{$model}','{$remark}')";
    $result = mysqli_query($connection,$sql);
    if($result) {
      $sql="select * from device_list_equipment where name='$name' and dev_id='$dev_id'";
      $result=mysqli_query($connection,$sql);//运行sql mysqli_num_rows
    }
    if(mysqli_num_rows($result) > 0) {

      while($row = mysqli_fetch_assoc($result)) {
            $data[] = $row;
      }
      $json = json_encode(array(
            'resultCode' => 200,
            'message' => '数据新增成功！',
            'data' => $data
      ),JSON_UNESCAPED_UNICODE);
      echo $json; //转换成字符串json

    }else{
      echo '232';
      $json = json_encode(array(
            'resultCode'=> 200,
            "message" =>'暂无数据',
            'data'=>''
      ),JSON_UNESCAPED_UNICODE);
      
      echo $json

    }

  

    echo $data ;