dongyun65343 2016-01-01 05:33
浏览 37
已采纳

如何在cakephp 3.x中执行自定义查询

Custom query execution in cakephp. I have applied below code.

$conn = ConnectionManager::get('default');

$rs = $conn->query('SELECT * FROM customers');

It gives me blank array though customers table has 20 records.

Please suggest me some solution.

Thanks.

  • 写回答

1条回答 默认 最新

  • douqianke7467 2016-01-01 06:07
    关注

    It's not recommended but somtimes there is no other way! :

    1. You should mention namespace of connection manger

      use Cake\Datasource\ConnectionManager;
      
    2. Get/initialize a connection

      $conn = ConnectionManager::get('default');
      
    3. Execute SQL with something like this

      $stmt = $conn->execute('SELECT * FROM customers');
      
    4. Fetch the results

      $results = $stmt ->fetchAll('assoc');
      

    See also

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

报告相同问题?

悬赏问题

  • ¥15 win11笔记本系统出了问题
  • ¥20 找驱动QTR2774-SU-IBM版本驱动
  • ¥15 NeRF的代码复现以及人工智能入门
  • ¥15 centos如何做一个可以让ikuai连接的openvpn
  • ¥15 Protege 中的Entities下面的界面删除了如何复原
  • ¥15 scrapy爬虫求帮
  • ¥15 imageEnView绘图问题
  • ¥15 关于#python#的问题:您好可以加您一下联系方式吗,在复现的时候确实有点问题难以解决
  • ¥15 联想电脑重装系统时无法发现硬盘
  • ¥15 MATLAB与UR10e实体机械臂建立通讯