{"id":214,"date":"2021-08-03T10:13:37","date_gmt":"2021-08-03T02:13:37","guid":{"rendered":"http:\/\/blog.nonot.cn\/?p=214"},"modified":"2024-07-08T13:09:19","modified_gmt":"2024-07-08T05:09:19","slug":"tp3-%e5%a4%9a%e8%a1%a8join-%e6%9f%a5%e8%af%a2","status":"publish","type":"post","link":"https:\/\/blog.nonot.cn\/index.php\/2021\/08\/03\/tp3-%e5%a4%9a%e8%a1%a8join-%e6%9f%a5%e8%af%a2\/","title":{"rendered":"TP3 \u591a\u8868Join \u67e5\u8be2"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>$db=M('firstTable'); \/\/\u4e3b\u8868\n$rs=$db ->join(\"tp_user u on tp_order.uid=u.uid\") \/\/\u9644\u8868\u8fde\u4e3b\u8868\n    ->join(\"tp_area a on tp_order.aid=a.aid\")\n    ->join(\"tp_disease d on tp_order.did=d.did\")\n    ->join(\"tp_source s on tp_order.sid=s.sid\")\n    ->join(\"tp_town f on tp_order.fid=f.sid\")\n    ->order(\"addtime desc\")\/\/\u4e3b\u8868\u5b57\u6bb5\n    ->limit($page->firstRow.','.$page->listRows)\n    ->field(\"tp_order.*,u.uname,a.aname,d.dname,s.sname sname,f.sname fname\")\/\/\u9700\u8981\u663e\u793a\u7684\u5b57\u6bb5\n    ->select();<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-214","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/blog.nonot.cn\/index.php\/wp-json\/wp\/v2\/posts\/214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nonot.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nonot.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nonot.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nonot.cn\/index.php\/wp-json\/wp\/v2\/comments?post=214"}],"version-history":[{"count":1,"href":"https:\/\/blog.nonot.cn\/index.php\/wp-json\/wp\/v2\/posts\/214\/revisions"}],"predecessor-version":[{"id":1263,"href":"https:\/\/blog.nonot.cn\/index.php\/wp-json\/wp\/v2\/posts\/214\/revisions\/1263"}],"wp:attachment":[{"href":"https:\/\/blog.nonot.cn\/index.php\/wp-json\/wp\/v2\/media?parent=214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nonot.cn\/index.php\/wp-json\/wp\/v2\/categories?post=214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nonot.cn\/index.php\/wp-json\/wp\/v2\/tags?post=214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}