Home >Backend Development >PHP Tutorial >CURD operation in ThinkPHP, ThinkPHPCURD operation_PHP tutorial

CURD operation in ThinkPHP, ThinkPHPCURD operation_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 09:54:20993browse

CURD operation in ThinkPHP, ThinkPHPCURD operation

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

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

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/998220.htmlTechArticleCURD operation in ThinkPHP, ThinkPHPCURD operation? php // Query multiple records and return a two-dimensional array $result = M("admin")- select(); $result = M("admin")-where("id2")- select(); $result =...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn