ocinumcols

Example 869. Simple CSV generator

if (!$db = @ocinlogon("dev","dev", "ORCL")) {
    $error = ocierror();
    printf("CONNECT error: %s", $error["message"]);
    die();
}

if (!$stmt = @ociparse($db,"SELECT * FROM phone_numbers")) {
    $error = ocierror($db);
    printf("ociparse error: %s", $error["message"]);
} else {

    if (!@OCIexecute($stmt)) {
        $error = ocierror($stmt);
        printf("OCIEXECUTE Failure. Error was: %s\n", $error["message"]);
    } else {

        $numcols = ocinumcols($stmt);
        for ( $i=0; $i<$numcols; $i++ ) {
            $columns[]=ocicolumnname($stmt, $i+1);
        }
        
        echo join(",", $columns)."\r\n";
    
        // now assemble each row
        while (ocifetch($stmt)) {
            unset($column_data);
            for ( $i=0; $i<$numcols; $i++ ) {
                $column_data[] = ociresult($stmt, $i+1);
            }

            // now join them into $result
            echo join(",", $column_data)."\r\n";
        }

    }
}