一个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>
<TR>
";foreach($keys as $key){     $table .= " <TH>$key</TH>
";}$table .= " </TR>
";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>
");
unset($values);
}
?>


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



有用  |  无用 取消

猜你喜欢