Javascript DATE from SQL Server: Codeigniter

Question

So I am currently making a line chart that it's date will be called from my db. The Problem is that the DAYS are kept repeated like this.

I want to keep the days single only like this rather than doubled. : 11Feb2018 12Feb2018 13Feb2018 14Feb2018

Javascript(Views):

dataPoints: [
 <?php foreach ($result1 as $row) { ?>
  <?php echo'{x:new Date('.$row->data1.','.$row->data2.','.$row->data3.'), 
y:'.$row->data4.'},'?>
 <?php } ?>
]

Controller:

$data['result1'] = $this->madminpathologyweekly->get_result1()->result();
$this->load->view('vadminpathologyweekly',$data);

Model:

public function get_result1() {
    $sql = "SELECT year as data1,month_of_the_year - 1 as data2, day_of_the_month as data3,";
    $sql .= "COUNT(test_id) as data4 from TBLSUBMITTEDREQUEST group by year ,month_of_the_year, day_of_the_month";
    $query = $this->db->query($sql);
    return $query;
}

so group by day_of_the_month is not working ?

prakash tank
– prakash tank

2018-02-15 06:25:27 +00:00
Commented Feb 15, 2018 at 6:25 — prakash tank
– prakash tank, Commented Feb 15, 2018 at 6:25

Lev · Accepted Answer · 2018-02-15 06:30:40Z

1

So I did a deeper research and I found out that I missed an interval type: and interval: in axis x like this.

axisX: {
        valueFormatString: "DD MMMM YYYY",
        intervalType: "day",
        interval: 1,
       },

Cheers guys. I've already solved it. Thanks for your time.

answered Feb 15, 2018 at 6:30

Lev

6511 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Javascript DATE from SQL Server: Codeigniter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related