您当前的位置： 首页 > 慢生活 > 程序人生 网站首页程序人生

workerman常用组件-MySQL组件-workerman之使用Workerman-MySQL - 具体MySQL的Connection用法-更新（update）

发布时间：2021-12-22 23:03:30编辑：雪饮阅读（）

 實例哥：

<?php
use Workerman\Worker;
use Workerman\Connection\TcpConnection;
require_once __DIR__ . '/vendor/autoload.php';
 
$worker = new Worker('websocket://0.0.0.0:8484');
$worker->onWorkerStart = function($worker)
{
    global $db;
    // 初始化db连接
    $db = new \Workerman\MySQL\Connection('127.0.0.1', '3306', 'xy', 'xy', 'workerman');
};
$worker->onMessage = function(TcpConnection $connection, $data)
{
    global $db;
    $row_count = $db->update('phome_ecms_news')->cols(array('username'))->where('ID=114')
        ->bindValue('username', 'kasumi')->query();
// 等价于
    $row_count = $db->update('phome_ecms_news')->cols(array('username'=>'kasumi'))->where('ID=114')->query();
// 等价于
    $row_count = $db->query("UPDATE `phome_ecms_news` SET `username` = 'kasumi' WHERE ID=114");
    $response["count"]=$row_count;
    $connection->send(json_encode($response));
};
Worker::runAll();
運行哥：
[root@localhost www.fpm.com]# /usr/local/php734/bin/php channelServer.php start
Workerman[channelServer.php] start in DEBUG mode
------------------------------------------- WORKERMAN --------------------------------------------
Workerman version:4.0.22          PHP version:7.3.4
-------------------------------------------- WORKERS ---------------------------------------------
proto   user            worker          listen                      processes    status
tcp     root            none            websocket://0.0.0.0:8484    1             [OK]
--------------------------------------------------------------------------------------------------
Press Ctrl+C to stop. Start success.
 
 
如果有部署mysql追蹤器，則追蹤器哥在有websocket前端訪問並觸發了上面服務端的onMessage事件時：
2021-12-22T14:59:29.795098Z     6 Prepare UPDATE `phome_ecms_news` SET `username` = ? WHERE ID=114
2021-12-22T14:59:29.795216Z     6 Execute UPDATE `phome_ecms_news` SET `username` = 'kasumi' WHERE ID=114
2021-12-22T14:59:29.796043Z     6 Prepare UPDATE `phome_ecms_news` SET `username` = ? WHERE ID=114
2021-12-22T14:59:29.796146Z     6 Close stmt
2021-12-22T14:59:29.796169Z     6 Execute UPDATE `phome_ecms_news` SET `username` = 'kasumi' WHERE ID=114
2021-12-22T14:59:29.796822Z     6 Prepare UPDATE `phome_ecms_news` SET `username` = 'kasumi' WHERE ID=114
2021-12-22T14:59:29.796928Z     6 Close stmt
2021-12-22T14:59:29.796948Z     6 Execute UPDATE `phome_ecms_news` SET `username` = 'kasumi' WHERE ID=114
2021-12-22T14:59:29.798395Z     6 Prepare UPDATE `phome_ecms_news` SET `username` = ? WHERE ID=114
2021-12-22T14:59:29.798557Z     6 Close stmt
2021-12-22T14:59:29.798582Z     6 Execute UPDATE `phome_ecms_news` SET `username` = 'kasumi' WHERE ID=114
2021-12-22T14:59:29.799555Z     6 Prepare UPDATE `phome_ecms_news` SET `username` = ? WHERE ID=114
2021-12-22T14:59:29.799694Z     6 Close stmt
2021-12-22T14:59:29.799718Z     6 Execute UPDATE `phome_ecms_news` SET `username` = 'kasumi' WHERE ID=114
2021-12-22T14:59:29.800394Z     6 Prepare UPDATE `phome_ecms_news` SET `username` = 'kasumi' WHERE ID=114
2021-12-22T14:59:29.800484Z     6 Close stmt
2021-12-22T14:59:29.800505Z     6 Execute UPDATE `phome_ecms_news` SET `username` = 'kasumi' WHERE ID=114