echo a field

devil_online

Hi, I've create a login form in php, where users can put their name, pass and team. How can I creat a wellcome message, like "wellcome 'user' you team is X." In other words I want to retreive information of the mysql table in echo in the page.

function displayLogin(){
   global $logged_in;
   if($logged_in){
      echo "<h1>Logged In!</h1>";
      echo "well come <b>$_SESSION[username], your logged. <a href=\"logout.php\">Logout</a>";
   }
   else{

Thanks

Shrike

You'll need to be a little more specific about the application logic and the database schema.

devinemke

your function suggests that you are putting the data retrieved from the db into a session, right? if so then you function should work fine except your forgot quotes around your array index:

use $SESSION['username']
instead of $SESSION[username]

devil_online

your function suggests that you are putting the data retrieved from the db into a session, right? if so then you function should work fine....

yes it works fine..however it display the username ($_SESSION[username]) but I want to display the team of the player, (choosen in the form)

thanks

fire_cracker

Asuming you are using some sort of submit on the form, you can display it by pulling it out of the $POST[] or $GET[] variables. If the form is being submitted to this page via post for example, you can do like this:

echo "Welcome " . $_SESSION['username'] . ". You are on the " . $_POST['team'] . " team!";

Or something simmilar.

devil_online

well I want that the script get the information on the database that i've inserded the data. in this case the name of my team. And for each user it gets the same way, to get the infomation of his team. Thanks

devil_online

when i put
echo $team;

it says the vayriable is not defined....

my code

Shrike

Originally posted by Shrike
You'll need to be a little more specific about the application logic and the database schema.

:glare:

devil_online

well I just want to get the value of the data base, inserted in the register form. I want also the that value is the user value.
thanks

tuf-web_co_uk

what shrike is trying to tell you is that you need to get the team name from the database using the login name as a where clause.

then put this into a variable which can then be echoed like $_SESSION['username']

you must have already attempted to select a row from a table using the username, to verify the login, so all you need to do is store the array, and echo the team $row['team'] (or similar)