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

workerman常用组件-MySQL组件-workerman之使用Workerman-MySQL - 具体MySQL的Connection用法-插入

发布时间：2021-12-22 22:52:16编辑：雪饮阅读（）

 實例哥：

<?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;
// 插入
    $insert_id = $db->insert('phome_ecms_news')->cols(array(
        'classid'=>27,
        'newspath'=>'/kasumi',
        'filename'=>'kasumi.mp4',
        'username'=>"snowDrink"))->query();
   // 等价于
$insert_id = $db->query("INSERT INTO `phome_ecms_news` ( `classid`,`newspath`,`filename`,`username`)
VALUES ( 27, '/kasumi', 'kasumi.mp4','snowDrink')");
 
   $response= $db->select('*')->from('phome_ecms_news')->where('filename= :filename AND username = :username')->bindValues(array('filename'=>'kasumi.mp4', 'username' => 'snowDrink'))->query();
    $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.