need more help

aznjay

this is my login proccess i call it getin.php

<? 
$conn = mysql_connect("localhost","chaotici_commu",""); 
$db = mysql_select_db("chaotici_chaotic"); 

$result = MYSQL_QUERY("SELECT username, password from users WHERE username='$username' and password='$password'") or die ("Name and password not found or not matched");
$worked = mysql_fetch_array($result); 
$user = $worked[username]; 
$password = $worked[password];
$html = $_POST['edithtml'];



if($worked)
echo "Welcome $user";
echo "<br>";
echo $_SERVER["REMOTE_ADDR"];
echo "<br>";
echo $_SERVER["HTTP_REFERER"];

?>

This is the login.html for the proccess of logging in.
<form action="getin.php" method="post">
Username: <input type="text" name="username" size="10">
Password: <input type="password" name="password" size="10">
<input type="submit" value="submit" name="submit">
</form>

This is the post where in the textarea gets processed into the mysql database. this edithp.php

<?
$link = mysql_connect('localhost','chaotici_commu', 'dragon')
    or die("Could not connect");
mysql_select_db('chaotici_chaotic')
    or die("Could not select database");

$result = MYSQL_QUERY("SELECT username FROM users WHERE username='$username'") or die ("Username not matched");
$worked = mysql_fetch_array($result); 
$user = $worked[username];
$html = $_POST['edithtml'];



mysql_query($update) or die ("Could not add data to the table");


?>

This is the form for the edithp.php at the top. I call this text.html

Here's my problem, I'm trying to combine the two and i'm having some reall hard trouble. See when the user logs in they go to the page of getin.php right. So i used the include tag to put my text.html. The $user is not showing the username in

$update ="UPDATE users SET html='$html' WHERE username='$user' LIMIT 1";

so it will post the typed in data to the mysql database. I change the username='$user' into the username='aznjay' that is my username right and it works. Please help me with the $user thing and how i can combine this.

swr

I think I see what is going on...

In the login page you get the user name. But that
is not stored in a session, so it does not carry
across to the next page.

On the next page you have this:

$result = MYSQL_QUERY("SELECT username FROM users WHERE username='$username'")
or die ("Username not matched");

You have something similar in the login page. Thing
is, it's not going to die when the username is not
matched. The query will succeed, but it will return
zero rows, because $username is not set (it was
set on the previous page, but not the current
one).

So the script continues along even though
$username not set. Then you get to setting
$update, and $username is still not set, so the
update doesn't do anything.

The root of your problem is that $username,
which was set in the login page by a form variable,
is not carried over on to other pages.

If you want variables to be carried from one page
to another, you either need to set the values in
hidden form fields (so that the values will be
resubmitted) or use a session. Even then, only
specific variables will be carried over.

Start here:
http://www.php.net/manual/en/ref.session.php

aznjay

hey how do you use the session thing???:rolleyes: :rolleyes:

swr

I gave you a link already, although this is probably a
better starting point (with an actual example):
http://www.php.net/manual/en/function.session-start.php

aznjay

I"m really really confused about this seesion thing. Can you show me how'd you put it together with the scripts that I post. AIM on aznjay2x

Weedpacket

Originally posted by aznjay
I"m really really confused about this seesion thing. Can you show me how'd you put it together with the scripts that I post. AIM on aznjay2x

What's confusing?
1) put session_start(); at the top of each script where you want to use session data.

2) Use the $_SESSION[] array to store your session data.

aznjay

THANK YOU VERya MUCH SO MUCH