swoole协程 MySQL 客户端

r囧r小猫 2023-10-06 18:56 54阅读 0赞

#### swoole协程 MySQL 客户端 ####

*  事务、更新、查询

## 事务、更新、查询 ##

<?php
    
    use Swoole\Coroutine\MySQL;
    use function Swoole\Coroutine\run;
    
    run(function () {
        
        $db = new MySQL();
        $ret1 = $db->connect([
            'host'     => '127.0.0.1',
            'port'     => 3306,
            'user'     => 'root',
            'password' => 'ecece8577f2a660a',
            'database' => 'mysqldemo',
        ]);
        
        // $stmt = $db->prepare('SELECT * FROM Users WHERE Users_Id=?');
        // if ($stmt == false) {
        
        //     var_dump($db->errno, $db->error);
        // } else {
        
        //     $ret2 = $stmt->execute(array(10));
        //     var_dump($ret2);
    
        //     $ret3 = $stmt->execute(array(13));
        //     var_dump($ret3);
        // }
        
     //    $db->begin();
    	// $db->query("update Users set Banned = 22 where Users_Id = 1");
    	// $db->commit();
    	
    	$stmt = $db->prepare('update Users set Banned = ? where Users_Id = ?');
    
        if ($stmt == false) {
        
            var_dump($db->errno, $db->error);
        } else {
        
            $ret2 = $stmt->execute(array('ws',10));
            var_dump($ret2);
        }
    
    });

[root@bogon swoole]# php AysMysql.php 
    bool(true)

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

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaWd1YW5nMTAy_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/24394556631c49059e2758ca774cb10b.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaWd1YW5nMTAy,size_16,color_FFFFFF,t_70