duandunzhuo3234 2018-10-23 15:52
浏览 56
已采纳

使用相同凭据的两个单独连接是否共享一个线程?

In the process of converting mysqli_ functionality in PHP to utilize PDO. I've done a few pages of a CMS for proof of concept, and that lead me down the rabbit hole of persistent connections.

To avoid rambling, essentially I'm making a connection to the mysql server using the old method of mysqli_connect, as well as creating a new PDO resource, however, I'm only seeing one open thread. Since they're both using the same credentials to connect, are they sharing the open thread? Any additional info is also appreciated.

Thanks!

Unfortunately the code is government owned, but I can post some condensed snippets if that helps.

Database class connect method:

try {
        $dsn = "mysql:host="._DBLocation.";dbname="._DBName.";charset=utf8mb4";
        $options = [
        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::ATTR_EMULATE_PREPARES   => false,
            PDO::ATTR_PERSISTENT                 => true
        ];

        $dbh = new PDO($dsn,_DBUser,self::db_pass(),$options);
        self::$conn = $dbh;
        return $dbh;

    }
    catch (exception $e) {
        print $e->getMessage();
    }

The db_pass method grabs the password from a text file on a remote server. The class is just invoked via $pdo = CLASS::connect();

The mysqli connection is simmilar, however it's made once and was being stored in a session. Password is retrieved the same way and also uses preset constants for the db location and name.

$_SESSION['sql'] = mysqli_connect(_DBLocation,_DBUser,$passwordVar);

I hope this helps!

  • 写回答

1条回答 默认 最新

  • dst3605528 2018-10-23 16:14
    关注

    You could create a DbHandler class and call the appropriate variable when you need it.

    Note: This is example code - you may need to alter to fit your codebase.

    class DbHandler
    {
        protected $pdo;
        protected $mysqli;
    
        public function __construct($pdo, $mysqli)
        {
            $this->pdo = $pdo;
            $this->mysqli = $mysqli;
        }
    }
    

    then use it like this:

    $dbHandler = new DbHandler(new PDO(.. pdo deets ..), mysqli_connect(.. mysqli deets ..));
    
    print_r($DbHandler->pdo); # will output a PDO object
    print_r($DbHandler->mysqli); # will output whatever mysqli is.. an array? Not sure
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
  • ¥20 怎么在stm32门禁成品上增加查询记录功能