仅返回每一行值的第一个字母。

Question

对于通常通过查询数组进行的简单的foreach循环，我有点问题。我试图从一行中指定单个字段值，但它只返回每个字段的第一个字母。新的保监处，因此，任何帮助将不胜感激。

$custcart = oci_parse($conn,"SELECT * FROM A113222813_CARTLINE WHERE CUST_ID=  
:cust_id");
oci_bind_by_name($custcart, ":cust_id", $_SESSION["CUST_ID"]);

if (!$custcart) {
    echo "There was an error. Please wait wwhile we redirect you.";
    $url ="login.php";
    $time_out = 5;
    header("refresh: $time_out; url=$url");
}

oci_execute($custcart);
include 'includes/header.php';

while ($row = oci_fetch_array($custcart, OCI_ASSOC)) {
    foreach ($row as $item) {
        echo $item['CART_NAME'];

    }
}

Answer 1

while正在遍历所有返回的行。然后，您将对该行进行foreach操作，并访问该行中的列(不要这样做)。您只需要while和access CART_NAME in $row

while ($row = oci_fetch_array($custcart, OCI_ASSOC)) {
    echo $row['CART_NAME'];
}

如果要将行存储在数组中以便在脚本中多次使用，则：

while ($row[] = oci_fetch_array($custcart, OCI_ASSOC)) { }

//now or later

foreach ($row as $item) {
    echo $item['CART_NAME'];
}