Re: How to capture from session and match database

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.