How to use PHP to implement user group management module

As a server-side scripting language, PHP is very suitable for developing Web applications, and the user group management module is also an essential function in Web applications.

This article will introduce in detail how to use PHP to implement the user group management module, including the functions of adding, modifying, deleting and searching user groups.

1. Database design
We first need to design the user group database table. The following is a simple design example:

CREATE TABLE user_group (

id INT(11) NOT NULL AUTO_INCREMENT,  # 用户组ID
name VARCHAR(50) NOT NULL,           # 用户组名称
description TEXT,                    # 用户组描述
PRIMARY KEY (id)

);

2. Create a user group
The following is a simple PHP script example for creating a user group:

//Connect to the database
$mysqli = new mysqli('localhost', 'user', 'password', 'database');

// Get POST parameters
$name = $_POST['name'];
$ description = $_POST['description'];

// Preprocessing SQL statements
$stmt = $mysqli->prepare("INSERT INTO user_group (name, description) VALUES (?, ?) ");
$stmt->bind_param('ss', $name, $description);

// Execute SQL statement
if ($stmt->execute()) {

echo "用户组创建成功！";

} else {

echo "用户组创建失败！";

}

// Close the connection
$stmt->close();
$mysqli->close( );
?>

The above code first connects to the MySQL database, then obtains the POST parameters, and uses prepared statements to insert the parameters into the user group table. Finally close the database connection.

3. Modify user group
The following is a simple PHP script example for modifying user group:

// Connect to database
$ mysqli = new mysqli('localhost', 'user', 'password', 'database');

// Get POST parameters
$id = $_POST['id'];
$name = $_POST['name'];
$description = $_POST['description'];

// Preprocessing SQL statement
$stmt = $mysqli->prepare( "UPDATE user_group SET name = ?, description = ? WHERE id = ?");
$stmt->bind_param('ssi', $name, $description, $id);

// Execute SQL statement
if ($stmt->execute()) {

echo "用户组修改成功！";

} else {

echo "用户组修改失败！";

}

// Close the connection
$ stmt->close();
$mysqli->close();
?>

The above code first connects to the MySQL database, then gets the POST parameters, and uses prepared statements to The parameters are updated into the user group table. Finally close the database connection.

4. Delete user group
The following is a simple PHP script example for deleting a user group:

//Connect to the database
$ mysqli = new mysqli('localhost', 'user', 'password', 'database');

// Get POST parameters
$id = $_POST['id'];

// Preprocessing SQL statements
$stmt = $mysqli->prepare("DELETE FROM user_group WHERE id = ?");
$stmt->bind_param('i', $id) ;

//Execute SQL statement
if ($stmt->execute()) {

echo "用户组删除成功！";

} else {

echo "用户组删除失败！";

}

//Close the connection
$stmt->close();
$mysqli->close();
?>

The above code first connects to the MySQL database, and then Get the POST parameters and use prepared statements to delete the user group with the specified ID from the user group table. Finally close the database connection.

5. Search for user groups
The following is a simple PHP script example for finding user groups:

//Connect to the database
$ mysqli = new mysqli('localhost', 'user', 'password', 'database');

// Get POST parameters
$name = "%$_POST[name]%";

// Preprocessing SQL statements
$stmt = $mysqli->prepare("SELECT * FROM user_group WHERE name LIKE ?");
$stmt->bind_param('s', $name);

//Execute SQL statement
$stmt->execute();
$result = $stmt->get_result();

// Output query results
while ($row = $result->fetch_assoc()) {

echo $row['id'] . ' ' . $row['name'] . ' ' . $row['description'] . '
';

}

// Close the connection
$stmt->close() ;
$mysqli->close();
?>

The above code first connects to the MySQL database, then obtains the POST parameters, and uses prepared statements to query the user group containing the specified name. Finally, the query results are output and the database connection is closed.

6. Summary
This article introduces how to use PHP to implement the user group management module, including functions such as adding, modifying, deleting and searching user groups. By using prepared statements, we can effectively prevent SQL injection attacks. These functions can not only serve as a basic function, but also play an important role in web applications that require permission control.

The above is the detailed content of How to use PHP to implement user group management module. For more information, please follow other related articles on the PHP Chinese website!