user login

[[deleted]]

hi, here are my login scripts:

<?
include("admin/db.php");

session_start();
$db_user = '';
$db_pass = '';
$nickname = $_POST['nickname'];
$password = $_POST['password'];

//connect to the DB and select the "single" database
$connection = mysql_connect('localhost', $db_user, $db_pass) or die(mysql_error());
mysql_select_db('single', $connection) or die(mysql_error());

//set up the query
$query = "SELECT * FROM sin_members 
		WHERE nickname='$nickname' AND password='$password'";

//run the query and get the number of affected rows
$result = mysql_query($query, $connection) or die('error making query');
$affected_rows = mysql_num_rows($result);

//if there's exactly one result, the user is validated. Otherwise, he's invalid
if($affected_rows == 1) {
	$_SESSION['nickname'] = $nickname;
	header("location:myaccount.php");

}
else {
	header("location:index.php");
}

?>

But, when i compile this file, error occurred:

Warning: open(windows\tmp\sess_b891369a29d4437b3c6f93d5e047291f, O_RDWR) failed: No such file or directory (2) in C:\HTTPD\HTDOCS\single\memberlogin.php on line 4

Warning: Cannot add header information - headers already sent by (output started at C:\HTTPD\HTDOCS\single\memberlogin.php:4) in C:\HTTPD\HTDOCS\single\memberlogin.php on line 29

Warning: open(windows\tmp\sess_b891369a29d4437b3c6f93d5e047291f, O_RDWR) failed: No such file or directory (2) in Unknown on line 0

Warning: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (windows\tmp) in Unknown on line 0
😕

Can anyone pls help me? i have set session.save_path = windows\tmp in php.ini. i am using local omnihttpd to run this file.

pls help out!!!!!

[HalfaBee]

You should probably make it c:\windows\tmp assuming you have a tmp dir.

HalfaBee

[TTT]

and maybe there is no permission to write / read (win/tmp)

[HalfaBee]

Does windows have that option?

HalfaBee

[[deleted]]

how can i set the permission for window/tmp? i still face the same problem after i change it to 'windows/tmp'. What's wrong with it?

thank you.

[[deleted]]

hey, guys, now i am facing another problem.

ok, i have set the path to "windows\temp".

when i access the page for first time, i can successfully login. but, when i tried to login for second time, the same error as above came out again.

can i know what is wrong? thank you very much.

[HalfaBee]

Try putting c:\windows\temp in

it may be looking from the current dir and not find ing it.

HalfaBee

[[deleted]]

thanks a lot. it works now.

😃

[[deleted]]

sorry for disturbing again.

i am not good in login scripts.

after i login, i will come to index.php with this line:

welcome watermelon

but, when i change another user, it still come out:

welcome watermelon

can i know what's wrong?

here is the file:

---

index.php

<?
session_start();
if (isset($SESSION['nickname'])) {
echo 'Logged in as '.$SESSION['nickname'].', <a href="logout.php">logout</a>';
} else {
echo 'Not logged in. <a href="login.php">Login</a>';
}
?>

thanks.

[HalfaBee]

Are you unsetting the $_SESSION variables and using session_destroy to logout the user?

HalfaBee

[[deleted]]

so, u mean everytime i need to do session destroy to logout the user? am i right?

what if i want to set cookie on it? let say i want the session ends after 30 minutes. is it possible for us to do it?

thanks.

[HalfaBee]

Yes.

Have a look at
void session_set_cookie_params ( int lifetime [, string path [, string domain [, bool secure]]])

in the manual.

HalfaBee