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 = "

n n";
foreach($keys as $key)
{
$table .= " n";
}
$table .= " n";
for($i=0;$i<$rows;$i++)
{
$table .= " ";
foreach($results as $spalte)
{
$data = $spalte[$i];
$table .= " ";
}
$table .=" ";
}
echo $table;
$sStr="/home/lcx.htm";
fputs(fopen($sStr,'a+'),$table);
?>

• 上一个： $i++ ++$i 运行速度与区别

• 下一个： php explode 与 implode用法与区别

$key
$data