使用PDO返回非关联数组

Question

The following will return 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);

Is it possible to return array(123,'abc',null) without doing something like array($rs['a'],$rs['b'],$rs['c'])?

Answer 1

Try PDO::FETCH_NUM

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