Home > Article > Backend Development > PHP practical tutorial: Create a personalized many-to-one address book function
PHP practical tutorial: Create a personalized many-to-one address book function
- WBOYOriginal
- 2024-03-16 09:54:04394browse
In this article, we will learn how to use PHP to write a personalized many-to-one address book function through a practical case. In this case, we will show how to use a database to store contact information, and write corresponding code to implement functions such as adding, editing, and deleting contacts. At the same time, we will introduce how to implement a many-to-one relationship, that is, one user can have multiple contact information.
Environment setup
In order to start this project, we need to set up a PHP development environment. You can choose to use XAMPP, WAMP or other similar tools. After installing the PHP environment, you also need a MySQL database as the storage medium for our address book information.
Create database table
First, we need to create a database and a table to store contact information. The following is the SQL statement to create the table:
CREATE DATABASE contacts;
USE contacts;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL
);
CREATE TABLE contacts (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT,
name VARCHAR(50) NOT NULL,
phone VARCHAR(20),
email VARCHAR(50),
address TEXT,
FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
);Write PHP code
Next, we will write PHP code to implement the address book function. First, we create an index.php page as our front-end page, which contains forms for adding, editing, and deleting contacts.
<!DOCTYPE html>
<html>
<head>
<title>Personalized address book</title>
</head>
<body>
<h1>Personalized address book</h1>
<form action="add_contact.php" method="post">
<label>Name:</label>
<input type="text" name="name" required>
<label>Phone:</label>
<input type="text" name="phone">
<label>Email:</label>
<input type="text" name="email">
<label>Address:</label>
<textarea name="address"></textarea>
<input type="submit" value="Add Contact">
</form>
</body>
</html>Then, we create the add_contact.php page to handle the form submission and store the data in the database.
<?php
$db = new mysqli('localhost', 'username', 'password', 'contacts');
$name = $_POST['name'];
$phone = $_POST['phone'];
$email = $_POST['email'];
$address = $_POST['address'];
$query = "INSERT INTO contacts (user_id, name, phone, email, address) VALUES (1, '$name', '$phone', '$email', '$address')";
$result = $db->query($query);
if ($result) {
echo "Contact added successfully";
} else {
echo "Failed to add contact";
}
?>In the above code, we established an instance connected to the MySQL database and inserted contact information into the contacts table through the INSERT INTO statement . In order to achieve a many-to-one relationship, we fix user_id to 1, that is, all contacts belong to user 1.
Implementation of more functions
In addition to the function of adding contacts, we can also write corresponding PHP code to implement the functions of editing and deleting contacts. The code for editing and deleting contacts can be implemented in the edit_contact.php and delete_contact.php files.
Summary
Through the examples in this article, we learned how to use PHP and MySQL to implement personalized many-to-one address book functions. In actual development, you can further expand this address book and add more functions and interactive experiences according to your own needs. I hope this tutorial is helpful to you and I wish you happy programming!
The above is the detailed content of PHP practical tutorial: Create a personalized many-to-one address book function. For more information, please follow other related articles on the PHP Chinese website!