PHP Forum

**elena1234** · 03-29-2010, 11:18 AM

Hi All,
I'm beginner in php/mysql, I have created a login page where session is not working, please solve my problems, your suggestion would be appreciated.

Quote:

<?php
ob_start();
session_start();
$con=mysql_connect("localhost","root","");
$db=mysql_select_db("ram1");

if(!empty($_SESSION['user_name']))
{
header("Location: index.php"); exit;
}

if(isset($_POST['submit']))
{
$user=$_POST['username'];
$pass=$_POST['password'];
$password=$pass;
$sql=mysql_query("select * from admin where user_name='".$user."' and user_pass='".$pass."'");
if(mysql_num_rows($sql)>0)
{
$data=mysql_fetch_array($sql);
$_SESSION['user_id']=$data['admin_id'];
header("Location: index.php"); exit;
}
else{
$msg="login with username and password";
}
}
?>

<body>
<form action="" method="post">
<table border="1" cellpadding="0" cellspacing="0" align="center">
<tr>
<th>Username:</th><th><input type="text" name="username"/></th>
</tr>
<tr>
<th>Password:</th><th><input type="text" name="password"/></th>
</tr>
<tr>
<th><input type="submit" name="submit"/></th></tr>
</table>
</form></body>

**lynxus** · 03-29-2010, 11:31 AM

Try putting session_start(); above obj_start(); ?

What errors do you get in /var/log/httpd/error ( or where ever you have your httpd error log )

**elena1234** · 03-30-2010, 01:15 AM

I have try as you told us, our code is not showing any error, but session is not create for users.

Quote:

Originally Posted by lynxus

Try putting session_start(); above obj_start(); ?

What errors do you get in /var/log/httpd/error ( or where ever you have your httpd error log )

**adam89** · 03-30-2010, 04:14 AM

So what exactly does happen?

Try changing:

PHP Code:


			
$msg="login with username and password";

To:

PHP Code:


			
echo "login with username and password";

If that message is displayed then I imagine the problem lies with your query. Failing that ensure you have error reporting enabled, add this to the top of your code:

PHP Code:


			
error_reporting(E_ALL);
ini_set('display_errors', 1);