query question

Can the query use static methods, such as User::select()?

局外人 2019-06-28 15:34:58 0  0  1039

Looking for a way to use models to perform multi-table related queries under TP5?

Dear masters, when I use tp5 to query multiple tables, I use the view query method, similar to Db::view('table_a')->view('table_b')->view('table_c') ->view('table_d')->view('table_e')->select(), please

阳光 2018-10-10 08:44:29 0  4  1888

How to optimize tp6 query

When the tp6 model is associated with multiple data tables for query, the query will be very slow. How can I optimize it? Is there any optimization method? Help! ! ! ! !

以后会怎样 2023-11-17 08:50:36 0  0  700

Convert a mysql query to its equivalent Knex query

I'm trying to convert my mysql query to its equivalent Knex query This is the query create table test(idINTUNSIGNEDNOTNULLAUTO_INCRMENT,nameVARCHAR(100),unique(id))AUTO_INCRMENT=1001; So basically I want to create a table that contains A column called "id" whose type is autoincrement and w...

P粉412533525 2024-02-26 19:06:08 0  1  316

Query paging

Please tell me why when I click the next page for my paginated query, there are query results that appear? Pagination after query cannot be implemented

思睿 2018-10-18 10:49:05 0  0  1295

Crosstab query in PHP and MYSQL

I was looking for a way to implement a crosstab query in MySQL and found the answer from this post: Display dates in rows as dynamic columns in MySQL. I tried the query and got it to work, but how do I write the query in PHP using MySQL procedural style. Here is the query: SELECTGROUP_CONCAT(DISTINC...

P粉714890053 2024-04-02 22:34:20 0  1  650

Unbuffered queries in MySQLi?

Are MySQLi queries unbuffered? If not, is there a way to perform unbuffered queries, just like non-MySQLimsql_unbuffered_query()?

P粉769413355 2023-10-24 14:58:46 0  2  608

Medoo linked list query questions

Query all the fields of the slide_item table. The specified fields of the slide table are written with * in all fields of the slide_item. How to write it differently? If you write this way, you will not get any results.

红色熊猫 2019-07-30 15:00:12 0  0  1077

Mongodb limited query return field query is slower?

When I directly use find to return all fields, the results are as follows. The query time is 155. If I limit the returned fields, the query time is longer, and the query time is 251. Why? If I limit the fields returned, the query character bytes will be smaller, shouldn't the transmission be faster?

大家讲道理 2017-05-17 10:04:05 0  1  864

Query Chinese garbled characters?

After php queries the database, the Chinese displayed becomes '? ? 'what to do? There is no way to check it online.

Labmem No.000 2017-10-18 19:36:40 0  4  1339

search query

Teacher Zhu, I have read all your 2020 PHP tutorials. Are there any courses on search queries and conditional queries?

无所谓 2023-02-02 20:50:39 0  2  701

A MySql query problem

The data is as follows: id col 1 a,b,d 2 a,b,c My query conditions: col=(a,b) requires to find two rows with id 1,2 col=(a,d) finds id The row with id 1, col=(a,c). Find the row with id 2, col=(a). Find the two rows with id 1,2. Is there any method?

为情所困 2017-05-18 10:46:37 0  2  666

About database queries

Regarding data query, how to query in order

驱魔鮔 2019-02-20 21:21:47 0  3  1398

tp5 closure query

I don’t understand the advantages of tp5’s closure query. Is there any situation where it can’t be queried without closure? Is there anyone who knows better who can give me some guidance?

凌晨¤ 2019-09-23 09:33:31 0  0  1188

How to calculate the difference between two SQL queries

I want to do subtraction between entotalitem and exotalitem, the query I am using is to retrieve data from the same table tbl_orders_data. I tried creating 2 queries, the first query is to retrieve entotalitem and the second query is to retrieve exotalitem$encheck=DB::table('tbl_orders_data')->se...

P粉036800074 2023-09-07 20:06:33 0  1  645

How to remove query string parameters in JavaScript?

Is there a better way to remove parameters from a URL string's query string than standard JavaScript using regular expressions? This is what I've come up with so far, and it seems to work in my tests, but I don't like reinventing query string parsing! functionRemoveParameterFromUrl(url,parameter){if...

P粉239164234 2023-08-20 18:46:10 0  2  519

Mysql query returns too slowly

I have written a query. It works better. But currently, all tables have 100K rows, and one of my queries is returning too slowly. Can you suggest me how to optimize my query? select*fromtbl_xray_informationXWHERElocationCode=(SELECTt.idfromtbl_locationtwhereCODE='202')AND(communicate_with_ptisNULL||...

P粉727531237 2024-03-30 18:25:44 0  1  494

Why can't I find the book search?

The book query in the administrator's background cannot be searched.

敏鼠 2018-04-16 21:18:12 0  0  1148

rtk query without useEffect

Using RTK queries, do we have to use effects to run the query on the mount? ReactQuery has no effect running queries while mounted, so wondering if there is similar behavior? constComponent=({id})=>{const[postCheckApplication,{data}]=usePostCheckApplicationMutation();useEffect(()=>{postCheckAp...

P粉799885311 2023-09-01 12:49:13 0  1  529

java - mysql query, how to query this

I saw an interview question posted by someone else in the group, =. =, how to query?

世界只因有你 2017-06-22 11:54:36 0  4  764