title: PHP connecting Oracle and mySQL
body: <p>I' trying to get some data from Oracle via ODBC to mySQL database.
  And then Insert some lines in mySQL database.
  I manage to list the lines from ORACLE but fail to Insert into mySQL.</p>
  
  <pre><code>$time_start = microtime(true);
  
  set_time_limit(10000);
  
  //ligação ODBC ORACLE
  
  $connect = odbc_connect("test", "test", "test");
  
  $query = "select barcod, to_char(barfecgen, 'YYYY-MM-DD') as data, barnumuni, barcolnom, clicod from barcad where barcodreo = 1";
  
  $result = odbc_exec($connect, $query);
  
  $numOF = 0;
  
  // Ligação mySQL
  
  $con = mysql_connect("localhost","root","intranet");
  
  if (!$con)
  
    {
  
    die('Erro de ligação mySQL: ' . mysql_error());
  
    }
  
  
  mysql_select_db("bd_test", $con);
  
  
  ?&gt;
  
   &lt; table border="0" align="center" cellpadding="8" cellspacing="1"&gt;
  
      &lt; tr class="cabecalho_tabela"&gt;
  
        &lt; td bgcolor="#666666"&gt;&lt;strong&gt;#&lt;/strong&gt;&lt;/td&gt;
        &lt; td bgcolor="#666666"&gt;&lt;strong&gt;Ordem de Servi&amp;ccedil;o&lt;/strong&gt;&lt;/td&gt;
        &lt; td bgcolor="#666666"&gt;&lt;strong&gt;Data entrada&lt;/strong&gt;&lt;/td&gt;
        &lt; td bgcolor="#666666"&gt;&lt;strong&gt;Kg entrada&lt;/strong&gt;&lt;/td&gt;
        &lt; td bgcolor="#666666"&gt;&lt;strong&gt;Artigo&lt;/strong&gt;&lt;/td&gt;
        &lt; td bgcolor="#666666"&gt;&lt;strong&gt;C&amp;oacute;digo do cliente&lt;/strong&gt;&lt;/td&gt;
      &lt; /tr&gt;
      &lt;?php
   while(odbc_fetch_row($result)){
  
     $of1 = odbc_result($result, 1);//Ordem de servi&amp;ccedil;o
  
    $of2 = odbc_result($result, 2);//Data de Entrada
  
     $of3 = odbc_result($result, 3);//kg entrada
  
     $of4 = odbc_result($result, 4);//Artigo
  
     $of5 = odbc_result($result, 5);//Cliente
  
     $numOF++;
  
    $minhadata = substr(odbc_result($result, 2), 0, 4);
  
    if ($minhadata == "2010") {
  
     $corlinha = "linha_tabela_alt";
  
     // insere registos
  
     $mysql_query = ("INSERT INTO bd_test.tb_reclamacoes (data_entrada, ordem_servico, cliente, kg_entrada, artigo) VALUES ($of2, $of1, $of5, $of3, $of4)");
  
    } else {
  
     $corlinha = "linha_tabela";
    }
  
     ?&gt;
  
      &lt; tr class="&lt;?php echo $corlinha; ?&gt;"&gt;
        &lt; td align="righ t" bgcolor="#CCCCCC"&gt;&lt;?php echo $numOF; ?&gt;&lt;/td&gt;
        &lt; td bgcolor="#CCCCCC"&gt;&lt;?php echo $of1; ?&gt;&lt;/td&gt;
        &lt; td align="center" bgcolor="#CCCCCC"&gt;&lt;?php echo $of2; ?&gt;&lt;/td&gt;
        &lt; td align="right" bgcolor="#CCCCCC"&gt;&lt;?php echo $of3; ?&gt;&lt;/td&gt;
        &lt; td align="center" bgcolor="#CCCCCC"&gt;&lt;?php echo $of4; ?&gt;&lt;/td&gt;
        &lt; td align="right" bgcolor="#CCCCCC"&gt;&lt;?php echo $of5; ?&gt;&lt;/td&gt;
      &lt; /tr&gt;
      &lt;?php
  }
    ?&gt;
    &lt; /table&gt;
  &lt;?php
  odbc_close($connect);
  mysql_close($con);
  $time_end = microtime(true);
  $time = $time_end - $time_start;
  echo "Tempo de Script: $time segundos\n";
  </code></pre>