Ajax window.location not working with PHP login Script

Question

I have a PHP login script which executes with ajax. The ajax request now starts the session in the login successfully but the window.location function doesn't work (doesn't redirect to exporter.php) in the ajax request. Below are my codes.

php Login Script

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();
        }
    }
}

Ajax Request

$("#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;
    });

Beginning part of exporter.php

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");
}

What could be wrong here and how do i fix this redirecting issue please!!!.Thanks.

You may want to use e.preventdefault(); for reference see: api.jquery.com/event.preventdefault — Freid001
– Freid001, Commented Aug 1, 2017 at 21:03

alen · Accepted Answer · 2017-08-01 21:11:23Z

2

your php login script needs echo 'true'; according to your ajax callback.

and use location.href = "/exporter.php"; to redirect page with JavaScript

answered Aug 1, 2017 at 21:11

alen

2762 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

diagold Over a year ago

Perfect answer. Exactly what i was looking for. Thanks for pointing that out.

Chandra Kumar · Accepted Answer · 2017-08-01 21:05:14Z

1

You should use like this:

window.location.href= "/exporter.php";

answered Aug 1, 2017 at 21:05

Chandra Kumar

4,2131 gold badge19 silver badges26 bronze badges

Comments

Utkarsh Pandey · Accepted Answer · 2017-08-01 21:02:18Z

0

window.location.assign = "exporter.php";

will not work, use

window.location = "exporter.php";

answered Aug 1, 2017 at 21:02

Utkarsh Pandey

1,7261 gold badge12 silver badges12 bronze badges

Comments

Bhavyanshu · Accepted Answer · 2017-08-01 21:03:09Z

0

You are using assign incorrectly.

window.location.assign("exporter.php")

Or you can use href instead.

window.location.href = "exporter.php";

answered Aug 1, 2017 at 21:03

Bhavyanshu

5367 silver badges25 bronze badges

Comments

Baran Saeed · Accepted Answer · 2017-08-01 21:05:52Z

0

Try using assign like this:

window.location.assign(data);

if this method not work for you let me know.

and if the Success:html is boolean then you're checking it in wrong way delete the single quotes it's not a string it is boolean datatype.

answered Aug 1, 2017 at 21:05

Baran Saeed

902 silver badges9 bronze badges

3 Comments

diagold Over a year ago

Neither method works. I am confused myself as where the issue is from.

Baran Saeed Over a year ago

please check that the if condition is being executed or not by using an alert() method.

diagold Over a year ago

@alen answer pointed out the issue with my php. Thanks for helping.

Collectives™ on Stack Overflow

Ajax window.location not working with PHP login Script

5 Answers 5

1 Comment

Comments

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related