<?php
  $servername = "localhost";
  $username = "root";
  $pass = "pass";
  $dbName = "SheetPal";
  $conn = mysqli_connect($servername , $username , $pass , $dbName);

  if(!$conn){
    die("Connection failed: " . mysqli_connect_error());
  }
  else{
    if( !$getWeek = $conn->prepare("SELECT date,task,paycode,starttime,finishtime,breaks,totalhours,comments FROM shifts") ){
      echo "Getweek prepare failed: (" . $conn->error . ")";
    }
    else{
      $getWeek->execute();
      if( !$getWeek->bind_result($date, $task, $paycode, $starttime, $finishtime, $breaks, $totalhours, $comments) ){
        echo "Getweek bind results failed: (" . $getWeek->errno . ") " . $getWeek->error;
      }
      else{
        $shift = array();
        while($getWeek->fetch()) {
          $shiftObject = (object) [
          "date" => $date,
          "task" => $task,
          "paycode" => $paycode,
        ];
        }
      }
    }
  }

?>