{"id":22910,"date":"2024-11-21T11:48:33","date_gmt":"2024-11-21T03:48:33","guid":{"rendered":"https:\/\/fwq.ai\/blog\/22910\/"},"modified":"2024-11-21T11:48:33","modified_gmt":"2024-11-21T03:48:33","slug":"thinkphp%e5%a6%82%e4%bd%95%e4%bf%ae%e6%94%b9%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/22910\/","title":{"rendered":"thinkphp\u5982\u4f55\u4fee\u6539\u6570\u636e\u5e93"},"content":{"rendered":"<\/p>\n

\u4e00\u3001ThinkPHP\u6570\u636e\u5e93\u64cd\u4f5c<\/strong><\/p>\n

\u5728ThinkPHP\u4e2d\uff0c\u6211\u4eec\u53ef\u4ee5\u901a\u8fc7\u5b83\u63d0\u4f9b\u7684\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b\u6765\u8fdb\u884c\u5bf9\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u3002\u5e38\u7528\u7684\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b\u6709\uff1a<\/p>\n

    \n
  1. \n

    Db\u7c7b<\/p>\n<\/li>\n<\/ol>\n

    \u5728ThinkPHP\u4e2d\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528Db\u7c7b\u6765\u8fdb\u884c\u5bf9\u6570\u636e\u5e93\u7684\u589e\u3001\u5220\u3001\u6539\u3001\u67e5\u7b49\u64cd\u4f5c\u3002\u5176\u4f7f\u7528\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n

    \u7acb\u5373\u5b66\u4e60<\/span>\u201c\u201d\uff1b<\/p>\n

    <?php use thinkDb;\n\n\/\/ \u67e5\u8be2\u6570\u636e\n$list = Db::table('user')->where('id', 1)-&gt;find();\n\n\/\/ \u65b0\u589e\u6570\u636e\n$data['name'] = 'test';\n$data['age'] = 20;\nDb::table('user')-&gt;insert($data);\n\n\/\/ \u66f4\u65b0\u6570\u636e\n$where['id'] = 1;\n$data['name'] = 'test';\n$data['age'] = 30;\nDb::table('user')-&gt;where($where)-&gt;update($data);\n\n\/\/ \u5220\u9664\u6570\u636e\n$where['id'] = 1;\nDb::table('user')-&gt;where($where)-&gt;delete();<\/pre>\n
     \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
      \n
    1. \n
      Model\u7c7b<\/p>\n<\/li>\n<\/ol>\n
      \u5728ThinkPHP\u4e2d\uff0cModel\u7c7b\u7ee7\u627f\u81eaDb\u7c7b\uff0c\u56e0\u6b64Model\u7c7b\u53ef\u4ee5\u4f7f\u7528Db\u7c7b\u7684\u6240\u6709\u65b9\u6cd5\uff0c\u540c\u65f6\u8fd8\u63d0\u4f9b\u4e86\u4e00\u4e9b\u66f4\u52a0\u65b9\u4fbf\u7684\u65b9\u6cd5\u3002\u5176\u4f7f\u7528\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n
      <?php namespace appindexmodel;\n\nuse thinkModel;\n\nclass User extends Model\n{\n    \/\/ \u67e5\u8be2\u6570\u636e\n    public function getUserById($id)\n    {\n        return $this->where('id', $id)-&gt;find();\n    }\n\n    \/\/ \u66f4\u65b0\u6570\u636e\n    public function updateUser($id, $name)\n    {\n        return $this-&gt;save(['name' =&gt; $name], ['id' =&gt; $id]);\n    }\n}<\/pre>\n
       \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
      \u4e8c\u3001ThinkPHP\u5982\u4f55\u4fee\u6539\u6570\u636e\u5e93<\/strong><\/p>\n
      \u5728\u4f7f\u7528ThinkPHP\u4fee\u6539\u6570\u636e\u5e93\u65f6\uff0c\u901a\u5e38\u4f1a\u7ecf\u8fc7\u4ee5\u4e0b\u51e0\u4e2a\u6b65\u9aa4\uff1a<\/p>\n
        \n
      1. \n
        \u521b\u5efa\u6a21\u578b<\/p>\n<\/li>\n<\/ol>\n
        \u6211\u4eec\u9700\u8981\u521b\u5efa\u4e00\u4e2a\u6a21\u578b\uff0c\u8be5\u6a21\u578b\u5bf9\u5e94\u7740\u6211\u4eec\u9700\u8981\u8bbf\u95ee\u7684\u6570\u636e\u5e93\u8868\u3002\u7531\u4e8eThinkPHP\u91c7\u7528\u4e86MVC\u8bbe\u8ba1\u6a21\u5f0f\uff0c\u56e0\u6b64\u6211\u4eec\u5728\u521b\u5efa\u6a21\u578b\u65f6\u9700\u8981\u7ee7\u627f\u81eaThinkPHP\u7684Model\u7c7b\u3002\u4e0b\u9762\u662f\u4e00\u4e2a\u521b\u5efaUser\u6a21\u578b\u7684\u793a\u4f8b\uff1a<\/p>\n
        <?php namespace appindexmodel;\n\nuse thinkModel;\n\nclass User extends Model\n{\n    protected $table = 'user';\n    protected $pk = 'id';\n}<\/pre>\n
         \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
        \u5728\u521b\u5efaUser\u6a21\u578b\u65f6\uff0c\u6211\u4eec\u6307\u5b9a\u4e86\u8be5\u6a21\u578b\u5bf9\u5e94\u7684\u6570\u636e\u5e93\u8868\u662fuser\u8868\uff0c\u5e76\u4e14\u8be5\u8868\u7684\u4e3b\u952e\u662fid\u3002<\/p>\n
          \n
        1. \n
          \u5b9e\u4f8b\u5316\u6a21\u578b<\/p>\n<\/li>\n<\/ol>\n
          \u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u9700\u8981\u4f7f\u7528\u5148\u524d\u521b\u5efa\u7684User\u6a21\u578b\u8fdb\u884c\u5b9e\u4f8b\u5316\uff0c\u5e76\u5229\u7528\u8be5\u6a21\u578b\u64cd\u4f5c\u6570\u636e\u5e93\u3002\u4e0b\u9762\u662f\u5b9e\u4f8b\u5316User\u6a21\u578b\u7684\u793a\u4f8b\uff1a<\/p>\n
          <?php $userModel = new ppindexmodelUser();<\/pre>\n
           \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
            \n
          1. \n
            \u4fee\u6539\u6570\u636e<\/p>\n<\/li>\n<\/ol>\n
            \u4e00\u65e6\u521b\u5efa\u4e86User\u6a21\u578b\u7684\u5b9e\u4f8b\uff0c\u5c31\u53ef\u4ee5\u5229\u7528\u8be5\u6a21\u578b\u6240\u63d0\u4f9b\u7684\u51fd\u6570\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u4fee\u6539\u3002\u4e0b\u9762\u662f\u4e00\u4e2a\u4f7f\u7528User\u6a21\u578b\u4fee\u6539\u6570\u636e\u7684\u793a\u4f8b\uff1a<\/p>\n
            <?php $userModel = new ppindexmodelUser();\n\n\/\/ \u66f4\u65b0\u6570\u636e\n$where['id'] = 1;\n$data['name'] = 'test';\n$data['age'] = 30;\n$userModel->where($where)->update($data);<\/pre>\n
             \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
            \u5728\u4ee5\u4e0a\u793a\u4f8b\u4e2d\uff0c\u6211\u4eec\u4f7f\u7528$UserModel\u7684update()\u65b9\u6cd5\u5bf9User\u8868\u4e2did\u4e3a1\u7684\u6570\u636e\u8fdb\u884c\u4e86\u4fee\u6539\uff0c\u5c06\u8be5\u884c\u6570\u636e\u7684name\u5b57\u6bb5\u4fee\u6539\u4e3atest\uff0cage\u5b57\u6bb5\u4fee\u6539\u4e3a30\u3002<\/p>\n
            \u4ee5\u4e0a\u5c31\u662f\u5982\u4f55\u4fee\u6539\u6570\u636e\u5e93\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
            \u4e00\u3001ThinkPHP\u6570\u636e\u5e93\u64cd\u4f5c \u5728ThinkPHP\u4e2d\uff0c\u6211\u4eec\u53ef\u4ee5\u901a\u8fc7\u5b83\u63d0\u4f9b\u7684\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b\u6765\u8fdb\u884c\u5bf9\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u3002\u5e38\u7528\u7684\u6570\u636e\u5e93\u64cd\u4f5c\u7c7b\u6709\uff1a Db\u7c7b \u5728ThinkPHP\u4e2d\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528Db\u7c7b\u6765\u8fdb\u884c\u5bf9\u6570\u636e\u5e93\u7684\u589e\u3001\u5220\u3001\u6539\u3001\u67e5\u7b49\u64cd\u4f5c\u3002\u5176\u4f7f\u7528\u793a\u4f8b\u5982\u4e0b\uff1a \u7acb\u5373\u5b66\u4e60\u201c\u201d\uff1b <?php use thinkDb; \/\/ \u67e5\u8be2\u6570\u636e $list = Db::table('user')->where(‘id’, 1)-&gt;find(); \/\/ \u65b0\u589e\u6570\u636e $data[‘name’] = ‘test’; $data[‘age’] = 20; Db::table(‘user’)-&gt;insert($data); \/\/ \u66f4\u65b0\u6570\u636e $where[‘id’] = 1; $data[‘name’] = ‘test’; $data[‘age’] = 30; Db::table(‘user’)-&gt;where($where)-&gt;update($data); \/\/ \u5220\u9664\u6570\u636e $where[‘id’] = 1; Db::table(‘user’)-&gt;where($where)-&gt;delete(); \u767b\u5f55\u540e\u590d\u5236 Model\u7c7b \u5728ThinkPHP\u4e2d\uff0cModel\u7c7b\u7ee7\u627f\u81eaDb\u7c7b\uff0c\u56e0\u6b64Model\u7c7b\u53ef\u4ee5\u4f7f\u7528Db\u7c7b\u7684\u6240\u6709\u65b9\u6cd5\uff0c\u540c\u65f6\u8fd8\u63d0\u4f9b\u4e86\u4e00\u4e9b\u66f4\u52a0\u65b9\u4fbf\u7684\u65b9\u6cd5\u3002\u5176\u4f7f\u7528\u793a\u4f8b\u5982\u4e0b\uff1a <?php namespace appindexmodel; use thinkModel; class User extends Model { \/\/ \u67e5\u8be2\u6570\u636e public function getUserById($id) { return $this->where(‘id’, $id)-&gt;find();     }     \/\/ \u66f4\u65b0\u6570\u636e     public function updateUser($id, $name)     {         return $this-&gt;save([‘name’ =&gt; $name], [‘id’ =&gt; $id]);     } } \u767b\u5f55\u540e\u590d\u5236 \u4e8c\u3001ThinkPHP\u5982\u4f55\u4fee\u6539\u6570\u636e\u5e93 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-22910","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/22910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=22910"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/22910\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=22910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=22910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=22910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}