I have the following code…I want to be able to echo various variables from the user info in mysql, so I tested it with the username. Once I login with the test username and password, the variable is not echoed.
Can you please tell me what I am doing wrong?
[php]<?php
// Connects to your Database
mysql_connect(“mydbhost”, “mydbusername”, “mydbpassword”) or die(mysql_error());
mysql_select_db(“mydbtable”) or die(mysql_error());
//checks cookies to make sure they are logged in
if(isset($_COOKIE[‘ID_my_site’]))
{
$username = $_COOKIE['ID_my_site'];
$pass = $_COOKIE['Key_my_site'];
$check = mysql_query("SELECT * FROM users WHERE username = '$username'")or die(mysql_error());
while($info = mysql_fetch_array( $check ))
{
//if the cookie has the wrong password, they are taken to the login page
if ($pass != $info['password'])
{ header("Location: login.php");
}
//otherwise they are shown the admin area
else
{
echo "Welcome, " . $_SESSION[‘username’] . " ";
echo “other Content
”;
echo “Logout”;
}
}
}
else
//if the cookie does not exist, they are taken to the login screen
{
header(“Location: login.php”);
}
?>[/php]