help with sessions - Dev Articles

Dev Articles Community Forums Sponsor:

March 8th, 2003, 02:09 PM

pjp

Junior Member

Join Date: Jan 2003

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

help with sessions

i'am trying to update a login script to work with php version 4.3 and have come up with following but i can't gt it to work. i am new to sessions so any help would be appreciated.

authmain.php
<?
session_start();

if ($_POST['userid'] && $_POST['password'])
{
// if the user has just tried to log in

$db_conn = mysql_connect("localhost", "root", "choltas");
mysql_select_db("auth", $db_conn);

$query = ("select * from auth
where name='$_post[userid]'
and pass='$_POST[password]'");
$result = mysql_query($query, $db_conn);
if (mysql_num_rows($result) >0 )
{
// if they are in the database register the user id
$valid_user = $userid;

$_SESSION['valid_user'] = $userid;
}
}
?>
<html>
<body>
<h1>Home page</h1>
<?
if(isset($_SESSION['valid_user']))

//if (session_is_registered("valid_user"))
{
echo "You are logged in as: $valid_user <br>";
}
else
{
if (isset($userid))
{
echo "Could not log you in";
}
else
{
echo "You are not logged in.<br>";
}

member only.php

if(isset($_SESSION['valid_user']))
//if (session_is_registered("valid_user"))
{
echo "<p>You are logged in as $valid_user.</p>";

PHP Code:

<?

March 8th, 2003, 03:21 PM

Taelo

5B's

Join Date: Oct 2002

Location: PC, FL

Posts: 366

Time spent in forums: 2 h 30 m 59 sec
Reputation Power: 6

try this,...

PHP Code:


		
			
<?

session_start();



if ($_POST['userid'] && $_POST['password'])

{

// if the user has just tried to log in



$db_conn = mysql_connect("localhost", "root", "choltas");

mysql_select_db("auth", $db_conn);



$query = ("select * from auth where name='$_post[userid]' 

and pass='$_POST[password]'");

$result = mysql_query($query, $db_conn);

if (mysql_num_rows($result) >0 )

{

// if they are in the database register the user id

$_SESSION['valid_user'] = $result['userid'];

}

}

?>

<html>

<body>

<h1>Home page</h1>

<? 

if(isset($_SESSION['valid_user']))

{

echo "You are logged in as: $_SESSION['valid_user']<br>";

}

else 

{

echo "You are not logged in.<br>";

}



member only.php



if(isset($_SESSION['valid_user']))

{

echo "<p>You are logged in as $_SESSION['valid_user'].</p>";

}

__________________
-- Jason

March 8th, 2003, 05:32 PM

pjp

Junior Member

Join Date: Jan 2003

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

thank you for your response, i had updated my code which looked similar to what you posted but all that happens is that the username and password disappear and nothing else happens

any ideas why

March 8th, 2003, 06:01 PM

Taelo

5B's

Join Date: Oct 2002

Location: PC, FL

Posts: 366

Time spent in forums: 2 h 30 m 59 sec
Reputation Power: 6

let me explain how I do it,...maybe it will make more sense.

PHP Code:


		
			
if($_POST['Submit'] == "Submit")

{

     $errors = '';

     if(!isset($_POST['username'])) { $errors = "need a username"; }

     if(!isset($_POST['password'])) { $errors = "need a password"; }

}

then you do your query...

PHP Code:


		
			
 $find_user = mysql_query("select * from users where unsername='{$_POST['username']}' and password='{$_POST['password']}'");

if everything seems to be ok,..grab the array and set session vars.

PHP Code:


		
			
if(mysql_num_rows($find_user) = 1)

{

     $user = mysql_fetch_array($find_user);

     $_SESSION['user_id'] = $user['user_id'];

}

I think you are missing the main function here

PHP Code:


		
			
 mysql_fetch_array

PHP Code:


		
			
 mysql_fetch_row

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: