ThinkPHP中的CURD操作，ThinkPHPCURD操作

ThinkPHP中的CURD操作，ThinkPHPCURD操作

<span>php
    </span><span>//</span><span>查询多条记录,返回二维数组</span>
    <span>$result</span> = M("admin")-&gt;<span>select();
    </span><span>$result</span> = M("admin")-&gt;where("id&gt;2")-&gt;<span>select();
    </span><span>$result</span> = M("admin")-&gt;where("id&gt;2")-&gt;order("id desc")-&gt;limit("0,5")-&gt;field("id,username,psssword")-&gt;<span>select();
    </span><span>$result</span> = M("admin")-&gt;where("id&gt;2")-&gt;group("messageId")-&gt;having("messageId &gt; 3")-&gt;order("id desc")-&gt;limit("0,5")-&gt;field("id,username,psssword")-&gt;<span>select();
    </span><span>//</span><span>查询一条记录，返回一维数组</span>
    <span>$result</span> = M("admin")-&gt;<span>find();
    </span><span>$result</span> = M("admin")-&gt;where("id=2")-&gt;<span>find();

    </span><span>//</span><span>要处理的数据放在数组data中</span>
    <span>$data</span>   = <span>array</span><span>(
            </span>"username" =&gt; 'wang',
            "password" =&gt; "123456"<span>
        );
    </span><span>//</span><span>添加记录，返回影响行数</span>
    <span>$updateRowNum</span> = M("admin")-&gt;add(<span>$data</span><span>);
    </span><span>//</span><span>删除记录，返回影响行数</span>
    <span>$updateRowNum</span> = M("admin")-&gt;where("id = 2")-&gt;<span>delete();
    </span><span>//</span><span>修改数据放在新数组new_data中</span>
    <span>$new_data</span>   = <span>array</span><span>(
            </span>"username" =&gt; 'wang_new',
            "password" =&gt; "123456_new"<span>
        );
    </span><span>//</span><span>修改记录，返回影响行数</span>
    <span>$updateRowNum</span> = M("admin")-&gt;where("id = 2")-&gt;save(<span>$new_data</span><span>);
    
    </span><span>//</span><span>执行select语句(不管是多行还是一行，全部返回二维数组)</span>
    <span>$result</span> = M()-&gt;query("select * from admin a,user u where a.id = user.aid"<span>);
    </span><span>//</span><span>执行insert、update、delete语句，返回受影响行数</span>
    <span>$updateRowNum</span> = M()-&gt;execute("insert/update/delete语句"<span>);
    </span><span>//</span><span>计算查询行数(一般用于select语句)</span>
    <span>$row</span>    = M("admin")-&gt;select()-&gt;<span>count</span><span>();
    </span><span>$row</span>    = M("admin")-&gt;where("id &gt; 3")-&gt;select()-&gt;<span>count</span><span>();
</span>?&gt;