1、在php中实现查询CLOB类型的字段DETAIL
public function getProductClob($id) {
$db_str = ''XXX.XX.XX.XX:3306';//ip
$usename = 'root';//用户名
$pwd = '123456';//密码
$link = oci_connect($usename, $pwd, $db_str, 'UTF8');
if (!$link) {
$error = '';
exit($error);
}
$sql = "SELECT t.DETAIL as DETAIL FROM T_PRODUCT t WHERE PROD_ID={$id}";
$result = oci_parse($link, $sql);
oci_execute($result);
if ($result) {
while ($row = oci_fetch_array($result, OCI_ASSOC + OCI_RETURN_LOBS)) {
oci_free_statement($result);
oci_close($link);
return $row['DETAIL'];
}
}
oci_free_statement($result); //释放资源 释放关联于 Oracle 游标或语句的资源,该资源是作为 oci_parse() 的结果或者是从 Oracle 取得
oci_close($link); //关闭数据库连接
return '';
}
2、php查询mysql中的mediumtext(或TEXT)类型的数据
public function getProductDetailClob($id)
{
$host = 'xxx.xx.xx.xx:3306';
$usename = 'root';
$pwd = '123456';
$mysql_database='database';
$con = mysql_connect($host,$usename,$pwd);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($mysql_database,$con); //打开数据库
mysql_query("set names 'utf8'"); //数据库输出编码
// mysql_query("SETTEXTSIZE65536"); //设置TEXT类型最大值65536
$sql = "SELECT t.DETAIL as DETAIL FROM T_PRODUCT t WHERE PROD_ID={$id}";
$query=mysql_query($sql);
$result= mysql_fetch_row($query);
return $result;
}
