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

workerman常用组件-MySQL组件-workerman之使用Workerman-MySQL - 具体MySQL的Connection用法-刪除

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

 實例哥：

<?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->delete('phome_ecms_news')->where('ID=114')->query();
// 等价于
    $row_count = $db->query("DELETE FROM `phome_ecms_news` 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.
 
有客戶端訪問並觸發了上面服務實例中的onMessage事件時並部署了sql追蹤器時：
2021-12-22T15:06:51.664166Z     7 Prepare DELETE FROM `phome_ecms_news` WHERE ID=114
2021-12-22T15:06:51.664296Z     7 Execute DELETE FROM `phome_ecms_news` WHERE ID=114
2021-12-22T15:06:51.665235Z     7 Prepare DELETE FROM `phome_ecms_news` WHERE ID=114
2021-12-22T15:06:51.665353Z     7 Close stmt
2021-12-22T15:06:51.665391Z     7 Execute DELETE FROM `phome_ecms_news` WHERE ID=114
2021-12-22T15:06:51.666489Z     7 Prepare DELETE FROM `phome_ecms_news` WHERE ID=114
2021-12-22T15:06:51.666662Z     7 Close stmt
2021-12-22T15:06:51.666706Z     7 Execute DELETE FROM `phome_ecms_news` WHERE ID=114
2021-12-22T15:06:51.667623Z     7 Prepare DELETE FROM `phome_ecms_news` WHERE ID=114
2021-12-22T15:06:51.667726Z     7 Close stmt
2021-12-22T15:06:51.667747Z     7 Execute DELETE FROM `phome_ecms_news` WHERE ID=114