请问php如何调用oracle数据

Question

mysql数据库已经连接好，现在想要在oracle数据库里面抓取数据，然后写入mysql数据里面...请问如何操作
自己写的，但是无法写入mysql里面...<?php 
require('conn.php'); //查询   
   
   
$stmt   =   OCIParse($conn,"SELECT FID,FBH,FMC,FDJ,FGG,FZL,FTJ FROM T_CPZL");   
  
  OCIDefineByName($stmt,"FID",&$FID);   
  OCIDefineByName($stmt,"FBH",&$FBH); 
 OCIDefineByName($stmt,"FMC",&$FMC);
 OCIDefineByName($stmt,"FDJ",&$FDJ);
 OCIDefineByName($stmt,"FGG",&$FGG);
 OCIDefineByName($stmt,"FZL",&$FZL);
 OCIDefineByName($stmt,"FTJ",&$FTJ); 
 OCIExecute($stmt); 
 
$sql="insert into jos_vm_product(fid,product_sku,product_name,product_url,product_length,product_weight,product_width) values ($FID,$FBH,$FMC,$FDJ,$FGG,$FZL,$FTJ)";//写入数据的sql语句 

Answer 1

$stmt=ociparse($con,$sql);
ociexecute($stmt);