In php, how does one use mysqli connection to obtain the mysql process List, which is similar to showprocesslist? Php version: 5.2.17 & nbsp; mysql version: 5.0.14 uses the connection method of mysqli. to obtain the list of current database processes, it is similar to executing & nbsp; in mysql; in PH php, how does one use mysqli connection to obtain the mysql process List, which is similar to show processlist?
Php version: 5.2.17
Mysql version: 5.0.14
The connection method of mysqli is used. to obtain the list of processes in the current database, it is similar to executing
PHP code
Show processlist or mysql function mysql_list_processes
However, I searched the manual and found that the myqli connection does not have this function. I only found sqli ::$ thread_id, which cannot implement what I want.
Execute SQL show processlist in php and only return the ID of the current statement. I want to return the ID of all processes in the current database. what should I do? For more information, see! Thank you!
------ Solution --------------------
Haha. Use "show processlist" as an SQL statement so that php can call the mysql Query method.
