PHP implements user management functions-PHP Tutorial-php.cn

PHP implements user management functions

WBOY

Release： 2023-06-22 12:36:01

Original

1571 people have browsed it

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
)

Copy after login

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>

Copy after login

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>

Copy after login

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');
?>

Copy after login

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!