Redirect with jQuery and PHP

Question

I have two pages where one is the .js calling via ajax a PHP routine to validate a user: https://pastebin.com/37RQtjUY

Another page in PHP that is the call of this previous routine where I will validate the user by his login and password to refer it to the rest of the site: https://pastebin.com/SExFjj3V

On line 23 and 24 I make a insert on a table of log, however, when I do this, I have the JSON return to the page that called that routine; on the page .js this return of PHP comes right, only on line 23 we have a redirect to the index_adm.php, but jQuery isn’t doing it.

When I comment on line 23 and 24 (i.e., the insert on the table of log in https://pastebin.com/SExFjj3V) Redirecting works well. Only when I insist on doing this insert is that it doesn’t work. I don’t understand why this.

Answer 1

Why don’t you try "prepare" and "execute" to see if php is not generating an error qdo vc does the Insert?

        $erros = array();

        $sql_in ="INSERT INTO log_user_on (fk_id_user_sistema,log_user_on_login_data) VALUES ( ?, ? ) ";

        // prepare 
        if ($stmt = $conn->prepare($sql_in)){

            //bind
            $stmt->bind_param("ss", $id_user, $hoje );

            //execute
            if ( $stmt->execute() ) {

                // echo "\n New records created successfully";

            }else{
                $erros["execute_error"] = $conn->error;
            }

            //close
            $stmt->close();

        }else{

            $erros["prepare_error"] = $conn->error;

        }

        $conn = null;

        $response = array("success" => true,"login"=>$varLogin,"id_user"=>$id_user,"token"=>$token, "erros"=>$erros);

        echo json_encode($response);