login >> Help please!!

[3yoon_af]

[FONT="Comic Sans MS"]I want to know how to can i check if the user name and the password is correct as they are in the database?

I write this code but it is not work :mad: [/FONT]

<?php
include("redirect.php");
include("connect.php");
$user_name=$POST['user_name'];
$password=$POST['password'];

     $sql = "SELECT * FROM register_info where user_name = '".mysql_real_escape_string($user_name)."'  && password = '".mysql_real_escape_string($password)."' ";

     $result = mysql_query($sql)or die ("could Not execute query $sql");
     $count = mysql_num_rows($result);
     if ($count==1){
         session_register("user_name");
         session_register("password");
         header("location:login_success.php");
     }else {
         echo "Wrong Username or Password";
     }
     ?>[/QUOTE]

[FONT="Comic Sans MS"]In the login_success.php[/FONT]

<?php
session_start();
if(!session_is_registered(user_name)){
header("location:login_form_stud.php");
}

     ?>[/QUOTE]

[FONT="Comic Sans MS"]Can any one help me, please ?[/FONT]

[cahva]

In the first script you are missing session_start() from the beginning. Also using session_register() is deprecated. Just use $SESSION to set session variables. For example:

$_SESSION['username'] = $username;

And when you check if session variable is set:

if (isset($_SESSION['username'])) {
...

If it doesnt work still, give us some error to look at 🙂

[3yoon_af]

if (isset($_SESSION['username'])) {
...

please I want to know what the benefit from this code and how it work?

[3yoon_af]

It give an error

Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\job\login_engine.php:17) in C:\AppServ\www\job\login_engine.php on line 30

in line 30 which is

header("location:login_success.php");

if ($count==1){
$SESSION['user_name']= $user_name;
$SESSION['password']= $password;
header("location:login_success.php");
}else {
echo "Wrong Username or Password";
}

Can anyone help, please?

[cahva]

Dont output anything before using header function. And that means anything: new lines, txt etc. As you can see in the error, the output has started on line 17 in login_engine.php. Put all those which would redirect to some other page at the start of your script(and remember, no output at all before that).

please I want to know what the benefit from this code and how it work?

Simple, you check with isset if variable is set 🙂 And if variable (in this case $_SESSION['username']) is set, execute the code.

BTW, why do you need to initialize the password to session? Usually thats not what you need to do. Even better would be that you only store the user id to session. Thats how its normally done.