一个php导出oracle库的php代码

　　<?php
$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 = <table>\n <TR>\n;
foreach($keys as $key)
{
$table .= <TH>$key</TH>\n;
}
$table .= </TR>\n;
for($i=0;$i<$rows;$i++)
{
$table .= <TR>;
foreach($results as $spalte)
{
$data = $spalte[$i];
$table .= <TD>$data</TD>;
}
$table .= </TR>;
}
echo $table;
$sStr=/home/lcx.htm;
fputs(fopen($sStr,a+),$table);
?>
第二种方法：
复制代码 代码如下:
<meta http-equiv=Content-Type content=text/html; charset=euc-kr>
<title>sql check !</title>
<?
include $_SERVER[DOCUMENT_ROOT] . /_lib/common.lib.php;
ini_set(max_execution_time, 0);
if(!isset($a) !isset($b) !isset($filename)){exit();}
for($i=$a;$i<$b;$i++)
{
$query = select IDX,USER_ID,PASSWORD,NAME,SID1,SID2,PHONE,MOBILE,EMAIL,WORKPHONE from member where idx = $i;
$data = sql_fetch($query);
if ($data)
{
for ($ss=0; $ss<=count($data); $ss++)
{
$values .= <td>.$data[$ss].</td>;
}
}
fputs(fopen($filename,a+),<table><tr>.$values.</tr></table>\r\n);
unset($values);
}
?>

因为不会oracle，也是一行一行照抄来的，
数据库连接也没接触过，就直接用他自带的吧，
没用foreach 循环数组，很奇怪，总是输出2个重复的字段值，没办法就改用for了
qq:57112848 无名