non working session variable

Question

Can anyone please tell me why this session variable isn't being set? When the login details are correct the offers page is re-directing users back to the index as though the session variable isn't set.

<?php
session_start();

$username = $_POST['username'];
$password = $_POST['password'];

mysql_connect("localhost", "******", "******") or die("Could not connect.");
mysql_select_db("*******") or die("Could not find database.");

if(($username=='')||($password==''))
{
echo"<script type='text/javascript'>;
alert('Please check and re-enter details');
window.location = 'index.php';
</script>";
}
$qry="SELECT*FROM login WHERE username = '$username' and password = '$password'";
$result=mysql_query($qry);

if(mysql_num_rows($result)==0)
echo "<script type='text/javascript'>;
alert('The username you have entered does not exist in our database.  Please check ad re-enter details.');
window.location = 'index.php';
</script>";

if(mysql_num_rows($result)> 0)
{
$_SESSION['username'] = $username;
header('location: offers.php');
}
?>

offers.php code

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

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. — Kermit
– Kermit, Commented Feb 27, 2013 at 14:44
Thankyou - Aarolama, so do i just replace mysql with mysqli then in the instances i have it above? — maccame
– maccame, Commented Feb 27, 2013 at 15:07

Matt Cain · Accepted Answer · 2013-02-27 14:45:49Z

2

You need to put session_start(); at the top of your offers.php page.

answered Feb 27, 2013 at 14:45

Matt Cain

5,7683 gold badges39 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Husman · Accepted Answer · 2013-02-27 14:45:51Z

1

Try adding:

session_start();

to the top of offers.php

answered Feb 27, 2013 at 14:45

Husman

6,93910 gold badges32 silver badges48 bronze badges

Collectives™ on Stack Overflow

non working session variable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related