
How to use PHP to implement a simple online event registration system
With the rapid development of the Internet, more and more activities are beginning to manage registration through the online registration system process, eliminating the trouble of traditional paper registration forms and manual processing. This article will introduce how to use PHP language to implement a simple online event registration system, and use specific code examples to help readers understand and practice.
System Requirements Analysis
Before developing a system, it is first necessary to clarify the requirements and functions of the system. Based on the characteristics of the event registration system, we can determine the following functional requirements:
- Users can browse the detailed information of the event and fill in the registration form.
- After the user fills out the form, the system will save the user's registration information and send an email to the user to confirm the registration.
- The administrator can log in to the system management backend to view registration details and count the number of applicants.
- The administrator can export the registration information to Excel or CSV format files.
System design and database construction
Before starting to write PHP code, we need to design the database table structure and create the corresponding database table. Here we create two tables: one is the activity table, used to store basic information about the activity; the other is the registration table, used to store the user's registration information.
The activity table structure is as follows:
activity_id (int, primary key) activity ID
activity_name (varchar) activity name
activity_date (datetime) activity date
activity_location (varchar) activity location
...
The registration table structure is as follows:
registration_id (int, primary key) Registration ID
activity_id (int) Activity ID
name (varchar) Name
email (varchar) Email
phone (varchar) Phone
...
PHP code implementation
Next, we start writing PHP code to implement the system's functions. The first is the display and form submission processing of the user registration page.
<!DOCTYPE html>
<html>
<head>
<title>活動(dòng)報(bào)名系統(tǒng)</title>
</head>
<body>
<h1>活動(dòng)報(bào)名</h1>
<form action="submit.php" method="post">
<p>
<label for="name">姓名:</label>
<input type="text" id="name" name="name" required>
</p>
<p>
<label for="email">郵箱:</label>
<input type="email" id="email" name="email" required>
</p>
<p>
<label for="phone">電話:</label>
<input type="tel" id="phone" name="phone" required>
</p>
<input type="submit" value="報(bào)名">
</form>
</body>
</html>
The above code shows a simple registration form page. After the user fills out the form, clicking the "Sign Up" button will submit the data to submit.php for processing.
<?php
$activity_id = 1; // 假設(shè)活動(dòng)ID為1
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
// 保存用戶報(bào)名信息到數(shù)據(jù)庫(kù)
$conn = mysqli_connect("localhost", "root", "", "activity_registration");
$sql = "INSERT INTO registration (activity_id, name, email, phone) VALUES ('$activity_id', '$name', '$email', '$phone')";
mysqli_query($conn, $sql);
// 發(fā)送郵件給用戶確認(rèn)報(bào)名
$to = $email;
$subject = "活動(dòng)報(bào)名確認(rèn)";
$message = "您已成功報(bào)名參加活動(dòng)。";
$headers = "From: admin@example.com";
mail($to, $subject, $message, $headers);
echo "報(bào)名成功!";
?>
The above code saves the registration information submitted by the user to the database, and uses PHP's mail function to send an email to the user to confirm the registration.
Next, we write the login and registration information management functions of the administrator backend.
<!DOCTYPE html>
<html>
<head>
<title>管理員登錄</title>
</head>
<body>
<h1>管理員登錄</h1>
<form action="admin.php" method="post">
<p>
<label for="username">用戶名:</label>
<input type="text" id="username" name="username" required>
</p>
<p>
<label for="password">密碼:</label>
<input type="password" id="password" name="password" required>
</p>
<input type="submit" value="登錄">
</form>
</body>
</html>
The above code shows a simple administrator login interface. After the administrator fills in the correct user name and password, it will be submitted to admin.php for processing.
<?php
$username = $_POST['username'];
$password = $_POST['password'];
// 管理員登錄驗(yàn)證
if ($username == "admin" && $password == "password") {
// 登錄成功,顯示報(bào)名信息頁(yè)
$conn = mysqli_connect("localhost", "root", "", "activity_registration");
$sql = "SELECT * FROM registration";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
echo "姓名: " . $row['name'] . "<br>";
echo "郵箱: " . $row['email'] . "<br>";
echo "電話: " . $row['phone'] . "<br>";
echo "<hr>";
}
} else {
// 登錄失敗,顯示錯(cuò)誤提示
echo "用戶名或密碼錯(cuò)誤!";
}
?>
The above code verifies the administrator's username and password. If the verification is passed, the registration information is queried from the database and displayed to the administrator.
Summary and Outlook
Through the above sample code, we have learned how to use PHP language to implement a simple online event registration system. Of course, this is just a basic implementation. In practice, more functions and detailed optimizations can be added according to needs. I hope this article can help readers better understand and use PHP to implement their own registration system.
The above is the detailed content of How to use PHP to implement a simple online event registration system. For more information, please follow other related articles on the PHP Chinese website!