Backend Development
PHP Tutorial
PHP practical tutorial: Create a personalized many-to-one address book function
PHP practical tutorial: Create a personalized many-to-one address book function
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 id="Personalized-address-book">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!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian
Dec 24, 2024 pm 04:42 PM
PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati
CakePHP Date and Time
Sep 10, 2024 pm 05:27 PM
To work with date and time in cakephp4, we are going to make use of the available FrozenTime class.
CakePHP File upload
Sep 10, 2024 pm 05:27 PM
To work on file upload we are going to use the form helper. Here, is an example for file upload.
Discuss CakePHP
Sep 10, 2024 pm 05:28 PM
CakePHP is an open-source framework for PHP. It is intended to make developing, deploying and maintaining applications much easier. CakePHP is based on a MVC-like architecture that is both powerful and easy to grasp. Models, Views, and Controllers gu
CakePHP Creating Validators
Sep 10, 2024 pm 05:26 PM
Validator can be created by adding the following two lines in the controller.
How To Set Up Visual Studio Code (VS Code) for PHP Development
Dec 20, 2024 am 11:31 AM
Visual Studio Code, also known as VS Code, is a free source code editor — or integrated development environment (IDE) — available for all major operating systems. With a large collection of extensions for many programming languages, VS Code can be c
CakePHP Working with Database
Sep 10, 2024 pm 05:25 PM
Working with database in CakePHP is very easy. We will understand the CRUD (Create, Read, Update, Delete) operations in this chapter.
CakePHP Logging
Sep 10, 2024 pm 05:26 PM
Logging in CakePHP is a very easy task. You just have to use one function. You can log errors, exceptions, user activities, action taken by users, for any background process like cronjob. Logging data in CakePHP is easy. The log() function is provide
