How to write query statements in ThinkPHP? Similar to QQ, a user information table allows users to have friends. how can I query User friend information and display it on the page? Thank you, GGMM! ------ Solution -------------------------- solution -------------------- at least you should give the relevant table structure ------ solution -------------------- how to write the query statement in the ThinkPHP box?
Similar to QQ, a user information table allows users to have friends. how can I query User friend information and display it on the page? Thank you, GGMM!
------ Solution --------------------
------ Solution --------------------
At least you should give the relevant table structure
------ Solution --------------------
What is the relationship with the framework?
You can design related databases and search data accordingly.
You can paste the structure of the user table and friend table
------ Solution --------------------
Approximate statement, suppose useraccount is required ,,
SQL code
SELECT f. *, u. useraccount FROM usersfriend AS f left join [user table name] AS u ON f. frienduserid = u. useridWHERE f. userid = [ID to be found]
------ Solution --------------------
No for tp joint queries. I use tp as a direct query (SQL statement)
------ Solution --------------------
Basic SQL:
Select usersfriend .*
From usersfriend, userinformation
Where usersfriend. frienduserid = userinformation. userid
------ Solution --------------------
Pass by, points