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;
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));
?>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
}
?>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
}
}
?>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
}
?>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");
?>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:
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.
Frequently Asked Questions
How does this PHP project work?
Built with vanilla PHP (no framework) and MySQL backend. Standard structure: form HTML, PHP script handlers, MySQL via PDO or mysqli, sessions for auth, Bootstrap for responsive layout. Ready to extend for BSIT capstone scope.
What PHP and MySQL versions does this project require?
Most projects in this batch run on PHP 7.4 to PHP 8.2 with MySQL 5.7+ or MariaDB 10+. A few older projects need PHP 5.6 (deprecated, use XAMPP 7.x). To run: install XAMPP / WAMP / Laragon, extract project to htdocs, import the included .sql file via phpMyAdmin, edit the connection file (usually config.php or db_connect.php) with your DB credentials, browse to the project URL in your browser.
How do I set up the database for this PHP project?
Open phpMyAdmin (http://localhost/phpmyadmin/ on XAMPP), create a new empty database with the name specified in the project’s config.php. Click the Import tab, choose the included .sql file, click Go. Then edit config.php (or includes/connection.php) with: ‘localhost’, your MySQL username (usually ‘root’), your MySQL password (usually blank for XAMPP), and the database name.
Can I use this PHP project for a BSIT capstone or thesis?
Yes, but extend it. A bare CRUD app is too narrow for full capstone scope. Add: user roles via session checks, reports/dashboards (Chart.js + AJAX), PDF exports (TCPDF library), email notifications (PHPMailer), real domain extension (analytics, audit log, multi-branch support). Pair with Chapter 1-5 documentation matching your panel’s rubric.
Why am I getting ‘connection error’ or ‘undefined function mysqli_connect’?
Three common PHP issues: (1) Connection error: Apache + MySQL services not running in XAMPP control panel, OR database name in config.php does not match what you created in phpMyAdmin. (2) ‘undefined function mysqli_connect’: MySQL extension not enabled, in php.ini uncomment extension=mysqli (then restart Apache). (3) ‘No such file or directory’: MySQL socket path wrong, use 127.0.0.1 instead of localhost in the connection string.
Where can I find more PHP projects with source code?
Browse the PHP Projects hub for the full library (300+ vanilla PHP systems). For modern PHP MVC alternatives see Laravel Projects (74 systems) or CodeIgniter Projects (32 systems). For BSIT-focused capstone idea lists see 150 Best Capstone Project Ideas.
I do not know how to copy this code because the code has been compromised !!!
Can it be sent to me by email?
Please can I get the source code via email?
code is not working
can I get the source code by mail please, it is not formatted clearly here @[email protected]
do you have a YouTube channel for this
I observed, the connection.php file is not included here
hello i can helep you.
please could you provide the code of login-profile.php and reg-profile.php?????
yeah I cant find it too and its giving me errors
thanks a lot
it was helpful
This appears vulnerable to SQL injection. 🙁
Hi, thank you for this kindness. It is very helpful no doubt but I am looking for something to set and update profile image like something, I tried by myself but I’ve no idea how to work with two tables in parent-child relationship.
I was trying to store users’ credentials in one table and images in other tables should be had same primary key so it could be easy to make changes in both tables at a time.
Can you please help me because I have been trying for days?
Regards