{"id":41,"date":"2024-08-14T15:42:04","date_gmt":"2024-08-14T07:42:04","guid":{"rendered":"https:\/\/www.linhw.cn\/?p=41"},"modified":"2024-08-14T15:42:04","modified_gmt":"2024-08-14T07:42:04","slug":"%e7%ae%80%e5%8d%95-php-%e6%95%b0%e6%8d%ae%e5%ba%93%e8%bf%9e%e6%8e%a5%e6%b1%a0%e7%b1%bb%e8%ae%be%e8%ae%a1%ef%bc%9a","status":"publish","type":"post","link":"https:\/\/www.linhw.cn\/index.php\/2024\/08\/14\/%e7%ae%80%e5%8d%95-php-%e6%95%b0%e6%8d%ae%e5%ba%93%e8%bf%9e%e6%8e%a5%e6%b1%a0%e7%b1%bb%e8%ae%be%e8%ae%a1%ef%bc%9a\/","title":{"rendered":"\u7b80\u5355 PHP \u6570\u636e\u5e93\u8fde\u63a5\u6c60\u7c7b\u8bbe\u8ba1\uff1a"},"content":{"rendered":"\n

<\/h2>\n\n\n\n
      class DatabaseConnectionPool {\n\n    private $host;\n    private $username;\n    private $password;\n    private $database;\n    private $maxConnections;\n    private $connectionPool = [];\n    private $usedConnections = [];\n\n    public function __construct($host, $username, $password, $database, $maxConnections = 10) {\n        $this->host = $host;\n        $this->username = $username;\n        $this->password = $password;\n        $this->database = $database;\n        $this->maxConnections = $maxConnections;\n\n        $this->initialize(); \/\/ \u521d\u59cb\u5316\u8fde\u63a5\u6c60\n    }\n\n    \/\/ \u521d\u59cb\u5316\u8fde\u63a5\u6c60\n    private function initialize() {\n        for ($i = 0; $i < $this->maxConnections; $i++) {\n            $this->connectionPool[] = $this->createConnection();\n        }\n    }\n\n    \/\/ \u521b\u5efa\u65b0\u7684\u6570\u636e\u5e93\u8fde\u63a5\n    private function createConnection() {\n        $connection = new mysqli($this->host, $this->username, $this->password, $this->database);\n        if ($connection->connect_error) {\n            throw new Exception(\"Connection failed: \" . $connection->connect_error);\n        }\n        return $connection;\n    }\n\n    \/\/ \u4ece\u8fde\u63a5\u6c60\u83b7\u53d6\u8fde\u63a5\n    public function getConnection() {\n        if (!empty($this->connectionPool)) {\n            $connection = array_pop($this->connectionPool);\n            $this->usedConnections[] = $connection;\n            return $connection;\n        } else {\n            \/\/ \u8fde\u63a5\u6c60\u5df2\u6ee1\uff0c\u53ef\u4ee5\u7b49\u5f85\u6216\u629b\u51fa\u5f02\u5e38\n            throw new Exception(\"Connection pool is full.\"); \n        }\n    }\n\n    \/\/ \u91ca\u653e\u8fde\u63a5\uff0c\u5c06\u5176\u653e\u56de\u8fde\u63a5\u6c60\n    public function releaseConnection($connection) {\n        $key = array_search($connection, $this->usedConnections);\n        if ($key !== false) {\n            unset($this->usedConnections[$key]);\n            $this->connectionPool[] = $connection;\n        }\n    }\n\n    \/\/ \u9500\u6bc1\u8fde\u63a5\u6c60\uff0c\u5173\u95ed\u6240\u6709\u8fde\u63a5\n    public function __destruct() {\n        foreach (array_merge($this->connectionPool, $this->usedConnections) as $connection) {\n            $connection->close();\n        }\n    }\n}<\/code>\n    <\/pre>\n\n\n\n
\u4f7f\u7528\u65b9\u6cd5\uff1a<\/strong><\/p>\n\n\n\n
      \/\/ \u521b\u5efa\u8fde\u63a5\u6c60\u5bf9\u8c61\n$pool = new DatabaseConnectionPool(\"localhost\", \"user\", \"password\", \"database\", 10);\n\n\/\/ \u83b7\u53d6\u8fde\u63a5\n$connection = $pool->getConnection();\n\n\/\/ \u6267\u884c\u6570\u636e\u5e93\u64cd\u4f5c...\n\n\/\/ \u91ca\u653e\u8fde\u63a5\n$pool->releaseConnection($connection);<\/code>\n    <\/pre>\n\n\n\n
\u8bf4\u660e\uff1a<\/strong><\/p>\n\n\n\n