MysqliMultiQueryinOOPsPHP

Mysqli Multi Query是一种在PHP中使用Mysqli的语法，它允许同时执行多个查询。在面向对象的编程中，我们可以使用以下代码示例来实现Mysqli Multi Query：

<?php
class MysqliMultiQuery{
    private $conn;

    public function __construct($servername, $username, $password, $dbname){
        $this->conn = new mysqli($servername, $username, $password, $dbname);
        if ($this->conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }
    }

    public function multi_query($sql){
        if ($this->conn->multi_query($sql)) {
            $result = array();
            $i = 0;
            do {
                /* store first result set */
                if ($res = $this->conn->store_result()) {
                    while ($row = $res->fetch_assoc()) {
                        $result[$i][] = $row;
                    }
                    $res->free();
                }
                /* print divider */
                if ($this->conn->more_results()) {
                    $i++;
                }
            } while ($this->conn->next_result());
            return $result;
        } else {
            return false;
        }
    }

    public function close_conn(){
        $this->conn->close();
    }
}

这个类的使用方法如下所示：

<?php
include 'MysqliMultiQuery.php';
$obj = new MysqliMultiQuery('localhost', 'root', '', 'db_test');
$sql = "SELECT * FROM users; SELECT * FROM products;";
$result = $obj->multi_query($sql);
var_dump($result);
$obj->close_conn();

这将输出两个查询的结果，一个包含users表的所有行，另一个包含products表的所有行。