php code

<?php
include 'db_connect.php';
  //if receives data from insert form, run function
if(isset($_POST['insert_data']) )
{

  date_default_timezone_set("Europe/London");
  //date("h:i:sa");

  $refno_usr = uniqid();
  $username = SQLite3::escapeString($_POST['username']);
  $password = SQLite3::escapeString($_POST['password']);
  $cpassword = SQLite3::escapeString($_POST['cpassword']);
  $fullname = SQLite3::escapeString($_POST['fullname']);
  $admin_user = SQLite3::escapeString($_POST['access']);
  $created_time = date("h:i:sa");
  $deleted = 0;
  $deleted_date = date("h:i:sa");

  //check if confirm password equals password
  if($password != $cpassword) {
    echo $db->lastErrorMsg();
  } else {
    //hash and salt
    $hash = password_hash($password, PASSWORD_BCRYPT);
  }

$sql =<<<EOF
   INSERT INTO userlist (refno_usr, user_name, user_password, full_name, admin_user, created_time, deleted, deleted_date)
   VALUES ('$refno_usr', '$username', '$hash', '$fullname', '$admin_user', '$created_time', '$deleted', '$deleted_date');
EOF;

  //Executes query
  $ret = $db->exec($sql);
  //outputs error or success message
  if(!$ret)
  {
     echo $db->lastErrorMsg();
  } else {
     echo "Records Inserted successfully\n";
  }

  //Closes connection
  $db->close();
}

header("Location: http://localhost/Metro_Janua/Metro_Lab_Main_Files/metro_lab_template/user_table.php");