Home > Article > Backend Development > PHP implements user management functions

PHP implements user management functions

WBOYOriginal: 2023-06-22 11:16:221511browse

PHP is a powerful programming language that can be used to create a wide variety of websites and applications. This article will introduce how to use PHP to implement user management functions.

First, we need to create a database to store user information. In MySQL, you can create a table named "users" using the following code:

CREATE TABLE users (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(30) NOT NULL,
  password VARCHAR(30) NOT NULL,
  email VARCHAR(50),
  reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)

This table contains information such as user ID, username, password, email, and registration date.

Next, we can use PHP to create a simple user management system. The following is a basic user registration and login system:

<?php
session_start();
include('db.php');
if(isset($_POST['register'])){
    $username = $_POST['username'];
    $password = $_POST['password'];
    $email = $_POST['email'];
    $sql = "INSERT INTO users (username, password, email) VALUES ('$username', '$password', '$email')";
    $result = mysqli_query($con, $sql);
    if($result){
        echo "Registration successful.";
    } else {
        echo "Registration failed.";
    }
}

if(isset($_POST['login'])){
    $username = $_POST['username'];
    $password = $_POST['password'];
    $sql = "SELECT * FROM users WHERE username = '$username' AND password = '$password'";
    $result = mysqli_query($con, $sql);
    if(mysqli_num_rows($result)>0){
        $row = mysqli_fetch_array($result);
        $_SESSION['userid'] = $row['id'];
        header('Location: dashboard.php');
    } else {
        echo "Login failed.";
    }
}
?>
<!DOCTYPE html>
<html>
<head>
    <title>User Management System</title>
</head>
<body>
    <h2>Register new user</h2>
    <form method="post" action="index.php">
        <input type="text" name="username" placeholder="Username"><br><br>
        <input type="password" name="password" placeholder="Password"><br><br>
        <input type="email" name="email" placeholder="Email"><br><br>
        <input type="submit" name="register" value="Register">
    </form>
    <br><br>
    <h2>Login</h2>
    <form method="post" action="index.php">
        <input type="text" name="username" placeholder="Username"><br><br>
        <input type="password" name="password" placeholder="Password"><br><br>
        <input type="submit" name="login" value="Login">
    </form>
</body>
</html>

The code includes a registration form and a login form, as well as code to insert user information into the database and code to retrieve user information from the database.

Once the user is logged in, we can create a basic admin panel using PHP. Here is a sample dashboard:

<?php
session_start();
if(!isset($_SESSION['userid'])){
    header('Location: index.php');
}
?>
<!DOCTYPE html>
<html>
<head>
    <title>User Management System Dashboard</title>
</head>
<body>
    <h2>Welcome to the dashboard</h2>
    <p>You are logged in as user <?php echo $_SESSION['userid']; ?></p>
    <a href="logout.php">Logout</a>
</body>
</html>

This code includes a welcome message and a logout link, as well as code to retrieve user information from the session using the user ID.

Finally, we need to create a logout page so that users can exit the system safely. Here is a sample logout page:

<?php
session_start();
session_unset();
session_destroy();
header('Location: index.php');
?>

This page clears the user session and redirects the user back to the login page.

The above is a simple user management system that uses PHP and MySQL to store and retrieve user information. You can use this system as a starting point to extend more complex functionality such as more user information, navigation menus, tables and search functions, etc.

The above is the detailed content of PHP implements user management functions. For more information, please follow other related articles on the PHP Chinese website!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：How to learn the Laravel framework in PHPNext article：How to learn the Laravel framework in PHP

See more

PHP implements user management functions

Related articles