<?php
  session_start();
  $user = lcfirst($_SESSION["username"]);
  $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( !$getuserID = $conn->prepare("SELECT userID FROM users WHERE username=?") ){
      echo "userID prepare failed: (" . $conn->error . ")";
    }
    else{
      if(!$getuserID->bind_param("s",$user)){
        echo "UserID Binding parameters failed: (" . $getuserID->errno . ") " . $getuserID->error;
      }
      else{
        $getuserID->execute();
        if(!$getuserID->bind_result($userID)){
          echo "GetuserID Binding result failed: (" . $getuserID->errno . ") " . $getuserID->error;
        }
        else{
          $getuserID->fetch();
          $_SESSION["userID"] = $userID;
          echo $userID . " " . $user;
        }
      }
    }
  }

$conn->close();

?>