PHP - Moved: Code To Add Background Music For Website

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=321745.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=358814.0

This topic has been moved to Apache HTTP Server.

http://www.phpfreaks.com/forums/index.php?topic=320065.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=307157.0

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=351877.0

This topic has been moved to Editor Help (Dreamweaver, Zend, etc).

http://www.phpfreaks.com/forums/index.php?topic=306796.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=306808.0

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=351796.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=354184.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=316359.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=322256.0

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=355225.0

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=319094.0

Hi Guys. Really Stuck here. I am making a website, its basicall an online shop of sorts. I am making a login page for our customers and an admin page for us lot to upload new products to sql etc. Whats its meant to do is accept the username and pw then allow me to access the adminpage. Although its just saying that user doesnt exist all the time. I dont know why becuase the details are correct.

admin_login page is the code below.

<?php
session_start();
if(isset($_SESSION["manager"])){
header("location:index.php");
exit();
}

?>
<?php
if(isset($_POST["username"])&&isset($_POST["password"])){

$manager = preg_replace('#[A-Za-z0-9]#i','',$_POST["username"]);
$password = preg_replace('#[^A-Za-z0-9]#i','',$_POST["password"]);

include"../storescripts/connect_to_mysql.php";
$sql = mysql_query("SELECT id FROM admin WHERE username='$manager' AND password='$password' LIMIT 1");

$existCount = mysql_num_rows($sql);
if($existCount == 1){
while($row = mysql_fetch_array($sql)){
$id = $row["id"];
}
$_SESSION["id"] = $id;
$_SESSION["manager"] = $manager;
$_SESSION["password"] = $password;
header("location: index.php");
exit();
}else{
echo 'That Information Is Incorrect. Try again <a href="index.php">Click Here</a>';
exit();
}
}


?>


and now the index.php which is what the admin see when they log in successfully.

<?php
session_start();
if(isset($_SESSION["manager"])){
header("location: admin_login.php");
exit();
}
//Be Sure To Check That This Manager Session Value Is Infact In The DataBase
$managerID = preg_replace('#[^0-9#i','',$_SESSION["id"]);
$manager = preg_replace('#[^A-Za-z0-9]#i','',$_SESSION["manager"]);
$password = preg_replace('#[^A-Za-z0-9]#i','',$_SESSION["password"]);

include "../strorescripts/connect_to_mysql.php";
$sql = mysql_query("SELECT * FROM admin WHERE id='$managerID' AND username='$manager' AND password='$password' LIMIT 1");

$existCount = mysql_num_rows($sql);
if($existCount == 0){
header("location:../index.php");
exit();
}

?>

This topic has been Ctrl+X/Ctrl+V'd to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=347400.0