/    Sign up×
Community /Pin to ProfileBookmark

Updated membership information

Copy linkTweet thisAlerts:
Sep 20.2006

Hello,
I have registered users and there is also link to update information for users if they like. do you know how to do it correctly? Problem is, that user has its own e-mail and username with password. When user click on My account they will get their information in account. In db should be only one username and e-mail. How to do it that user will not change his e-mail and username? Is possible without input field. Just text?

to post a comment
PHP

4 Comments(s) ↴

Copy linkTweet thisAlerts:
@nooor83Sep 20.2006 — as far as i undestood,

for each user should a userid ( or a username and that is a primary key) and when updating the information u should use the where cluase that is,

"update users set email='[email protected]' where userid='userid'"

and like that you can update the users info

hope it helps

Regards,

Noor
Copy linkTweet thisAlerts:
@toplisekauthorOct 25.2006 — Hello,


User has Account page for changing his account information.

Username and e-mail can be just one in db.

Input box will not be shown for username (can not be changed) but e-mail input box will be possible (user can change his e-mail). So, user decides not to change his e-mail address. Post variable will be the same as in db. Validation report will detect this and report error as following: e-mail address is already in use.

Do you know how to fix this?

If there will not be control of e-mail, other user will put the same e-mail and this should not happen. I hope I was clear as much as possible.
Copy linkTweet thisAlerts:
@theRamonesOct 26.2006 — 
  • 1. is the new email had been registered by other user

    (select email from user where email='new_email')

  • 2. if true, report that the new email is already in use,

    if false, update the new email of the user
    • Copy linkTweet thisAlerts:
    @toplisekauthorOct 27.2006 — Hello,

    problem is that in this case if user has its own e-mail and he decides to have the same one it will report e-mail is already in use because he will find this past e-mail in db under user. How should I avoid this?

    Need help
    ×

    Success!

    Help @toplisek spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 — BETA 5.28,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @AriseFacilitySolutions09,
    tipped: article
    amount: 1000 SATS,

    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,
    )...