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

  $task = $_POST["task"];
  $payCode = $_POST["paycode"];
  $startTime = $_POST["startTime"];
  $finishTime = $_POST["finishTime"];
  $totalBreaks = $_POST["totalBreaks"];
  $totalHours = $_POST["totalHours"];
  $comments = $_POST["comments"];
  $date = $_POST["date"];

  $shiftsSql = $conn->prepare("INSERT INTO shifts (date,task,paycode,starttime,finishtime,totalbreaks,totalhours,comments) VALUES (?,?,?,?,?,?,?,?)");
  $shiftsSql->bind_param("ssssssss",$date,$task,$payCode,$startTime,$finishTime,$totalBreaks,$totalHours,$comments);
  $shiftsSql->execute();


?>