[RESOLVED] please help me......php+mysql

[chandan_tiwari]

what is wrong with this page.
wherever i'm including this file the page is not opening. It's giving 404 http not found error. Please let me know what is wrong :

<?php
include_once 'common.php';
include_once 'db.php';
session_start();
if(isset($_POST['uid'])){
$uid = $_POST['uid'];
}
else
{
$_SESSION['uid'];
}
if(isset($_POST['pwd']))
{
$pwd = $_POST['pwd'];
}
else
{
$pwd = $_SESSION['pwd'];
}

if(!isset($uid))
{
header("Location:http://www.rishijyotishsanstha.org/login.php");
}
$_SESSION['uid']=$uid;
$_SESSION['pwd']=$pwd;
dbconnect("members");
$sql="SELECT * FROM user WHERE userid = '$uid' AND password = PASSWORD('$pwd')";
$result=mysql_query($sql);
if(!$result)
{
 error('A database error occured while checking your login details.\\n If this error persists please contact [email][e-mail][/email]');
}
if(mysql_num_rows($result)==0)
{
unset($_SESSION['uid']);
unset($_SESSION['pwd']);
header("Location:http://www.rishijyotishsanstha.org/accessdenied.php");
exit;
}
$username=mysql_result($result,0,'firstname');
?>

[dougal85]

I guess one of the pages you are sending the user too with the header function doesn't exist.

Check the urls are correct.

[severeheadache]

ok, I tried both URLs. The accessdenied.php file does not exist off the webroot. Check your URL there. The login.php does work (no 404) but I noticed a flaw in your logic:

if(isset($_POST['uid']))
{
     $uid = $_POST['uid'];
}
else
{
     $_SESSION['uid'];
}

Here, in the else block, that will do nothing. I think you meant:

if(isset($_POST['uid']))
{
     $uid = $_POST['uid'];
}
else
{
     $uid = $_SESSION['uid'];
}

Also, you might want to know that to destroy session variables, you must call session_unregister() not unset() on the $_SESSION array.

Hope this helps,

Mike

[chandan_tiwari]

it works !

thank you very much, i got my mistake.

[bradgrafelman]

When posting PHP code, please use the board's [PHP][/PHP] bbcode tags - they make the code much, much easier to read (as well as aiding the diagnosis of syntax errors). You should edit your post now and add these bbcode tags to help others in reading/analyzing your code.

Also, don't forget to mark this thread resolved.