swoole学习之mysql的error坑笔记

我会带着你远行 2022-12-21 03:22 239阅读 0赞

### swoole学习之mysql的坑笔记 ###

*   *  一、PHP Fatal error: Uncaught Error: Class 'Swoole\\Mysql' not found in
     *   *  错误分析
         *  解决方案
     *  二、PHP Fatal error: Uncaught Swoole\\Error: operation not support (reactor is not ready)

## 一、PHP Fatal error: Uncaught Error: Class ‘Swoole\\Mysql’ not found in ##

### 错误分析 ###

原代码

<?php
    
    class MysqlService
    { 
        //定义一个变量
        public $dbSource = '';
        public $dbConfig = '';
    
        //定义构造函数
        public function __construct()
        { 
            //实例化mysql服务
            $this->dbSource = new Swoole\Mysql;
    
            //配置mysql参数
            $this->dbConfig = array(
                'host' => '127.0.0.1',
                'port' => '3306',
                'user' => 'root',
                'password' => '123456',
                'database' => 'qipa250',
                'charset' => 'utf8',
            );
        }
    }
    
    //实例化类
    
    $db = new MysqlService();

执行命令

> php mysqlService.php

报错

PHP Fatal error:  Uncaught Error: Class 'Swoole\Mysql' not found in /data/web/swoole_mooc/io/mysqlService.php:14
    Stack trace:
    #0 /data/web/swoole_mooc/io/mysqlService.php(70): MysqlService->__construct()
    #1 {main}
      thrown in /data/web/swoole_mooc/io/mysqlService.php on line 14
    
    Fatal error: Uncaught Error: Class 'Swoole\Mysql' not found in /data/web/swoole_mooc/io/mysqlService.php:14
    Stack trace:
    #0 /data/web/swoole_mooc/io/mysqlService.php(70): MysqlService->__construct()
    #1 {main}
      thrown in /data/web/swoole_mooc/io/mysqlService.php on line 14

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70_pic_center]

这个错误是因为用了异步回调模块，swoole 4.3.0版本后已经移除了异步模块，所以会报错没有找到swoole\_mysql模块，用Swoole\\Mysql一样报错

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70_pic_center 1]

### 解决方案 ###

1、用Corotuine协程模块代替  
2、回退到旧版本swoole(不推荐)

$this->dbSource = new Swoole\Coroutine\MySQL();

## 二、PHP Fatal error: Uncaught Swoole\\Error: operation not support (reactor is not ready) ##

这个错是因为没有用协程方式运行脚本，而直接用了php运行，需要在代码外面套个go(function()\{ …这里写内容\}，才能正常运行！

<?php
    class MysqlService
    { 
    
        //定义一个变量
        public $dbSource = '';
        public $dbConfig = '';
    
        //定义构造函数
        public function __construct()
        { 
            //实例化mysql服务
            $this->dbSource = new Swoole\Coroutine\MySQL();
    
            //配置mysql参数
            $this->dbConfig = array(
                'host' => '127.0.0.1',
                'port' => '3306',
                'user' => 'root',
                'password' => '123456',
                'database' => 'qipa250',
                'charset' => 'utf8',
            );
        }
    
        public function execute()
        { 
            // 连接
            go(function () { 
                $this->dbSource->connect($this->dbConfig);
                $res = $this->dbSource->query('select * from qipa_member');
                if ($res === false) { 
                    return;
                }
                var_dump($res);
                // 关闭连接
                $this->dbSource->close();
            });
        }
    
    }
    //实例化类
    $db = new MysqlService();
    $db->execute();
    
    ?>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70_pic_center]: /images/20221120/2672cb0180cf4b788f62df8ebfc7a757.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n_size_16_color_FFFFFF_t_70_pic_center 1]: https://img-blog.csdnimg.cn/20201114131537911.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2d1b19xaWFuZ3FpYW5n,size_16,color_FFFFFF,t_70#pic_center