How to provide user Edit Profile option?

I am creating a database-driven Web page to display member information for an organization to which I belong. I want to allow members to edit/modify most of the information for their individual profiles.

I have the basic MySQL database and PHP Members page created and working the way I want. What I want to do is add an option for each member to edit his/her own profile. I am not sure the best way to go about this with PHP, but I have considered a couple different options:

(Preferred) Add a link that appears only on the entry for the member viewing the page. I assume this would require a cookie to identify the person viewing? But on what basis? What would be the best mechanism to use for the "Edit Profile" link to appear only on that member's entry? Is it even possible?
(Probably more practical) Have the "Edit Profile" link appear on each member's entry, and use a password option so that only the member who "owns" that entry can actually change it. This, I think, would be less attractive, but easier and more doable, yes?

Are there other options or possibilities that I have not considered?

I should probably add that I am really new to all this MySQL and PHP stuff, and although I have already learned a lot, I know I have a WHOLE LOT MORE to learn! I am still very much a newbie!

Any tips or guidance will be GREATLY appreciated!

Thanks!
Chuck

Nov 27 '10 #1

Subscribe Post Reply

25861

Curtis Mattoon

How do you authenticate users? Some will disagree with me on this, but I use the $_SESSION array to store user info.

Basically, the login script sets $_SESSION variables, such as username, email, or other frequently-accessed information.
Let's say for this example, we stored $_SESSION['USERID'], which is a unique ID in the database, and $_SESSION['USERNAME'], which should be unique as well.

Create "edit-profile.php", and create a blank form with the fields you would like to edit (name, address, email, etc). I'll just use "email" as an example here.

Expand|Select|Wrap|Line Numbers

 
<?php
 
$sql = mysql_query("SELECT * FROM users WHERE userid='$_SESSION['USERID']' LIMIT 1");

while($row = mysql_fetch_assoc($sql)){

    $email = $row[email];

    //--repeat for each field you want to edit

}

?>
 
<html>

<form name="editprofile" action="process.php" method="post">
 
E-Mail Address: <input type="text" name="email" value="<?=$email; ?>" />
 
//-repeat for each field

</form>

All this does is create a form, inputs the existing values (from the database) into the form. Process.php will handle putting the new data back into the database. This form will work for all users, as it will only put info from the database WHERE userid= the stored ($_SESSION) user ID.

Nov 27 '10 #2

by: givlerj | last post by:

I need some help. Here is a little background, I support a MS Access 2k DB (SQL Server 2k backend) that has courses and students. The problem form lets the user pick a course from a drop down and...

Microsoft Access / VBA

How can I let the user edit multiple rows at a time?

by: ad | last post by:

I use DataGrid in my web application for editing data. But the DataGrid can edit one row at a time. How can I let the user edit multiple rows at a time?

ASP.NET

.NET application switching users (user A is shown user B profile)

by: Bhaskar | last post by:

I have a serious problem in .NET currently. I am hoping somebody out there can help me. I have a ASP.NET application written in VB.NET and requires the user to log in. I authenticate user using...

ASP.NET

User Registry - Profile Info

by: Matteo Basei | last post by:

How can I edit the windows registry obtained from PROFILEINFO.hprofile pointer? I have obtained the struct PROFILEINFO with LoadUserProfile(token,PROFILEINFO).

Visual Basic .NET

optparse -- anyway to find if the user entered an option?

by: Karthik Gurusamy | last post by:

Hi, I see that I can provide a default value for an option. But I couldn't find out any way if the user really entered the option or the option took that value because of default. A simple check...

Python

Creating a User Registration/Profile system

by: anacool | last post by:

HI! Everybody.. I have made my webpage using Html and php code but now i want to add a page in which viewers can register and view their profile. i would appreciate,if any one could guide me to...

PHP

Set User Account Profile?

by: lkjhgfdsa | last post by:

Hi I create a user account in active directory and set the profile value (fill the "homedirectory" and "homedrive" properties and update user account). When I do this steps in "Active Directory...

.NET Framework

Edit Profile

by: shapper | last post by:

Hello, How can I edit the profile of a non authenticated user? I want to edit profiles, as administrator, of users. Thanks, Miguel

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

How to provide user Edit Profile option?

Similar topics