Users querying membership database and posting updates?

[gbergan52]

Hi,

I already have a site I built for a client with DreamWeaver CS4. Now the client wants a "members only" area where the members can log in (registering first), query their contact information from our membership database, and update it if need be. Of course they can't be able to see anyone else's information. I have already installed WAMP and created a mySQL database,  imported it into phpMyAdmin, etc. It already has all member info except passwords. I have  set up the server information and connected my members-only page to the membership database.

I can find a solution out there for registering users, creating passwords, logging in, etc. What I need is: how, once the member is logged in, how do I have them query their own, and only their own, contact info and post updates? I have gone through Lynda.com training courses but they don't seem to address this specific need. Thanks for pointing me in the right direction.

Gail

[bregent]

You simply need to query the database user table using the members id (usually stored as a session variable) in the where clause. You can try using DW's update record server behavior for this. Make sure you do not include the member id in the querystring.

[gbergan52]

I'll need to go through this step by step. When I try to add the

initial recordset (rsUsers) to my page, selecting FirstName down to

Phone, no sorting or filtering, I get the error message "node has no

properties". Ugghh...do you know what this means and how to fix?

Gail

[gbergan52]

I was able to find the solution to this: apparently some bad code in

the page. Starting with a fresh page solved the problem.

Gail

[bregent]

Excellent!

[gbergan52]

OK, next issue. When adding the Record Update Form to my page, I have

selected userID as the unique key column. I have also designated

userID as the primary/unique/index keys in my database in phpmyAdmin.

(The column is set as an integer and auto-increment is turned on.)

Yet when I click OK in the record update form dialog box, it asks me

to "please choose a unique key fro the selected recordset, or click

Cancel." If I already have it set as the unique key in my database,

why isn't DM recognizing it as such?

Sorry for all these inane questions; I've never done this before.

Gail

[gbergan52]

Still not getting this to work. I rebuilt my database and set the

correct column to be PRIMARY/UNIQUE, so that part is solved. Using

the Update Record wizard, I can display a blank table with the

specific fields I want to update, but no member info in the table.

(If I go to the browser window and append the URL with a specific

userID, I can get it to retrieve one member's info.) The Update

Record Wizard itself does not have a WHERE clause. Do I need to add

another query or server behavior to this same page?

The members will be logging in using their email address, not the

userID (primary key). So I somehow need to retrieve a single member's

data based on their email address, then have them update their info

and echo the new information on a new (or the same) page before

confirming the changes.

Any help would be greatly appreciated.

Gail