View Single Post
Old 05-06-2005, 07:00 AM   #29 (permalink)
DJMaze
Senior Contributor
 
DJMaze's Avatar
 
Join Date: Mar 2005
Posts: 704
DJMaze is on a distinguished road
another way is to use $_SESSION for containers like:
PHP Code:
if (!session_is_registered('tutor')) {
    
session_register('tutor');
    
$_SESSION['tutor']['nickname'] = 'johndoe'// login name
    
$_SESSION['tutor']['password'] = 'fgrhjt4095dgfg'// encrypted
    
$_SESSION['tutor']['realname'] = 'john doe';
    
$_SESSION['tutor']['age'] = 15;

You can easily assign with a DB query as well
PHP Code:
if (!session_is_registered('tutor')) {
    
session_register('tutor');
    
$result mysql_query("SELECT * FROM tutors WHERE nickname='$nickname' AND password='$password'");
    if (
$row mysql_fetch_assoc($result)) {
        
$_SESSION['tutor'] = $row;
    } else {
        die(
'Username or password is incorrect');
    }

Or using PHP >= 4.3.0
PHP Code:
if (!session_is_registered('tutor')) {
    
session_register('tutor');
    
$result mysql_query("SELECT * FROM tutors WHERE nickname='$nickname' AND password='$password'");
    if (
$row mysql_fetch_object($result)) {
        
$_SESSION['tutor'] = $row;
    } else {
        die(
'Username or password is incorrect');
    }

The difference between mysql_fetch_object() and mysql_fetch_assoc() is the way how you read the data.
PHP Code:
$row mysql_fetch_object($result);
echo 
$row->nickname;

mysql_fetch_assoc($result); // keyed array
echo $row['nickname'];

mysql_fetch_row($result); // numeric array
echo $row[0];

mysql_fetch_array($result); // numeric and keyed array
echo $row[0];
echo 
$row['nickname']; 
DJMaze is offline   Reply With Quote