if(isset($_POST['log_name']) && isset($_POST['log_password'])) {

    $username = $_POST['log_name'];
    $password = $_POST['log_password'];

    $sql = $db->prepare("SELECT * FROM users WHERE uname = ?");
    $sql->bindParam(1, $username, SQLITE3_TEXT);

    $ret = $sql->execute();

    while ($row = $ret->fetchArray(SQLITE3_ASSOC))
    {
        $id = $row['userid'];
        $regas = $row['regas'];
        $uemail = $row['uemail'];
        $pword = $row['pword'];
        $uname = $row['uname'];
        $package = $row['package'];

        if (password_verify($password, $pword))
        {


          $_SESSION['log_id'] = $id;
          $_SESSION['log_name'] = $username;
          $_SESSION['regas'] = $regas;
          $_SESSION['uemail'] = $uemail;
          $_SESSION['package'] = $package;
          //header("Location: index.php?log_id=$id");
          //echo "Sigining In...";
          //die("<script>window.location='exporter.php?userid={$id}';</script>");
          exit();
        }
        else
        {
            echo "Information incorrect";
            exit();
        }
    }
}

$("#submit_log").click(function() {
      //e.preventDefault();
      username=$("#log_name").val();
      password=$("#log_password").val();
      $.ajax({
        type: "POST",
        url: "login.php",
        data: "log_name="+username+"&log_password="+password,
        success: function(html){
          if(html=='true')    {
            window.location.assign = "exporter.php";
          }
          else {
            $(".logresult").html('Incorrect Username and Password');
          }
        },
        beforeSend:function()
        {
          $(".logresult").html("Loading...")
        }
      });
      return false;
    });

session_start();
require_once ("db.php");
$db = new MyDB();

if (!isset($_SESSION['log_name']) || !isset($_SESSION['log_id']) || !isset($_SESSION['regas']))
{
    header("Location: index.php");
}