Hi,
First of all, where you are storing the session variable, it should be
specified as:
$_SESSION['email'] = 'email value' //PHP 4.1.0 onwards
This is preferred to registering global variables. There's a whole lot of
discussion on why.
On the pages you are authenticating, you would correspondingly check for a
value in $_SESSION['email']
!empty($_SESSION['email']) isset($_SESSION['email']) etc, depending on you.
When you code for the session logout, you need to look up the php manual
for session_destroy().
When you would like to retrieve data for a user, you can get the details by
using code like this:
$query="SELECT * FROM table WHERE email = '".
mysql_real_escape_string($_SESSION['email']). "'";
I would suggest you read up a good tutorial on php + mysql
I am not sure why there are curly braces after mysql_close(); or where you
are setting values to $i
mysql_close();
{
$shopname=mysql_result($result,$i,"shopname");
$category=mysql_result($result,$i,"category");
}
The best thing would be to first understand sessions, set variables, echo
values, destroy variables, and then test the sql.
-----Original Message-----
From: Chris Carter [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 19, 2007 8:34 AM
To: [email protected]
Subject: [PHP-DB] How to capture from session and match database
Hi,
I have this session code on each page and this is working fine for
authentication:
<?
session_start();
if(!session_is_registered(email)){
header("location:store-login.php");
}
?>
Now I wish to
1)capture the value (userName) from session on one of my pages and
2)match it with the database and
3)display the value in the textfields
This is the code I am using to do this please:
include "../includes/malls_db_conf.php";
$query="SELECT * FROM table WHERE email = '$email'"; <---- Here I am
capturing from the session
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
{
$shopname=mysql_result($result,$i,"shopname");
$category=mysql_result($result,$i,"category");
}
?>
Showing in the textfield from the database is working fine
THE Problem is:
I am getting only the first row of table to show up and not the one with
the
field $userName, meaning the userName is not getting captured from the
above
or checking with the table and showing me the value.
It might be a basic one, could you please advice how to achieve that.
Cheers,
Chris
--
View this message in context:
http://www.nabble.com/How-to-capture-from-session-and-match-database-tf4478
519.html#a12770056
Sent from the Php - Database mailing list archive at Nabble.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
