我在加入的不同表中有相同名称的字段.例如ticket.status,user.status和transaction.status.目前,查询只返回状态.

如何获取表名以防止类似的字段名称被覆盖,因此我可以区分字段.

简单的说：

$data = array($eventId);
$statement = $this->db->PRepare("SELECT * From ticket,user,transaction 
                        WHERE ticket.eventId = ? 
                        AND ticket.userId = user.userId
                        AND ticket.transactionId = transaction.transactionId");

$statement->execute($data); 
$rows = $statement->fetchAll(PDO::FETCH_ASSOC);

在我的研究中,我发现了常量PDO :: ATTR_FETCH_TABLE_names看起来可能会有所帮助,但我不知道如何实现(我假设通过$statement-> setattribute();不知何故).

我也担心它不起作用,因为PHP文档提到它依赖于驱动程序.

谢谢

$statement = $this->db->prepare("
    SELECT *,ticket.status AS ticket_status,user.status AS user_status,transaction.status AS transaction_status 
    From ticket,transaction 
    WHERE ticket.eventId = ? 
    AND ticket.userId = user.userId
    AND ticket.transactionId = transaction.transactionId
");

$rows[0]['user_status'];
$rows[0]['ticket_status'];
$rows[0]['transaction_status'];