ÇëÎÊphpÈçºÎµ÷ÓÃoracleÊý¾Ý

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Óï¾ä

---

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