Tp5 syntax group by is used with count (*)

like Table
Fields
id
typeid article id
userid user id
status like status 1: liked 0: not liked

I want to know that the id of an article is the total number of likes of 1br 2 code 3 group by typeid 4. I don"t know how to use tp5 to write
Native sql= "select typeid,count (*) from like where typeid in (1 Magazine 3 Magazine 4) and user_id = 14 and status = 1 group by typeid";

tp5 only knows how to write
$ids="1
LikeModel::where ("typeid","in",$ids)-> where ([" user_id"= > 14 minute statuses = > 1)-> group ("typeid")-> select ();

count (*) is not used

I want to implement
typeid count (*)
1
22
3 2
4 1

Sql php thinkphp

Mar.03,2021

in fact, the filed method is used in this one. For example,

LikeModel::where('typedid','in',$ids)
    ->where(['user_id'=>14,'status'=>1])
    ->filed('typeid,COUNT(*) as total')
    ->group('typeid')
    ->select();

not too much to check, that's about what it means

Previous: How to blur the div area? Css filter

Next: Element table data replacement

Realize the if judgment of where of mysql
how to realize the if judgment of mysql. There is now a table with two key fields SELECT * FROM house WHERE price= 8500 OR shoufu= 30 I think, when the $price passed in by php is empty, the sql search statement is SELECT * FROM house WHERE s...

Sql mysql php thinkphp5

Mar.07,2021
The problem of obtaining values from multiple tables with SQL statements in thinkphp
Table 1 fields are as follows 2 3 1event_description_description_id2id1cel_order_item_order_item_id3id 123idnull id ask the boss for advice ...

Sql mysql php thinkphp

Mar.09,2021
What if you use thinkphp to query the database to ignore query conditions that do not exist?
$condition there will be a time condition, this time condition is optional, now think if the time condition does not exist, how to remove the time condition? When the time condition exists, then add the query result of the time condition? method 1: an...

Mysql php thinkphp orm

Jun.10,2021
The efficiency of php connecting to remote server mysql is too slow, how to solve it?
linux server, a master server, the speed of using tp5 to connect to the website opened by mysql, is too slow, how to solve it? skip_name_resolve this part of the code has been added ...

Linux mysql php thinkphp5

Sep.01,2021
A little question about the design of data table
recently, I have been looking at other people s projects and found that some projects separate the user table from the user balance table to create . user-> user Table user balance-> user_balance Table (which contains the user id and the number of us...

Mysql php thinkphp5

Oct.06,2021
How thinkphp5 chained operations sql returns data of type float
how to concatenate SQL statements to return data of type float when querying? ...

Sql php thinkphp5

Mar.29,2022
If I need to query more than 10,000 records and associate the fields of other tables, how can I be efficient?
$cardNoBegin = 1; $cardNoEnd = 10000; $where[ number ] = array( between , [$cardNoBegin , $cardNoEnd]); $list = VipCardModel::where($where)->field( id,number,issue_uid,rank )->select(); foreach($list as &$value){ foreach $value...

Mysql php thinkphp5 thinkphp

May.14,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1beae08-31a27.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1beae08-31a27.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?