Question

thinkphp 连贯操作

$members=$model->query("
SELECT zhope_card.id AS Id,
zhope_card.cid AS Card_id,
zhope_user.name AS Card_name,
zhope_tpl.name AS Tpl_name,
zhope_cus.name AS Cus_name,
zhope_city.name AS Cus_city,
COUNT(zhope_cali.cid) AS Jz_count ,
DATE(MAX(zhope_cali.adddate)) AS Jz_last,
DATEDIFF(ADDDATE(CURDATE(), INTERVAL 1 YEAR),DATE(zhope_cali.adddate)) AS Jz_time
FROM zhope_card
LEFT JOIN zhope_user ON zhope_card.adduser=zhope_user.id
LEFT JOIN zhope_tpl ON zhope_card.tpl=zhope_tpl.id
LEFT JOIN zhope_cus ON zhope_card.woner=zhope_cus.id
LEFT JOIN zhope_city ON zhope_cus.aera=zhope_city.id
LEFT JOIN zhope_cali ON zhope_card.id=zhope_cali.cid
GROUP BY zhope_card.id
ORDER BY zhope_card.id;
");

我这个SQL语句如果化为Thinkphp 的连贯操作，怎么写？~~~最好能再用别名简化下。谢谢

Answer 1

很简单，首先你要明白D()和M()的区别。

我这里简单举例:
$model = M('user_list');

$model->where('user_name = "你好"')->select();

与

$model->where('user_name = "你好"');

$model->limit(5)->select();

是一样的，主要是以select() find() findAll() 这类结束函数出现时，语言才会被执行，否则可以一直组装。

位置在

Lib/Think/Core/Model.class.php
打字不易，如满意，望采纳。