Simple User Profile With Update Profile Info Using PHP/MYSQL

April 27, 2017

11077

Simple User Profile With Update Profile Info Using PHP/MYSQL

Good day everyone! Today is another tutorial for all PHP developers, especially for the beginners in PHP programming. I will teach you to create a Simple User Profile With Update Profile Info Using PHP/MYSQL.

This article can answer the question posted in StackOverflow about how to view user’s profiles using PHP.

But before that, make sure you are done creating a simple login and registration. If you are not yet, this tutorial might help you. >> click here <<

Steps to Create User Profile With Update Profile Info Using PHP/MYSQL

Step 1. First, create a database, name it as any name you desire. In my case, I use “ITSOURCECODE” as the name of the database.

Step 2. Then create the”USERS” table then put the following attributes.

CREATE TABLE `users` (  `user_id` int(11) NOT NULL,
  `username` text NOT NULL, 
 `password` text NOT NULL,
  `full_name` text NOT NULL, 
 `gender` text NOT NULL, 
 `age` int(11) NOT NULL, 
 `address` text NOT NULL) 
ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `users` ( `user_id` int(11) NOT NULL,

`username` text NOT NULL,

`password` text NOT NULL,

`full_name` text NOT NULL,

`gender` text NOT NULL,

`age` int(11) NOT NULL,

`address` text NOT NULL)

ENGINE=MyISAM DEFAULT CHARSET=latin1;

Make sure you are done doing in the login and registration. A link will be seen and view on the link above.

Step 3. For the user’s profile, create “profile.php” file then put the following codes.

<?php 
include 'connection.php';
session_start();
if (isset($_GET['user']))
{
$user = $_GET['user'];
$get_user = $mysqli->query("SELECT * FROM users WHERE username = '$user'");
if ($get_user->num_rows == 1)
{
    $profile_data = $get_user->fetch_assoc();
           
}
       
} 
?>
<!DOCTYPE html>
<html>    
<head>        
	<meta charset="UTF-8">
	        <title><?php echo $profile_data['username'] ?>'s Profile</title>
</head>
<body>
    <a href="index.php">Home</a> | <?php echo $profile_data['username'] ?>'s Profile        
    <h3>Personal Information | <? php            $visitor = $_SESSION['username'];
           if ($user == $visitor)
{ ?>            <a href="edit-profile.php?user=<?php echo $profile_data['username'] ?>">Edit Profile</a>            <?php
}
        ?>        </h3>        
        <table>
                    <tr>                
                    	<td>Name:</td><td><?php echo $profile_data['full_name'] ?></td>   
                    </tr>
                    <tr>                
                    	<td>Age:</td><td><?php echo $profile_data['age'] ?></td> 
                    </tr> 
                    <tr>
                        <td>Gender:</td><td><?php echo $profile_data['gender'] ?></td>
                    </tr>
                    <tr>
                        <td>Address:</td><td><?php echo $profile_data['address'] ?></td> 
                    </tr>        
        </table> 
    </body>
</html> 
?>

<?php

include 'connection.php';

session_start();

if (isset($_GET['user']))

{

$user = $_GET['user'];

$get_user = $mysqli->query("SELECT * FROM users WHERE username = '$user'");

if ($get_user->num_rows == 1)

{

$profile_data = $get_user->fetch_assoc();

}

<!DOCTYPE html>

<html>

<head>

<title><?php echo $profile_data['username'] ?>'s Profile</title>

</head>

<body>

<a href="index.php">Home</a> | <?php echo $profile_data['username'] ?>'s Profile

<h3>Personal Information | <? php $visitor = $_SESSION['username'];

if ($user == $visitor)

{ ?> <a href="edit-profile.php?user=<?php echo $profile_data['username'] ?>">Edit Profile</a> <?php

}

?> </h3>

<table>

<tr>

</tr>

<tr>

</tr>

<tr>

<td>Gender:</td><td><?php echo $profile_data['gender'] ?></td>

</tr>

<tr>

<td>Address:</td><td><?php echo $profile_data['address'] ?></td>

</tr>

</table>

</body>

</html>

Step 4. Update the “index.php” file by putting the following codes.

<?php
     include 'connection.php'; 
    session_start();
 ?>
 <!DOCTYPE html><html>
     <head>       
  <meta charset="UTF-8">  
        <title>ITSourceCode.Com</title>
    </head>   
 <body>    
 	    <?php   
 	         if (!isset($_SESSION['username'])) {
 	    ?>      
 	      <h5>Login</h5> 
 	           <form method="post" action="login-action.php">   
 	    	      <label>Username:</label><br>  
 	    	      <input type="text" name="username" /><br> 
 	    	      <label>Password:</label><br>    
 	    	     <input type="password" name="password" /><br> 
 	    	     <input type="submit" value="Login" />   
 	    	  </form>        Not a member yet? Click <a href="registration.php">here</a> to register.  
 	    	<?php } else 
 	    	if (isset($_SESSION['username'])) { 
 	    		?>      
 	    		  <a href="profile.php?user=<?php echo $_SESSION['username'] ?>" title="View My Profile"><?php echo $_SESSION['username'] ?></a> | <a href="logout.php">Logout</a>       
 	    	     <?php }    
 	    	    ?>      
 	    	  <?php     
 	    	       if (isset($_SESSION['username'])) {   
 	    		     $users = $mysqli->query("SELECT * FROM users");
 	    	          while ($user_data = $users->fetch_assoc()) { ?><br><br> 
 	    	          <b>#<?php echo $user_data['user_id'] ?></b> 
 	    	 <?php echo $user_data['username'] ?> | <a href="profile.php?user=<?php echo $user_data['username'] ?>">View Profile</a>            
 	    	    <?php }          
 	    }      
 	    ?>    
 	</body>
 </html>

<?php

include 'connection.php';

session_start();

<!DOCTYPE html><html>

<head>

<title>ITSourceCode.Com</title>

</head>

<body>

<?php

if (!isset($_SESSION['username'])) {

<h5>Login</h5>

<label>Username:</label><br>

<label>Password:</label><br>

</form> Not a member yet? Click <a href="registration.php">here</a> to register.

<?php } else

if (isset($_SESSION['username'])) {

<a href="profile.php?user=<?php echo $_SESSION['username'] ?>" title="View My Profile"><?php echo $_SESSION['username'] ?></a> | <a href="logout.php">Logout</a>

<?php }

<?php

if (isset($_SESSION['username'])) {

$users = $mysqli->query("SELECT * FROM users");

while ($user_data = $users->fetch_assoc()) { ?><br><br>

<?php echo $user_data['username'] ?> | <a href="profile.php?user=<?php echo $user_data['username'] ?>">View Profile</a>

<?php }

}

</body>

</html>

Step 5. For updating the user profile information, create “edit-profile.php” file then put the following codes.

<?php
include 'connection.php'; 
   if (isset($_GET['user'])) {
	  $user = $_GET['user'];
	  $get_user = $mysqli->query("SELECT * FROM users WHERE username = '$user'");
	  $user_data = $get_user->fetch_assoc();
    } else {
	   header("Location: index.php");
    }?>
<!DOCTYPE html>
<html>
    <head>  
	<meta charset="UTF-8">
		<title><?php echo $user_data['username'] ?>'s Profile Settings</title>
    </head> 
	<body>        <a href="index.php">Home</a> | Back to <a href="profile.php?user=<?php echo $user_data['username'] ?>"><?php echo $user_data['username'] ?></a>'s Profile        
		<h3>Update Profile Information</h3> 
		       <form method="post" action="update-profile-action.php?user=<?php echo $user_data['username'] ?>">            			<label>Name:</label><br> 
			         <input type="text" name="fullname" value="<?php echo $user_data['full_name'] ?>" /><br> 
			         <label>Age:</label><br>
			         <input type="text" name="age" value="<?php echo $user_data['age'] ?>" /><br> 
			         <label>Gender:</label><br> 
			         <input type="text" name="gender" value="<?php echo $user_data['gender'] ?>" /><br>
			         <label>Address:</label><br>          
			         <input type="text" name="address" value="<?php echo $user_data['address'] ?>" /><br><br>  
			         <input type="submit" name="update_profile" value="Update Profile" />        
		</form>    
	</body>
</html>

<?php

include 'connection.php';

if (isset($_GET['user'])) {

$user = $_GET['user'];

$get_user = $mysqli->query("SELECT * FROM users WHERE username = '$user'");

$user_data = $get_user->fetch_assoc();

} else {

header("Location: index.php");

}?>

<!DOCTYPE html>

<html>

<head>

<title><?php echo $user_data['username'] ?>'s Profile Settings</title>

</head>

<body> <a href="index.php">Home</a> | Back to <a href="profile.php?user=<?php echo $user_data['username'] ?>"><?php echo $user_data['username'] ?></a>'s Profile

<h3>Update Profile Information</h3>

<label>Gender:</label><br>

<label>Address:</label><br>

</form>

</body>

</html>

Step 6. For the update profile action, create “update-profile-action.php” file then put the following codes.

<?php
  include 'connection.php';
    if (isset($_POST['update_profile'])) {
	$user = $_GET['user'];
	$fullname = $_POST['fullname'];
	$age = $_POST['age'];
	$gender = $_POST['gender'];
	$address = $_POST['address'];
	$update_profile = $mysqli->query("UPDATE users SET full_name = '$fullname',
                      gender = '$gender', age = $age, address = '$address'
                      WHERE username = '$user'");
	    if ($update_profile) {
		   header("Location: profile.php?user=$user");
	    } else {
		  echo $mysqli->error;
	    }
	}
?>

<?php

include 'connection.php';

if (isset($_POST['update_profile'])) {

$user = $_GET['user'];

$fullname = $_POST['fullname'];

$age = $_POST['age'];

$gender = $_POST['gender'];

$address = $_POST['address'];

$update_profile = $mysqli->query("UPDATE users SET full_name = '$fullname',

gender = '$gender', age = $age, address = '$address'

WHERE username = '$user'");

if ($update_profile) {

header("Location: profile.php?user=$user");

} else {

echo $mysqli->error;

}

After all the code has been added, you may now test the code by running it to using your desire browser.

For More PHP Projects with Source Code, please visit the link here.

Screenshots:

If you have questions regarding “Simple User Profile With Update Profile Info Using PHP/MYSQL” feel free to ask by commenting below or visit on our contact page. Thank you.

5 COMMENTS

iman April 17, 2018 At 1:42 pm

I do not know how to copy this code because the code has been compromised !!!
Can it be sent to me by email?

zainab June 1, 2018 At 2:16 am

Please can I get the source code via email?

Darshan February 13, 2019 At 12:23 pm

code is not working

Sam May 10, 2019 At 12:13 pm

can I get the source code by mail please, it is not formatted clearly here @[email protected]

BrightCode January 10, 2020 At 9:49 pm

do you have a YouTube channel for this