php: pdo read clob without bind

Question

$query = "select id, xmldata from xmlcontent where id = '586655' OR id = '671347'"

$db = new PDO(...);
$stmt = $db->prepare($query);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

var_dump($result);

output:

...
["XMLDATA"]=> resource(33) of type (stream)
...

how i can read this? i try:

stream_get_contents()

but nothing

with

stream_get_contents()

sometimes read some litle text, i would like to use and generic code from all SQL-s without binding params :(

What happens if you call [`stream_get_meta_data`](http://us2.php.net/manual/en/function.stream-get-meta-data.php) on the resource? You should get an array with useful information. — Charles, Jan 20 '12 at 21:06
Array ( [stream_type] => pdo_oci blob stream [mode] => r+b [unread_bytes] => 0 [seekable] => [timed_out] => [blocked] => 1 [eof] => ) @Charles — ZiTAL, Jan 23 '12 at 08:49
So, it's read-only, not seekable, not eof, and *is* blocked. That's odd. Unfortunately I have no suggestions... — Charles, Jan 23 '12 at 13:45

score 0 · Answer 1 · answered Sep 28 '15 at 11:02

0

Maybe you're trying to read twice from the same stream or just using old pdo_oci library with a bug (only last stream will be returned on multiple records).

For the last version, compiled from php source on Ubuntu server i just use lazy-load in ActiveRecord class:

public function getFullText()
{
    if (is_resource($this->fulltext)) {
        $this->fulltext = stream_get_contents($this->fulltext);
    }
    return $this->fulltext;
}

Where fulltext is CLOB.

answered Sep 28 '15 at 11:02

UnstableFractal

1,403
2
15
29

PDO_OCI is deprecated and i can compile it to probe it :( – ZiTAL Sep 29 '15 at 08:16
It's deprecated? I thought it was just abandoned as stand-alone extension due to built-in version into PHP itself? – UnstableFractal Sep 29 '15 at 09:10
there is no oracle pdo extension for php in the repos – ZiTAL Sep 30 '15 at 09:58
It was built into PHP itself. – UnstableFractal Sep 30 '15 at 11:45
in gnu/linux? documentation to install it? – ZiTAL Oct 01 '15 at 13:19
1

[Best answer i've found](http://stackoverflow.com/a/31965856/350980) You'll face a lot of problems with Oracle and PDO_OCI, though. For example, BLOB's and CLOB's. I managed to solve most of them for now, but it was not obvious problems. – UnstableFractal Oct 01 '15 at 14:18

php: pdo read clob without bind

1 Answers1