HTML/PHP login redirects to php

Question

I have an html page that uses a php file to query a database, then log the user in, or deny access. The problem I'm having is that it simply redirects to the url of the php file, and never gives feedback on what happened. This is my first assignment with html, php, and mysql, so please excuse my lack of technical terms/knowledge.

HTML File

<html><head><title> Sign-In </title></head>
<body>

<h1> Login Form </h1>
<div id="Sign-In">
<form method="POST" action="connectivity.php">
Username: <input type='text' name='username'> <br><br>
Password: <input type='password' name='password'> <br><br>
<input id="button" type="submit" name="submit" value="Log-In">

</form>
</div>
</body>
</html>

PHP File

<?php
define('DB_HOST', 'localhost');
define('DB_NAME', 'project2');
define('DB_USER','root');
define('DB_PASSWORD','');

$con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
$db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());
/*
$ID = $_POST['user'];
$Password = $_POST['pass'];
*/
function SignIn()
{
session_start();   //starting the session for user profile page
if(!empty($_POST['user']))   //checking the 'user' name which is from Sign-In.html, is it empty or have some text
{
    $query = mysql_query("SELECT *  FROM customers where userName = '$_POST[user]' AND pass = '$_POST[pass]'") or die(mysql_error());
    $row = mysql_fetch_array($query) or die(mysql_error());
    if(!empty($row['userName']) AND !empty($row['pass']))
    {
        $_SESSION['userName'] = $row['pass'];
        echo "SUCCESSFULLY LOGIN TO USER PROFILE PAGE...";

    }
    else
    {
        echo "SORRY... YOU ENTERD WRONG ID AND PASSWORD... PLEASE RETRY...";
    }
}
}
if(isset($_POST['submit']))
{
    SignIn();
}

?>

score 2 · Accepted Answer · edited Jan 24 '19 at 13:12

2

try this:

<?php

if (!empty($row['userName']) AND !empty($row['pass'])) {

    $_SESSION['userName'] = $row['pass'];
    header("Location: mypage.php?is_login=1");
    exit;     // exit is must or you can use retun also
}

else {

    header("Location: mypage.php?is_login=0");
    exit;     // exit is must or you can use retun also             
}

?>

on the page mypage.php

<?php

if (isset($_GET['is_login']) ) {

    if ('1' == $_GET['is_login']) {

        echo "sucess";    
    }

    else {

        echo "failure";        
    }    
}
?>

edited Jan 24 '19 at 13:12

6opko

1,718
2
20
28

answered Mar 30 '16 at 05:19

Faiyaz Alam

1,191
9
27

I modified this a little bit, and it's doing exactly what I want it to. For some reason, my php file wasn't reaching the 'SignIn()' function. Thanks for your help! – Tangwheeler Mar 31 '16 at 20:52

score 1 · Answer 2 · edited May 23 '17 at 12:34

1

In your PHP File try to redirect to previous URL or to a new HTML Page Like Home Page :

header('Location: ' . $_SERVER['HTTP_REFERER']);

in your:

if(isset($_POST['submit']))
{
    SignIn();
}

Example for you answer

edited May 23 '17 at 12:34

Community

1
1

answered Mar 30 '16 at 04:51

Amitesh Kumar

3,051
1
26
42

J. Shiv · Answer 3 · 2016-03-30T05:38:30.447

1

Redirect to your PROFILE PAGE using header() OR Javascript

header("Location: profilepage.php");                      //PHP
<script>window.location = 'profilepage.php'</script>      //JS

edited Mar 30 '16 at 05:38

answered Mar 30 '16 at 05:08

J. Shiv

144
4

this will not work because you are using header after printing some text 'SUCCESSFULLY LOGIN...' – Faiyaz Alam Mar 30 '16 at 05:14
Sorry I just put that "echo code" for him to understand where to put the header code..edited – J. Shiv Mar 30 '16 at 05:38

HTML/PHP login redirects to php

3 Answers3