Отново проблем с логин...

Nazi_93 · 19 Март 2011

Ето логина,къде бъркам пише ми само Failure дори и при вярни име и парола...

Код:

<?php session_start();?>
<html>
<head> <meta http-equiv="Content-Type" content="text/html; charset=windows-cp1251">
</head>   
<body>

<form action="login.php">
           <b>  Login</b><br/><br/>
          <span>Username</span><br/> <input type="text" name="loguser"><br/>
     <span>Password</span><br/><input type="password" name="logpassword"><br/>
     <input type="submit" value="Login">

<?php
$_SESSION['islogged']=FALSE;
$server='localhost';
$username='root';
$password='garchaviqgosho';
$db='users';
mysql_connect($server,$username,$password) or die (mysql_error());
mysql_select_db($db) or die (mysql_error());
$user=$_POST['loguser'];
$pass=$_POST['logpassword'];
$sql="SELECT * FROM `users`
WHERE `username`='$user' and `password`='$pass'";
$result=mysql_query($sql)or die (mysql_error());
$check=mysql_num_rows($result);
if ($check>0){
echo "Success!";
}
else 
{
echo "Failure!";
}

?>
</body></html>

tedo96 · 19 Март 2011

PHP:

<?php session_start();?>
<html>
<head> <meta http-equiv="Content-Type" content="text/html; charset=windows-cp1251">
</head>   
<body>

<form action="login.php">
           <b>  Login</b><br/><br/>
          <span>Username</span><br/> <input type="text" name="loguser"><br/>
     <span>Password</span><br/><input type="password" name="logpassword"><br/>
     <input type="submit" value="Login">

<?php
$_SESSION['islogged']=FALSE;
$server='localhost';
$username='root';
$password='garchaviqgosho';
$db='users';
mysql_connect($server,$username,$password) or die (mysql_error());
mysql_select_db($db) or die (mysql_error());
$user=$_POST['loguser'];
$pass=$_POST['logpassword'];
$sql="SELECT * FROM `users`
WHERE `username`='$user' and `password`='$pass'";
$result=mysql_query($sql)or die (mysql_error());
$check=mysql_num_rows($result);
if ($check<1){
echo "Failure!";
}
else
{
echo "Success!";
}

?>
</body></html>

Nazi_93 · 19 Март 2011

Същото,само failure ми показва.

tedo96 · 19 Март 2011

Хммм.... Пробвай така.

PHP:

<?php session_start();?>
<html>
<head> <meta http-equiv="Content-Type" content="text/html; charset=windows-cp1251">
</head>   
<body>

<form action="login.php">
           <b>  Login</b><br/><br/>
          <span>Username</span><br/> <input type="text" name="loguser"><br/>
     <span>Password</span><br/><input type="password" name="logpassword"><br/>
     <input type="submit" value="Login">

<?php
$_SESSION['islogged']=FALSE;
$server='localhost';
$username='root';
$password='garchaviqgosho';
$db='users';
mysql_connect($server,$username,$password) or die (mysql_error());
mysql_select_db($db) or die (mysql_error());
$user=$_POST['loguser'];
$pass=$_POST['logpassword'];
$sql="SELECT * FROM `users`
WHERE `username`='$user' and `password`='$pass'";
$result=mysql_query($sql)or die (mysql_error());
$check=mysql_num_rows($result);
if ($check==1){
echo "Failure!";
}
else
{
echo "Success!";
}

?>

Nazi_93 · 19 Март 2011

Сега пък само Success...

tedo96 · 19 Март 2011

PHP:

<?php session_start();?>
<html>
<head> <meta http-equiv="Content-Type" content="text/html; charset=windows-cp1251">
</head>   
<body>

<form action="login.php">
           <b>  Login</b><br/><br/>
          <span>Username</span><br/> <input type="text" name="loguser"><br/>
     <span>Password</span><br/><input type="password" name="logpassword"><br/>
     <input type="submit" value="Login">

<?php
$_SESSION['islogged']=FALSE;
$server='localhost';
$username='root';
$password='garchaviqgosho';
$db='users';
mysql_connect($server,$username,$password) or die (mysql_error());
mysql_select_db($db) or die (mysql_error());
$user=$_POST['loguser'];
$pass=$_POST['logpassword'];
$sql="SELECT * FROM `users`
WHERE `username`='$user' and `password`='$pass'";
$result=mysql_query($sql)or die (mysql_error());
$check=mysql_num_rows($result);
if ($check!=1){
echo "Failure!";
}
else
{
echo "Success!";
}

?>

relax15pyt · 19 Март 2011

Я кажи, при регистрация криптираш ли паролата?

Защото, ако я записваш при регистрация с md5() трябва така да стане

PHP:

<?php 
session_start();
$server = "localhost";
$username = "root";
$password = "garchaviqgosho";
$db = "users";
mysql_connect($server,$username,$password) or die (mysql_error());
mysql_select_db($db) or die (mysql_error());
?>
<html>
<head> 
	<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>   
<body>

<form action="login.php">
	<b>Login</b><br/><br/>
	<span>Username</span><br/> <input type="text" name="loguser"><br/>
	<span>Password</span><br/><input type="password" name="logpassword"><br/>
	<input type="submit" name="submit" value="Login">
</form>
<?php
if(isset($_POST['submit'])){
	$user = $_POST['loguser'];
	$pass = md5($_POST['logpassword']);
	$query = mysql_query("SELECT * FROM `users` WHERE `username` = '{$user}' AND `password` = '{$pass}'") or die (mysql_error());

	if (mysql_num_rows($query) > 0){
		$_SESSION['islogged'] = true;
		echo "Success!";
	}
	else{
		$_SESSION['islogged'] = false;
		echo "Failure!";
	}
}

?>

Nazi_93 · 19 Март 2011

Не я криптирам както са си записани ги виждам в БД-то.

relax15pyt · 19 Март 2011

PHP:

<?php 
session_start();
$server = "localhost";
$username = "root";
$password = "garchaviqgosho";
$db = "users";
mysql_connect($server,$username,$password) or die (mysql_error());
mysql_select_db($db) or die (mysql_error());
?>
<html>
<head> 
        <meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>   
<body>

<form action="login.php" method="POST">
        <b>Login</b><br/><br/>
        <span>Username</span><br/> <input type="text" name="loguser"><br/>
        <span>Password</span><br/><input type="password" name="logpassword"><br/>
        <input type="submit" name="submit" value="Login">
</form>
<?php
if(isset($_POST['submit'])){
        $user = $_POST['loguser'];
        $pass = $_POST['logpassword'];
        $query = mysql_query("SELECT * FROM `users` WHERE `username` = '{$user}' AND `password` = '{$pass}'") or die (mysql_error());

        if (mysql_num_rows($query) > 0){
                $_SESSION['islogged'] = true;
                echo "Success!";
        }
        else{
                $_SESSION['islogged'] = false;
                echo "Failure!";
        }
}

?>

Така ?

EDIT: Промених малко кода, за това, ако си го копирал и пробвал, го копирай пак, и пак пробвай

Nazi_93 · 19 Март 2011

Еее благодаря много!! +1 може ли само да ми оцветиш в червено кое промени?

relax15pyt · 19 Март 2011

На формата ти липсваше method="post" , а като цяло кода, съм ти го фикснал малко, защото имаше някои пропуски.

tedo96 · 19 Март 2011

relax15pyt каза:
На формата ти липсваше method="post" , а като цяло кода, съм ти го фикснал малко, защото имаше някои пропуски.

:shock: как не го видях... Тагива елементарни грешки най-труднo ги откривам...

Nazi_93 · 19 Март 2011

eeeee винаги го пропускам тва пост :x а сега логаута със session_destroy() ли да го правя?

relax15pyt · 19 Март 2011

Ами...

PHP:

unset($_SESSION['islogged']);

PHP:

$_SESSION['islogged'] = false;

PHP:

session_destroy();

Което си избереш, хаха

Но първо прави проверки, дали е зададена сесия.

tedo96 · 19 Март 2011

PHP:

<?php
session_start();
session_destroy();
header('Location: index.php');
?>

relax15pyt · 19 Март 2011

tedo96 каза:
PHP:

<?php session_start(); session_destroy(); header('Location: index.php'); ?>

PHP:

<?php
if($_SESSION['islogged'] == false){
        header("Location: ...");
}
else{
        $_SESSION['islogged'] = false;
        header("Location: ...");
}
?>

Така по-добре

Само на многоточието си сложи къде да те праща

Отново проблем с логин...

Nazi_93

Registered

tedo96

Registered

Nazi_93

Registered

tedo96

Registered

Nazi_93

Registered

tedo96

Registered

relax15pyt

Registered

Nazi_93

Registered

relax15pyt

Registered

Nazi_93

Registered

relax15pyt

Registered

tedo96

Registered

Nazi_93

Registered

relax15pyt

Registered

tedo96

Registered

relax15pyt

Registered