Simple User Profile With Update Profile Info Using PHP/MYSQL

December 14, 2021July 20, 2020 by Harley Lumagui

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.

Simple User Profile With Update Pro... x

Simple User Profile With Update Profile Info Using PHP/MYSQL 2021

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;

1

2

3

4

5

6

7

8

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. And Make sure to Create a “connection.php” file to hold the database connection to our PHP project.

<?php
 $db = mysqli_connect('localhost', 'root', '') or
        die ('Unable to connect. Check your connection parameters.');
        mysqli_select_db($db, 'mydb' ) or die(mysqli_error($db));
?>

1

2

3

4

5

<?php

$db = mysqli_connect('localhost', 'root', '') or

die ('Unable to connect. Check your connection parameters.');

mysqli_select_db($db, 'mydb' ) or die(mysqli_error($db));

?>

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

<!DOCTYPE html>
<html lang="en-US">
  <head>
  <title>IT SourceCode</title>
  <link rel="stylesheet" href="libs/css/bootstrap.min.css">
  <link rel="stylesheet" href="libs/style.css">
  </head>
  <?php
  include 'connection.php';
  session_start();
$id=$_SESSION['id'];
$query=mysqli_query($db,"SELECT * FROM users where user_id='$id'")or die(mysqli_error());
$row=mysqli_fetch_array($query);
  ?>
  <h1>User Profile</h1>
<div class="profile-input-field">
        <h3>Please Fill-out All Fields</h3>
        <form method="post" action="#" >
          <div class="form-group">
            <label>Fullname</label>
            <input type="text" class="form-control" name="fname" style="width:20em;" placeholder="Enter your Fullname" value="<?php echo $row['full_name']; ?>" required />
          </div>
          <div class="form-group">
            <label>Gender</label>
            <input type="text" class="form-control" name="gender" style="width:20em;" placeholder="Enter your Gender" required value="<?php echo $row['gender']; ?>" />
          </div>
          <div class="form-group">
            <label>Age</label>
            <input type="number" class="form-control" name="age" style="width:20em;" placeholder="Enter your Age" value="<?php echo $row['age']; ?>">
          </div>
          <div class="form-group">
            <label>Address</label>
            <input type="text" class="form-control" name="address" style="width:20em;" required placeholder="Enter your Address" value="<?php echo $row['address']; ?>"></textarea>
          </div>
          <div class="form-group">
            <input type="submit" name="submit" class="btn btn-primary" style="width:20em; margin:0;"><br><br>
            <center>
             <a href="logout.php">Log out</a>
           </center>
          </div>
        </form>
      </div>
      </html>
      <?php
      if(isset($_POST['submit'])){
        $fullname = $_POST['fname'];
        $gender = $_POST['gender'];
        $age = $_POST['age'];
        $address = $_POST['address'];
      $query = "UPDATE users SET full_name = '$fullname',
                      gender = '$gender', age = $age, address = '$address'
                      WHERE user_id = '$id'";
                    $result = mysqli_query($db, $query) or die(mysqli_error($db));
                    ?>
                     <script type="text/javascript">
            alert("Update Successfull.");
            window.location = "index.php";
        </script>
        <?php
             }               
?>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

<!DOCTYPE html>

<html lang="en-US">

<head>

<title>IT SourceCode</title>

<link rel="stylesheet" href="libs/css/bootstrap.min.css">

<link rel="stylesheet" href="libs/style.css">

</head>

<?php

include 'connection.php';

session_start();

$id=$_SESSION['id'];

$query=mysqli_query($db,"SELECT * FROM users where user_id='$id'")or die(mysqli_error());

$row=mysqli_fetch_array($query);

?>

<h1>User Profile</h1>

<div class="profile-input-field">

<h3>Please Fill-out All Fields</h3>

<form method="post" action="#" >

<div class="form-group">

<label>Fullname</label>

<input type="text" class="form-control" name="fname" style="width:20em;" placeholder="Enter your Fullname" value="<?php echo $row['full_name']; ?>" required />

</div>

<div class="form-group">

<label>Gender</label>

<input type="text" class="form-control" name="gender" style="width:20em;" placeholder="Enter your Gender" required value="<?php echo $row['gender']; ?>" />

</div>

<div class="form-group">

<label>Age</label>

<input type="number" class="form-control" name="age" style="width:20em;" placeholder="Enter your Age" value="<?php echo $row['age']; ?>">

</div>

<div class="form-group">

<label>Address</label>

<input type="text" class="form-control" name="address" style="width:20em;" required placeholder="Enter your Address" value="<?php echo $row['address']; ?>"></textarea>

</div>

<div class="form-group">

<input type="submit" name="submit" class="btn btn-primary" style="width:20em; margin:0;"><br><br>

<center>

<a href="logout.php">Log out</a>

</center>

</div>

</form>

</div>

</html>

<?php

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

$fullname = $_POST['fname'];

$gender = $_POST['gender'];

$age = $_POST['age'];

$address = $_POST['address'];

$query = "UPDATE users SET full_name = '$fullname',

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

WHERE user_id = '$id'";

$result = mysqli_query($db, $query) or die(mysqli_error($db));

?>

<script type="text/javascript">

alert("Update Successfull.");

window.location = "index.php";

</script>

<?php

}

?>

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

<!DOCTYPE html>
<html lang="en-US">
  <head>
  <title>IT SourceCode</title>
  <link rel="stylesheet" href="libs/css/bootstrap.min.css">
  <link rel="stylesheet" href="libs/style.css">
  </head>
  <h1>User Log In</h1>
<div class="input-field">
        <h3>Please Fill-out All Fields</h3>
        <form method="post" action="#" >
          <div class="form-group">
            <label>Username</label>
            <input type="text" class="form-control" name="user" style="width:20em;" placeholder="Enter your Username" required />
          </div>
          <div class="form-group">
            <label>Password</label>
            <input type="password" class="form-control" name="pass" style="width:20em;" placeholder="Enter your Password" required />
          </div>
          <div class="form-group">
            <input type="submit" name="submit" class="btn btn-primary submitBtn" style="width:20em; margin:0;" /><br><br>
            <center>
             <a href="register.php">register</a>
           </center>
          </div>
          
        </form>
      </div>
      </html>
      <?php
      session_start();
      include 'connection.php';
if(isset($_POST['submit'])){
  $user = $_POST['user'];
  $pass = $_POST['pass'];
  $query=mysqli_query($db,"SELECT * FROM users WHERE username = '$user' AND password = '$pass'");
  $num_rows=mysqli_num_rows($query);
  $row=mysqli_fetch_array($query);
  $_SESSION["id"]=$row['user_id'];
if ($num_rows>0)
{
    ?>
    <script>
      alert('Successfully Log In');
      document.location='profile.php'
    </script>
    <?php
}
}
      ?>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

<!DOCTYPE html>

<html lang="en-US">

<head>

<title>IT SourceCode</title>

<link rel="stylesheet" href="libs/css/bootstrap.min.css">

<link rel="stylesheet" href="libs/style.css">

</head>

<h1>User Log In</h1>

<div class="input-field">

<h3>Please Fill-out All Fields</h3>

<form method="post" action="#" >

<div class="form-group">

<label>Username</label>

<input type="text" class="form-control" name="user" style="width:20em;" placeholder="Enter your Username" required />

</div>

<div class="form-group">

<label>Password</label>

<input type="password" class="form-control" name="pass" style="width:20em;" placeholder="Enter your Password" required />

</div>

<div class="form-group">

<input type="submit" name="submit" class="btn btn-primary submitBtn" style="width:20em; margin:0;" /><br><br>

<center>

<a href="register.php">register</a>

</center>

</div>

</form>

</div>

</html>

<?php

session_start();

include 'connection.php';

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

$user = $_POST['user'];

$pass = $_POST['pass'];

$query=mysqli_query($db,"SELECT * FROM users WHERE username = '$user' AND password = '$pass'");

$num_rows=mysqli_num_rows($query);

$row=mysqli_fetch_array($query);

$_SESSION["id"]=$row['user_id'];

if ($num_rows>0)

{

?>

<script>

alert('Successfully Log In');

document.location='profile.php'

</script>

<?php

}

}

?>

Step 5. For registration of user profile information, create “register.php” file then put the following codes.

<!DOCTYPE html>
<html lang="en-US">
  <head>
  <title>IT SourceCode</title>
  <link rel="stylesheet" href="libs/css/bootstrap.min.css">
  <link rel="stylesheet" href="libs/style.css">
  </head>
  <h1>Register</h1>
<div class="reg-input-field">
        <h3>Please Fill-out All Fields</h3>
        <form method="post" action="#" >
          <div class="form-group">
            <label>Fullname</label>
            <input type="text" class="form-control" name="fname" style="width:20em;" placeholder="Enter your Fullname" required />
          </div>
          <div class="form-group">
            <label>Gender</label>
            <input type="text" class="form-control" name="gender" style="width:20em;" placeholder="Enter your Gender" required pattern="[a-zA-Z .]+" />
          </div>
          <div class="form-group">
            <label>Age</label>
            <input type="number" class="form-control" name="age" style="width:20em;" placeholder="Enter your Age">
          </div>
          <div class="form-group">
            <label>Address</label>
            <input type="text" class="form-control" name="address" style="width:20em;" required placeholder="Enter your Address"></textarea>
          </div>
          <div class="form-group">
            <label>Username</label>
            <input type="text" class="form-control" name="user" style="width:20em;" placeholder="Enter your Username">
          </div><div class="form-group">
            <label>Password</label>
            <input type="Password" class="form-control" name="pass" style="width:20em;" required  placeholder="Enter your Password">
          </div>
          <div class="form-group">
            <input type="submit" name="submit" class="btn btn-primary submitBtn" style="width:20em; margin:0;" /><br><br>
             <center>
             <a href="index.php">LogIn</a>
           </center>
          </div>
        </form>
      </div>
      </html>
      <?php
      include 'connection.php';
if(isset($_POST['submit'])){
$fname = $_POST['fname'];
$gender = $_POST['gender'];
$age = $_POST['age'];
$address = $_POST['address'];
$user = $_POST['user'];
$pass = $_POST['pass'];


  $query = "INSERT INTO users
                (username, password, full_name,gender,age,address)
                VALUES ('".$user."','".$pass."','".$fname."','".$gender."','".$age."','".$address."')";
                mysqli_query($db,$query)or die ('Error in updating Database');
                ?>
                <script type="text/javascript">
            alert("Successfull Added.");
            window.location = "index.php";
        </script>
                <?php
}
      ?>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

<!DOCTYPE html>

<html lang="en-US">

<head>

<title>IT SourceCode</title>

<link rel="stylesheet" href="libs/css/bootstrap.min.css">

<link rel="stylesheet" href="libs/style.css">

</head>

<h1>Register</h1>

<div class="reg-input-field">

<h3>Please Fill-out All Fields</h3>

<form method="post" action="#" >

<div class="form-group">

<label>Fullname</label>

<input type="text" class="form-control" name="fname" style="width:20em;" placeholder="Enter your Fullname" required />

</div>

<div class="form-group">

<label>Gender</label>

<input type="text" class="form-control" name="gender" style="width:20em;" placeholder="Enter your Gender" required pattern="[a-zA-Z .]+" />

</div>

<div class="form-group">

<label>Age</label>

<input type="number" class="form-control" name="age" style="width:20em;" placeholder="Enter your Age">

</div>

<div class="form-group">

<label>Address</label>

<input type="text" class="form-control" name="address" style="width:20em;" required placeholder="Enter your Address"></textarea>

</div>

<div class="form-group">

<label>Username</label>

<input type="text" class="form-control" name="user" style="width:20em;" placeholder="Enter your Username">

</div><div class="form-group">

<label>Password</label>

<input type="Password" class="form-control" name="pass" style="width:20em;" required placeholder="Enter your Password">

</div>

<div class="form-group">

<input type="submit" name="submit" class="btn btn-primary submitBtn" style="width:20em; margin:0;" /><br><br>

<center>

<a href="index.php">LogIn</a>

</center>

</div>

</form>

</div>

</html>

<?php

include 'connection.php';

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

$fname = $_POST['fname'];

$gender = $_POST['gender'];

$age = $_POST['age'];

$address = $_POST['address'];

$user = $_POST['user'];

$pass = $_POST['pass'];

$query = "INSERT INTO users

(username, password, full_name,gender,age,address)

VALUES ('".$user."','".$pass."','".$fname."','".$gender."','".$age."','".$address."')";

mysqli_query($db,$query)or die ('Error in updating Database');

?>

<script type="text/javascript">

alert("Successfull Added.");

window.location = "index.php";

</script>

<?php

}

?>

Step 6. For the logout of user action, create “logout.php” file then put the following codes.

<?php
session_start();
unset($_SESSION['id']);
session_destroy();
header("Location: index.php");
?>

1

2

3

4

5

6

<?php

session_start();

unset($_SESSION['id']);

session_destroy();

header("Location: index.php");

?>

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.

Sample Screenshots:

Run Quick Scan for secure Download

Run Quick Scan for secure Download

Downloadable Source Code

Download the Full Source Code here. userprofile

Inquiries

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.

11 thoughts on “Simple User Profile With Update Profile Info Using PHP/MYSQL”

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?
Reply
zainab

June 1, 2018 at 2:16 am

Please can I get the source code via email?
Reply
Darshan

February 13, 2019 at 12:23 pm

code is not working
Reply
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]
Reply
BrightCode

January 10, 2020 at 9:49 pm

do you have a YouTube channel for this
Reply
Mark

January 26, 2020 at 10:06 pm

I observed, the connection.php file is not included here
Reply
- kaiwan kurde
  
  February 8, 2020 at 11:58 am
  
  hello i can helep you.
  Reply
seraj

January 30, 2020 at 11:38 am

please could you provide the code of login-profile.php and reg-profile.php?????
Reply
Neba

April 10, 2020 at 5:45 am

yeah I cant find it too and its giving me errors
Reply
testitall3777

May 28, 2020 at 12:52 pm

thanks a lot
it was helpful
Reply
J Mill

July 13, 2021 at 10:33 pm

This appears vulnerable to SQL injection. 🙁
Reply

Leave a Comment Cancel reply