How to use Swoole to implement WebSocket server and database interaction

How to use Swoole to implement WebSocket server and database interaction

Introduction:
WebSocket is a full-duplex communication protocol based on the TCP protocol, which can be used on the client Establish real-time two-way communication with the server. Swoole is a PHP extension that can easily implement high-performance asynchronous and concurrent programming. In this article, we will introduce in detail how to use Swoole to build a WebSocket server and interact with the database.

Step 1: Install the Swoole extension

First, we need to install the Swoole extension. It can be installed through the following command:

pecl install swoole

Step 2: Create a WebSocket server

Next, we create a WebSocket server, listen to the specified port, and establish a connection with the client. This can be achieved using the following code:

<?php
$server = new SwooleWebSocketServer("0.0.0.0", 9501);

$server->on('open', function (SwooleWebSocketServer $server, $request) {
    echo "new connection open: {$request->fd}
";
});

$server->on('message', function (SwooleWebSocketServer $server, $frame) {
    echo "received message: {$frame->data}
";

    // 处理数据库交互
    $db = new mysqli('localhost', 'username', 'password', 'database');
    $result = $db->query("SELECT * FROM users");
    while ($row = $result->fetch_assoc()) {
        $server->push($frame->fd, json_encode($row));
    }
    $db->close();
});

$server->on('close', function ($ser, $fd) {
    echo "connection close: {$fd}
";
});

$server->start();
?>

In the above code, we create a WebSocket server and add three event callback functions. When a connection is established, the open event will be triggered; when a message is received, the message event will be triggered; when the connection is closed, the close event will be is triggered. In the message event, we can perform database interactive operations.

Step 3: Interact with the database

In the message event callback function, we use the MySQLi extension to interact with the database. First, we create a $db object and connect to the database using the constructor of mysqli. Next, we executed a query statement and sent the query results to the client through a while loop. Finally, we close the database connection.

It should be noted that for security reasons, we should set the relevant information of the database (such as user name and password) as environment variables and obtain these values ​​through the getenv() function, to avoid direct exposure to code.

Step 4: Run the server

Finally, we use the command line to run the above code. Switch to the directory where the code is located on the command line and execute the following command:

php server.php

If everything goes well, you will see that the WebSocket server starts successfully and is waiting for the client to connect. When a client connects to the server, the open event will be triggered and the connection ID will be displayed on the command line. When a message from the client is received, the message event will be triggered and the received message will be displayed on the command line. When the connection is closed, the close event will be triggered, and the closure of the connection will also be displayed on the command line.

Summary:
This article details how to use Swoole to implement the interaction between the WebSocket server and the database. By creating a WebSocket server and performing database interaction in the message event callback function, we can achieve real-time two-way communication. Using Swoole extensions, we can easily perform high-performance asynchronous and concurrent programming. I hope this article will be helpful to you in using Swoole to interact with the database.

The above is the detailed content of How to use Swoole to implement WebSocket server and database interaction. For more information, please follow other related articles on the PHP Chinese website!