Home Web Front-end Front-end Q&A How to implement the function of updating only some column data in Vue.js

How to implement the function of updating only some column data in Vue.js

Apr 13, 2023 am 10:46 AM

In actual project development, we often face such a situation: we need to query data based on certain conditions, but we only want to update some of the columns, not all of them. At this time, we can use Vue.js to build a simple front-end application and implement data query and update through AJAX technology.

This article introduces how to implement the function of updating only part of the column data in Vue.js.

Step 1: Preparation

First, we need to prepare a database and write the corresponding API on the server side so that the front-end application can interact with the server side. In this article, we assume a MySQL database and write the API using Node.js and the Express framework.

Assume that our database has a users table, which contains the following fields:

  • id - the user's unique identifier, a self-increasing integer
  • name - User name, string type
  • email - user email, string type
  • phone - user phone, string type

We hope to achieve the following functions:

  • Query all the user's information based on the user's name;
  • can update the user's email and phone number, but other information is not allowed to be modified.

In order to realize this function, we need to implement the query and update functions respectively in the server-side API, and correspond to two routes respectively:

  • GET /users/: name - Query user information based on user name;
  • PUT /users/:id - Update user information.

Since the focus of this article is on the front-end implementation, we will not discuss more about the server-side implementation method. Interested readers can refer to other related materials.

Step 2: Build a front-end application

Next, we will use Vue.js to build a front-end application and interact with data through AJAX technology and server-side API.

First, we need to introduce Vue.js and jQuery libraries into the HTML file. The code is as follows:

<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Vue.js Demo</title>
    <script src="https://cdn.jsdelivr.net/npm/vue/dist/vue.js"></script>
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
</head>
<body>
    <div id="app">
        <div>
            <label>用户名:</label>
            <input type="text" v-model="name">
            <button @click="search">查询</button>
        </div>
        <div v-if="result">
            <label>邮箱:</label>
            <input type="text" v-model="result.email" :disabled="loading">
            <label>电话:</label>
            <input type="text" v-model="result.phone" :disabled="loading">
            <button @click="update">更新</button>
        </div>
        <div v-else>
            {{ message }}
        </div>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/axios/dist/axios.min.js"></script>
    <script src="app.js"></script>
</body>
</html>
Copy after login

In the HTML file, we define a div element with the id "app" as The mount point for the Vue.js instance. In this div, we use the template syntax and instructions of Vue.js to implement the following functions:

  • Bind the value of the input element to the name attribute of the Vue.js instance;
  • When the query button is clicked, the search method is called;
  • The v-if instruction dynamically displays the query results or error prompts based on the result attribute value of the Vue.js instance, and the result and message attributes store the query results and error messages respectively. The content of the error message;
  • Bind the value of the input element to the email and phone fields of the query result, and disable the input element while loading;
  • When the update button is clicked, the update method is called.

It should be noted that we introduced the axios library in the HTML file, which is a Promise-based HTTP client that can be used to send AJAX requests.

Next, we write the code for the Vue.js instance in the app.js file. The code is as follows:

var app = new Vue({
    el: "#app",
    data: {
        name: "",
        result: null,
        message: "",
        loading: false,
    },
    methods: {
        search: function() {
            var self = this;
            self.loading = true;
            self.result = null;
            self.message = "正在加载...";
            axios.get("/api/users/" + self.name).then(function(res) {
                self.loading = false;
                if (res.data.status === 0) {
                    self.result = res.data.result;
                    self.message = "";
                } else {
                    self.message = res.data.message;
                }
            }).catch(function() {
                self.loading = false;
                self.message = "加载失败,请重试";
            });
        },
        update: function() {
            var self = this;
            var data = {
                email: self.result.email,
                phone: self.result.phone,
            };
            axios.put("/api/users/" + self.result.id, data).then(function(res) {
                if (res.data.status === 0) {
                    alert("更新成功");
                } else {
                    alert(res.data.message);
                }
            }).catch(function() {
                alert("更新失败,请重试");
            });
        },
    },
});
Copy after login

In the app.js file, we first define the Vue.js instance Data attributes, including:

  • name: stores query conditions entered by the user (i.e. user name);
  • result: stores query results;
  • message: stores errors Tip;
  • loading: Identifies whether data is currently being loaded.

Then, we defined two methods:

  • search: send an AJAX request, query user information based on the user name, and update the data attributes based on the query results;
  • update: Send an AJAX request, update user information, and pop up a prompt box.

It should be noted that we use the axios library when sending AJAX requests. According to the API implementation method, you can use the axios.get or axios.put method with corresponding parameters to implement query and Updated features.

Finally, we mount the front-end application by creating a Vue.js instance.

Step 3: Test the application

Now, we can start the server, access the HTML file, and test the application.

First, enter the user name on the page and click the query button. If the query is successful, the email and phone input boxes of the query results will be automatically filled with the user's email and phone information. If the query fails, an error message will be displayed.

Then, we can modify the email and phone information, and click the update button to perform the update operation. After the update is successful, a prompt box will pop up.

Summary

In this article, we introduced through an example how to use Vue.js and AJAX technology to implement the function of updating only part of the column data. Through this example, we can learn the following knowledge points:

  • How to define data properties and methods in Vue.js;
  • How to use template syntax and instructions to implement data binding and dynamic updates;
  • How to use the axios library to send AJAX requests.

Of course, this article is only introduced based on a simple example. If these technologies need to be applied in actual projects, they need to be adjusted and improved according to the specific situation.

The above is the detailed content of How to implement the function of updating only some column data in Vue.js. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1665
14
PHP Tutorial
1270
29
C# Tutorial
1249
24
Frontend Development with React: Advantages and Techniques Frontend Development with React: Advantages and Techniques Apr 17, 2025 am 12:25 AM

The advantages of React are its flexibility and efficiency, which are reflected in: 1) Component-based design improves code reusability; 2) Virtual DOM technology optimizes performance, especially when handling large amounts of data updates; 3) The rich ecosystem provides a large number of third-party libraries and tools. By understanding how React works and uses examples, you can master its core concepts and best practices to build an efficient, maintainable user interface.

React's Ecosystem: Libraries, Tools, and Best Practices React's Ecosystem: Libraries, Tools, and Best Practices Apr 18, 2025 am 12:23 AM

The React ecosystem includes state management libraries (such as Redux), routing libraries (such as ReactRouter), UI component libraries (such as Material-UI), testing tools (such as Jest), and building tools (such as Webpack). These tools work together to help developers develop and maintain applications efficiently, improve code quality and development efficiency.

The Future of React: Trends and Innovations in Web Development The Future of React: Trends and Innovations in Web Development Apr 19, 2025 am 12:22 AM

React's future will focus on the ultimate in component development, performance optimization and deep integration with other technology stacks. 1) React will further simplify the creation and management of components and promote the ultimate in component development. 2) Performance optimization will become the focus, especially in large applications. 3) React will be deeply integrated with technologies such as GraphQL and TypeScript to improve the development experience.

React: The Power of a JavaScript Library for Web Development React: The Power of a JavaScript Library for Web Development Apr 18, 2025 am 12:25 AM

React is a JavaScript library developed by Meta for building user interfaces, with its core being component development and virtual DOM technology. 1. Component and state management: React manages state through components (functions or classes) and Hooks (such as useState), improving code reusability and maintenance. 2. Virtual DOM and performance optimization: Through virtual DOM, React efficiently updates the real DOM to improve performance. 3. Life cycle and Hooks: Hooks (such as useEffect) allow function components to manage life cycles and perform side-effect operations. 4. Usage example: From basic HelloWorld components to advanced global state management (useContext and

React vs. Backend Frameworks: A Comparison React vs. Backend Frameworks: A Comparison Apr 13, 2025 am 12:06 AM

React is a front-end framework for building user interfaces; a back-end framework is used to build server-side applications. React provides componentized and efficient UI updates, and the backend framework provides a complete backend service solution. When choosing a technology stack, project requirements, team skills, and scalability should be considered.

Understanding React's Primary Function: The Frontend Perspective Understanding React's Primary Function: The Frontend Perspective Apr 18, 2025 am 12:15 AM

React's main functions include componentized thinking, state management and virtual DOM. 1) The idea of ​​componentization allows splitting the UI into reusable parts to improve code readability and maintainability. 2) State management manages dynamic data through state and props, and changes trigger UI updates. 3) Virtual DOM optimization performance, update the UI through the calculation of the minimum operation of DOM replica in memory.

The Power of React in HTML: Modern Web Development The Power of React in HTML: Modern Web Development Apr 18, 2025 am 12:22 AM

The application of React in HTML improves the efficiency and flexibility of web development through componentization and virtual DOM. 1) React componentization idea breaks down the UI into reusable units to simplify management. 2) Virtual DOM optimization performance, minimize DOM operations through diffing algorithm. 3) JSX syntax allows writing HTML in JavaScript to improve development efficiency. 4) Use the useState hook to manage state and realize dynamic content updates. 5) Optimization strategies include using React.memo and useCallback to reduce unnecessary rendering.

React and Frontend Development: A Comprehensive Overview React and Frontend Development: A Comprehensive Overview Apr 18, 2025 am 12:23 AM

React is a JavaScript library developed by Facebook for building user interfaces. 1. It adopts componentized and virtual DOM technology to improve the efficiency and performance of UI development. 2. The core concepts of React include componentization, state management (such as useState and useEffect) and the working principle of virtual DOM. 3. In practical applications, React supports from basic component rendering to advanced asynchronous data processing. 4. Common errors such as forgetting to add key attributes or incorrect status updates can be debugged through ReactDevTools and logs. 5. Performance optimization and best practices include using React.memo, code segmentation and keeping code readable and maintaining dependability

See all articles