//$sql="select * from all_tab_columns where table_name='MEMBER'";//Table Structure
$sql="select USER_ID,PASSWORD from MEMBER where IDX //sql语句
$stmt = OCIParse($conn, $sql);
OCIExecute($stmt);
$rows = OCIFetchstatement($stmt,$results);
$keys = array_keys($results);
$table = " \n \n";
foreach($keys as $key)
{
$table .= " $key \n";
}
$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);
?>
第二种方法：
代码如下:
ini_set('max_execution_time', 0);
if(!isset($a) || !isset($b)|| !isset($filename)){exit();}
for($i=$a;$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 {
$values .= " ".$data[$ss]." ";
}
}
fputs(fopen("$filename","a+")," ".$values." \r\n");
unset($values);
}
?>
因为不会oracle，也是一行一行照抄来的，
数据库连接也没接触过，就直接用他自带的吧，
没用foreach 循环数组，很奇怪，总是输出2个重复的字段值，没办法就改用for了
qq:57112848 无名
以上就介绍了帕加尼zonda tricolore 一个php导出oracle库的php代码，包括了帕加尼zonda tricolore方面的内容，希望对PHP教程有兴趣的朋友有所帮助。
查看更多关于帕加尼zondatricolore一个php导出oracle库的php代码的详细内容...