How to perform add, delete, modify and check operations in php+layui

PHP and Layui are currently very popular web development technologies. PHP is an object-oriented open source general-purpose programming language, while Layui is a lightweight front-end UI framework. In this article, we will discuss how to use PHP and Layui to perform add, delete, modify and query operations.

First, we need a database to store data. Suppose we are using MySQL as the database and we have created a data table named "users" in it. The data table contains the following fields:

• id: user ID, auto-increasing numeric type
• name: username, string type
• email: email address , String type
• password: Password, String type

Next, we need to create a PHP file to connect to the database. In this PHP file, we can use the following code to create a connection:

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检测连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
} 
echo "连接成功";

After the connection is successful, we need to define some functions to perform add, delete, modify and check operations. Here is a sample function that is used to get information about all users from the database:

function getUsers() {
    $sql = "SELECT * FROM users";
    $result = $conn->query($sql);
    
    if ($result->num_rows > 0) {
        // 输出数据
        while($row = $result->fetch_assoc()) {
            echo "id: " . $row["id"]. " - Name: " . $row["name"]. " - Email: " . $row["email"]. "<br>";
        }
    } else {
        echo "0 结果";
    }
}

We also need to write other functions to perform operations such as inserting, updating, and deleting users. For example, here is a sample function that is used to insert a new user into the database:

function addUser($name, $email, $password) {
    $sql = "INSERT INTO users (name, email, password) VALUES ('$name', '$email', '$password')";
    
    if ($conn->query($sql) === TRUE) {
        echo "新纪录插入成功";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}

Specifically, we need to define some input boxes that pass user input parameters. This is where Layui comes in. Layui encapsulates a variety of form components, such as input boxes, buttons, drop-down boxes, etc. We can use these components to implement user interfaces. For example, we can add the following code to the page:

<form class="layui-form" action="">
  <div class="layui-form-item">
    <label class="layui-form-label">用户名</label>
    <div class="layui-input-block">
      <input type="text" name="name" lay-verify="required" placeholder="请输入用户名" autocomplete="off" class="layui-input">
    </div>
  </div>
  
  <div class="layui-form-item">
    <label class="layui-form-label">电子邮件地址</label>
    <div class="layui-input-block">
      <input type="text" name="email" lay-verify="email" placeholder="请输入电子邮件地址" autocomplete="off" class="layui-input">
    </div>
  </div>

  <div class="layui-form-item">
    <label class="layui-form-label">密码</label>
    <div class="layui-input-block">
      <input type="password" name="password" lay-verify="required" placeholder="请输入密码" autocomplete="off" class="layui-input">
    </div>
  </div>

  <div class="layui-form-item">
    <div class="layui-input-block">
      <button class="layui-btn" lay-submit lay-filter="addUser">提交</button>
    </div>
  </div>
</form>

After clicking the submit button, we can use the following code to call the addUser function and insert a new user:

layui.use(['form'], function () {
    var form = layui.form,
        layer = layui.layer;
    
    form.on('submit(addUser)', function (data) {
        //获取用户输入数据
        var name = data.field.name,
            email = data.field.email,
            password = data.field.password;
            
        //调用addUser函数插入新用户
        addUser(name, email, password);
        
        //清空输入框
        $('form')[0].reset();
        
        return false;
    });
});

Similarly, we can use Similar methods create other functions and bind them to the corresponding Layui components to implement the functions of querying, updating, and deleting users.

To sum up, we have learned how to use PHP and Layui to perform add, delete, modify and check operations. Of course, we need to modify and expand it according to actual needs in practical applications.

The above is the detailed content of How to perform add, delete, modify and check operations in php+layui. For more information, please follow other related articles on the PHP Chinese website!