我有以下函数从数据库中提取数据:
public function get_dataset() {
$dataset = "";
$data_set = $this->operations_model->get_date();
foreach ($data_set as $value) {
$dataset .= '["' . $value['date'] . '","' . $value['revenue'] . '"],';
}
echo $dataset;
}
并以以下格式返回数据:
["2015-10-13 15:53:20","15000.00"],["2015-10-13 15:53:20","5800.00"],["2015-10-13 15:53:20","5800.00"],["2015-10-13 15:53:20","5800.00"],["2015-10-13 15:54:56","15000.00"],
我想把上面的数据格式化成以下格式:
[[2015-10-13 15:53:20,15000.00],[2015-10-13 15:53:20,5800.00],[2015-10-13 15:53:20,5800.00],[2015-10-13 15:53:20,5800.00],[2015-10-13 15:54:56,15000.00]]
try this
public function get_dataset() {
$dataset = "[";
$data_set = $this->operations_model->get_date();
foreach ($data_set as $value) {
$dataset .= '["' . $value['date'] . '","' . $value['revenue'] . '"],';
}
$dataset = substr($dataset, 0, -1);
$dataset .= "]";
echo $dataset;
}
try:
public function get_dataset() {
$dataset = "";
$comma='';
$data_set = $this->operations_model->get_date();
foreach ($data_set as $value) {
$dataset .= $comma.'[' . $value['date'] . ',' . $value['revenue'] . ']';
$comma=',';
}
echo '['.$dataset.']';
}