Skip to main content
G
Gail Bergan
Inspiring
June 10, 2010
Question

Users querying membership database and posting updates?

  • June 10, 2010
  • 1 reply
  • 1072 views

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

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
June 10, 2010

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.

G
Gail BerganAuthor
Inspiring
June 10, 2010

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices