PHP handles Oracle's CLOB instance _php tips

This article illustrates the method of PHP handling Oracle's CLOB. Share to everyone for your reference. The specific methods are as follows:

1. Write Data

When using the preprocessing method of PDO, if you use Bindparam () without specifying the data type of the field or using Execute (), PDO defaults to string type and limits a default length

So you must use Bindparam () or Bindvalue () when you save the Clob type field, and specify the length of the string, for example:

Copy Code code as follows:

$pdo-> Bindparam (': Clobdata ', $clobData, PDO::P Aram_str,strlen ($clobData));

2. Reading data

PDO the Clob field value is a resource identifier when the field is not empty, an empty string, and a data method as follows

Copy Code code as follows:

$arr = $pdo-> fetch ();
Is_resource ($arr [' Clob ']) && $arr [' Clob '] =stream_get_contents ($arr [' Clob ']);

I hope this article will help you with your PHP program design.