PDO、fetchall和multiquery

Question

好的，我正在做的事情是不可能的(我已经连续两天没睡了……但是，是否可以通过PDO运行多查询并返回所有结果……像这样吗？

$sql = 
"SELECT username, faction FROM users WHERE uid = :uid;". 
"SELECT level, exp, health, luck, first_name, last_name FROM player_information WHERE uid = :uid"; 
    $que = $this->db->prepare($sql);
    $que->bindParam('uid', $uid);
    try{
        $que->execute();
        $row = $que->fetchAll();
        print_r($row);
    }catch(PDOException $e){$e->getMessage(); }

还是我找错人了？

Answer 1

是的，这样的“多查询”被称为连接

SELECT username, faction, level, exp, health, luck, first_name, last_name 
FROM users u, player_information pi WHERE u.uid = pi.uid AND u.uid = :uid

此外，在调用它时使用了错误的运算符

$sql = "SELECT username, faction, level, exp, health, luck, first_name, last_name 
        FROM users u, player_information pi WHERE u.uid = pi.uid AND u.uid = ?";
$stm = $this->db->prepare($sql);
$stm->execute(array($uid));
$row = $que->fetch();
print_r($row);

将以较少的代码给出结果

Answer 2

你应该看看交易：http://www.php.net/manual/en/pdo.transactions.php