<?php 
    
    // Arry for each line u want in ur charts
    $dataPoints = array();
    $dataMonth = array();

    $dataPoints2 = array();
    $dataPoints3 = array();

    $month = array();

    $dataPoints4 = array();
    $dataPoints5 = array();
    $dataPoints6 = array();

    $dataPoints7 = array();
    $dataPoints8 = array();
    $dataPoints9 = array();
    // making database connection
try {
    $link = new \PDO(   'mysql:host=localhost;dbname=ixora-web;charset=utf8mb4',
                        'ixoraweb', //'root',
                        '!!iXora!!2021@', //'',
                        array(
                            \PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
                            \PDO::ATTR_PERSISTENT => false
                        )
                    );
        // selecting and executing 
        $handle = $link->prepare('select * from hrm'); 
        $handle->execute(); 
        $result = $handle->fetchAll(\PDO::FETCH_OBJ);
	
 // a foreach, for each result, need to make separate array_push for every line u want to produce
    foreach($result as $row) {
      array_push($dataPoints, array("y"=>$row->Temp1, "label" => $row->MonthN)); //, "x"=>$row->Month  MonthN
     
      array_push($dataPoints2, array("y"=> $row->Temp2, "label" => $row->MonthN)); //"y"=> $row->Temp3
      array_push($dataPoints3, array("y"=> $row->Temp3, "label" => $row->MonthN));

      array_push($dataPoints4, array("y"=> $row->Kwh1, "label" => $row->MonthN));
      array_push($dataPoints5, array("y"=> $row->Kwh2, "label" => $row->MonthN));
      array_push($dataPoints6, array("y"=> $row->Kwh3, "label" => $row->MonthN));

      array_push($dataPoints7, array("y"=> $row->BAR1, "label" => $row->MonthN));
      array_push($dataPoints8, array("y"=> $row->BAR2, "label" => $row->MonthN));
      array_push($dataPoints9, array("y"=> $row->BAR3, "label" => $row->MonthN));
 }
	$link = null;
}
    
catch(\PDOException $ex){
        print($ex->getMessage());
  }