[RESOLVED] Newbie working with Sessions & Database

Nielubie

I"m a noob and I'm working on a basic family site. I have the login, registration all setup and now I would like to allow users to edit the information after registering.

My question is, how do I go about in making a EDIT page with MySQL using Sessions? I have a session open that's called user_ID and I'm able to get the session "first_name" to display on all pages, but I'm having a hard time getting the rest of the information like address, phone, email to open back up.

I think I have to use a query using a loop to populate some variables from the database, but I really have no idea how to start with it. I have three books infront of me for reference and none of them are really clean in helping me how to open a database once someone is already logged in with session.

Please help if you can.
Thank you,

bogu

Well to extract information from your database u need to use SELECT and since u have your user_id kept in sessions it shouldn't make any problem ...

Nielubie

Thank you for the quick reply.

I am aware of the SELECT statement and I am able to retrieve data in the actual database, but I'm having problems with the logic of how to put the data from the database into my form.

For example, I have a database with user_id, first_name, last_name, password, email, address, address1, phone, etc.

And I have a form for all theses fields. When the user registeres, they enter the first_name, last_name, email and password. But once they login, I'd like them to be able to edit all fields and enter the address, phone, etc. By Default, I'm looking to populate the form with the data that is already in the database but I have no clue how to start. This way, the form is already populated and they only need to enter the data that needs to be changed.

bogu

If u know how to extract the data from DB, then I dont see the problem here:

<?php
/* query the DB */
$firstname = "Firstname"; // taken from DB
?>
Firstname: <input type="text" name="txtF" value="<?=$firstname;?>" />

and voila u have your field populated with the user firstname taken from DB ...