douchenhui5569 2014-10-13 10:57
浏览 19
已采纳

如何在Cakephp 1.3中自定义查询

I want to write some custom query in cakephp 1.3.17

I write the following in the function in the Users controller

$arrayTemp =array();
$arrayTemp = $this->Users->query('SELECT * FROM ht_users Where id=$id');
$this->set('post',$arrayTemp);
pr($post);

but its getting the following error in the page

Error: Call to a member function query() on a non-object    
File: D:\xamp\htdocs\devworks\app\Controller\UsersController.php    
Line: 1478

Line:1478 means it indicate -> $arrayTemp = $this->Users->query('SELECT * FROM ht_users Where id=$id ');

how I can execute a custome query here plz help

  • 写回答

2条回答 默认 最新

  • dongshang1529 2014-10-13 11:38
    关注

    As Your Model name is User so you need to write custom query as below.

    $arrayTemp =array();
    $id='1'; // For example. $id is whatever id you're receiving here
    $arrayTemp = $this->User->query("SELECT * FROM ht_users Where id = '$id'");
    $this->set('post',$arrayTemp);
    

    Now you can pr($post) in your function.ctp file. If this code is written in index() function then try to print in index.ctp likewise.

    Please try with above code, Let me know if still any issues.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 求解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果