一个php导出oracle库的php代码

发布时间：2020-12-13 05:31:31 所属栏目：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,PASSW

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);
?>
第二种方法：

代码如下:

sql check ! 
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 .= "} 
} 
fputs(fopen("$filename","a+"),"unset($values); 
} 
?>

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

$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"; foreach($keys as $key) { $table .= "	$key
$data

$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";
foreach($keys as $key)
{
$table .= "

$key

$data