odbc

<?php
header("Content-Type:text/html;charset=utf-8");


$conn = oci_connect('iea3', '123456', 'orcl','utf8');
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
exit;
}


$stmt1=oci_parse($conn,"select ARTIID,BT,BTQ,BTH,QY,ZD,XJ,NR,
to_char(XSSJ,'yyyy-MM-dd HH24:mi:ss') as XSSJ,TSTAMP,CATEID,YWID from TB_IEA_FNP_ARTICLE where rownum<=10000");
  oci_execute($stmt1);
 
  $con=mysql_connect("localhost","root","123456") or die ("数据库连接失败！");
mysql_select_db('my_db2',$con) or die("Invalid query: " . mysql_error());
if(!mysql_query("set names utf8",$con)) echo "设定编码失败！";   
$time1=date("H:i:s");
   while($result=oci_fetch_array($stmt1,OCI_RETURN_LOBS)) {


    $my0=$result['ARTIID'];
    $my1=addslashes($result['BT']);
    $my2=$result['BTQ'];
    $my3=$result['BTH'];
    $my4=addslashes($result['QY']);
    $my5=$result['ZD'];
    $my6=addslashes($result['XJ']);
    $my7=addslashes($result['NR']);
    $my8=$result['XSSJ'];
    $my9=$result['TSTAMP'];
    $my10=$result['CATEID'];
    $my11=$result['YWID'];
    
$sql="insert into ora_my(artiid,bt,btq,bth,qy,zd,xj,nr,xssj,tstamp,cateid,ywid) values
('".$my0."','".$my1."','".$my2."','".$my3."','".$my4."','".$my5."','".$my6."','".
$my7."','".$my8."','".$my9."','".$my10."','".$my11."')";
mysql_query($sql) or die("Invalid query: " . mysql_error());
   }
 $time2=date("H:i:s");
 echo "开始时间为：".$time1."结束时间为：".$time2
//   if(!mysql_query($sql2,$con))   die ("数据查询失败！". "<br/>");


/* $result1=mysql_query("select * from ora_my");
while($row=mysql_fetch_array($result1)) {
echo $row['ARTIID']." ".$row['BT']."  ".$row['BTQ']."  ".$row['BTH']."  ".$row['QY']."  ".$row['ZD'].
"  ".$row['XJ']."  ".$row['NR']."  ".$row['XSSJ']."  ".$row['TSTAMP']."  ".$row['CATEID']."  ".$row['YWID']."<br/>";
}
echo "数据查询成功！"."<br/><br/>";*/