How thinkphp database operations are used with Alias

Source: Internet
Author: User
thinkphp database operation How to use alias?
parameter types supported by coherent operation
Alias is used to define the aliases string for the current data table

Help thinkphp Operation Way alias How to use, not the original ecological SQL notation
Thinkphp in the development of the document is not missing the introduction of alias? Mine is thinkPHP3.1.2 's development document.
------Solution--------------------
Please abide by CSDN user Code of conduct, must not violate national laws and regulations.
------Solution--------------------
Http://www.thinkphp.cn/simple/quickstart_4.html
------Solution--------------------
Alias is used to set the alias of the current data table, making it easy to use other coherent operations such as the Join method.
Example:
$Model = M (' User ');
$Model->alias (' a ')->join (' __dept__ b on b.user_id= a.id ')->select ();
The resulting SQL statement is similar to the following:
SELECT * from Think_user a INNER joins think_dept B on b.user_id= a.id
Http://document.thinkphp.cn/manual_3_2.html#alias
  • Related Article

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.