PHP中的oci查询返回数组不起作用

Question

Using print_r bellow simply prints Array ().

Why is this not working?

$conn = oci_connect("wwbms_admin", "wwbms_admin", "PDBQA");

$sql = "SELECT COUNTRY_ID, DESCRIPTION FROM COUNTRY";
$query_country = oci_parse($conn, $sql);

$list = array();

$result = oci_execute($query_country, OCI_DEFAULT);

while(($row = oci_fetch_assoc($query_country))) {
$items[$row['DESCRIPTION']] = $row['DESCRIPTION'];
}

print_r($list);

oci_close($conn);

Any help would be great, thanks.

Answer 1

You set $list to an empty array(), then you run print_r on it. You never set it again. You're getting predictable results.

Maybe you meant to print_r($items);?