PHP practical tutorial: Create a personalized many-to-one address book function-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

PHP practical tutorial: Create a personalized many-to-one address book function

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Mar 16, 2024 am 09:54 AM

phpsql statementform submissionphp writtenPractical tutorialAddress book

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!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn