Hi Naintara,

thanks for your code could you please advice why is the code giving this
error.

"Parse error: syntax error, unexpected T_ISSET in
/path/submit-store-details.php on line 4"

This is coming when I am trying to use your code like this:

<?
session_start();
$_SESSION['email'] = 'emailAddress';
if(!empty($_SESSION["email"]) isset ($_SESSION["email"]));
{
header("location:store-login.php");
}
?>

and then retrieving it in SQL query:

$query="SELECT * FROM table WHERE email =
'".mysql_real_escape_string($_SESSION['email'])."'";

Many thanks.

Chris

Chris Carter wrote:
> 
> 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
> 
Quoted from: 
http://www.nabble.com/How-to-capture-from-session-and-match-database-tf4478519.html#a12770056


Chris Carter wrote:
> 
> 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-tf4478519.html#a12847962
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

Reply via email to