dtx6087 2016-06-24 13:44
浏览 84
已采纳

使用php中的pdo与数据库链接服务器进行查询

I'm facing a problem right now, i explain :

I have my SQL query :

SELECT COUNT(*) AS nb, TO_CHAR(myDate,'yyyy-mm-dd') AS dateF, T1.IDCar, T2.IDMotor
FROM TDB2@MYLINKSERVER,T1
JOIN T2 ON T1.ID = T2.ID
WHERE TDB2.IDCar = T1.IDCar

Which use a TDB2@MYLINKSERVER , to connect 2 differents databases from Oracle and use a table from and other database.

In fact, when i launch the query in sql developper, my query returns some datas.

So in php, i have

$sql = $pdo->prepare('myquerybefore')
$sql->execute(array($annee));
$res = $sql->fetchAll(PDO::FETCH_ASSOC);

And when i try to vardump my $res, it returns array(0) { } So i think that PDO don't use the @LINKSERVER to fetch results.

Any help would be appreciated Sleakerz,

  • 写回答

1条回答 默认 最新

  • drn5375 2016-06-27 11:43
    关注

    I found a way to make my query work : I create a synonym with

    CREATE PUBLIC SYNONYM LINKDATABASE 
       FOR TABLE1@THELINKDATABASE;
    

    Then i have in my query: FROM LINKDATABASE which is my synonym !

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?