The problem of making api list Interface by thinkphp

use thinkphp5.1x for api interface development

when doing the list query interface:
you want to use parameters to control the returned data of the query, roughly as follows

null


what exactly is my problem
and is there a security risk in my way of writing? what do people do when they do complex query interfaces?-sharp-sharp-sharp problem description

the environmental background of the problems and what methods you have tried

related codes

/ / Please paste the code text below (do not replace the code with pictures)

what result do you expect? What is the error message actually seen?

Jun.26,2021

list?filter= "{'fields': [],' where': [], 'page':2}"

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-1b34912-2bf2f.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-1b34912-2bf2f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?