php 操作oracle类,php 操作 Oracle数据代码

提供一款超简单的php Oracle 数据库 导出代码哦。

提供一款超简单的php  Oracle 数据库 导出代码哦。

$conn=OCILogon("用户名","密码","(DESCRIPTION=(ADDRESS=(PROTOCOL =TCP)(HOST=IP)(PORT = 1521))(CONNECT_DATA =(SID=lcx)))");

//$sql="select * from all_tab_columns where table_name='MEMBER'";//Table Structure

$sql="select USER_ID,PASSWORD from MEMBER where IDX < 100";//sql语句

$stmt = OCIParse($conn, $sql);

OCIExecute($stmt);

$rows = OCIFetchstatement($stmt,$results);

$keys = array_keys($results);

$table = "

foreach($keys as $key)

{

$table .= "

$keyn";

}

$table .= "

n";

for($i=0;$i

{

$table .= "

";

foreach($results as $spalte)

{

$data = $spalte[$i];

$table .= "

$data";

}

$table .="

";

}

echo $table;

$sStr="/home/lcx.htm";

fputs(fopen($sStr,'a '),$table);

?>