php - 使用 PDO 返回非关联数组

Question

以下将返回 array('a'=>123,'b'=>'abc','c'=>null)

$sql='SELECT a,b,c FROM myTable WHERE id=123';
$stmt = $conn->query($sql);
$rs= $stmt->fetch(PDO::FETCH_ASSOC);

是否可以返回 array(123,'abc',null) 而无需执行类似 array($rs['a'],$rs['b'], $rs['c'])?

Answer 1

试试 PDO::FETCH_NUM

$sql='SELECT a,b,c FROM myTable WHERE id=123';
$stmt = $conn->query($sql);
$rs= $stmt->fetch(PDO::FETCH_NUM);