Hi there!
I'm opening another subject because i couldn't get any help from the last one.
My application is working probably on local but on the webhosting,the login page doesn't work.It keeps redirecting me on the welcome page.
i'm getting very frustrated and worried.
I have try everything possible,checked that my variable and my fields names are exactly the same as in the database.But still nothing is working.
Bigron11 tried to help me(thanx to him) but i can't get it work,i'm desperate here.
My code:
Language: PHP
<?php
//This is the login page.A username is matched with the corresponding password before loging in //
$username = "root";// Mysql username
$password = "";// Mysql password
$database = "userlogin"; // Database name
$server = "127.0.0.1"; // Server name
// Connect to server and select database.
$db = mysql_connect($server,$username,$password) or DIE("oops,something went wrong");
mysql_select_db($database,$db) or DIE("oops,something went wrong");
//Starting a session
session_start();
if(isset($_POST[';submit';])){
$username = $_POST["username"]; //username is stored in $username variable.
$password = $_POST["password"]; //password is stored in $password variable.
$match = "select id from login where username = ';$username';and password = ';$password';;";
$qry = mysql_query($match);
$num_rows = mysql_num_rows($qry);
//Check if $num_rows variable is true
if ($num_rows <= 0){
echo "Sorry, there is no username $username with the specified password.";
echo "Try again";
echo "<a href = ';index.php';>Back</a>";
exit;
}
else {
$_SESSION[';user';]= $_POST["username"];
header("location:logged.php");// This is the page where we will be redirect after loging in
}
}
echo"<body bgcolor=';#E0FFFF';>";
echo"<p>Please enter your username and your password or <a href=';index.php';>click here</a> to go back to the index page</p>";
echo"<form action = '; '; method = ';post';>";
echo"<label>Username:</label>";
echo"<input type = ';text'; name = ';username';/><br/>";
echo"<label>Password:</label>";
echo"<input type = ';password'; name = ';password';/><br/>";
echo"<input type = ';submit'; name=';submit'; value = ';Login';/><br/>";
echo"</form>";
echo"</body>";
?>
i've changed the connection part with the new database created on the webhosting area.I am using orgfree.com.
