[SOLVED] Echoing a mysql cell?

[Snooble]

Hello everyone,

I want to show the user his/her email address they signed up with. It's stored in a database.

how would i echo their email to them once they're logged in with thier username and password?

The field is called "Email".

Is that understandable? Just like:

Once the user is logged in it should show there email where it once said "log in". I believe it should be a isset(); or if statement. But i'm not sure.

Thanks

Snooble

[trq]

Post the code you have for logging in a user.

[Snooble]

[code]<?php
$host="**********"; // Host name
$username="********"; // Mysql username
$password="**********"; // Mysql password
$db_name="************"; // Database name
$tbl_name="web_members"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from signup form
$myemail=$_POST['myemail'];
$mypassword=$_POST['mypassword'];

$sql="SELECT * FROM $tbl_name WHERE Email='$myemail' and Password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myemail and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $myemail and redirect to file "login_success.php"
session_register("myemail");
session_register("mypassword");
header("location:login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>
[/code]

I believe that is what you want.

[Jessica]

print $_SESSION['myemail'];

session_register is deprecated, use $_SESSION['myemail'] = $email; instead.

[Snooble]

thank you. I heard about it being depreciated but "if it works dont fix it" but i will now you have given me the alternative.

I prefer echo. I heard it works a point of a second faster lol :)

Good old lynda.com

Snooble

[Snooble]

also, sorry to double post but i need some code that checks whether the user is logged in. What would it be?

Snooble

Thanks

[Jessica]

Why don't you try to write some first and then we'll help when you get stuck. You'll need to use
if($condition){
//do
}else{
//do this
}

[Snooble]

I need to know the condition. I know very basic if else stuff but i dont know the condition name for being logged in.

Snooble

[Jessica]

When they login, set their username in the session, then check to see if the session variable exists.
$_SESSION['username'] = $username;
then
if($_SESSION['username'])

[Snooble]

thank you