Command < / font> td> tr>
$ mysql_host = "localhost";
$ mysql_user = "gestation";
$ mysql_password = "9cyunyuxitong";
$ mysql_database = "system";
$ mysql_table = "membcpu";
$ link = mysql_pconnect ($ mysql_host, $ mysql_user, $ mysql_password) or Die ("Could Not Connect");
MySQL_SELECT_DB ($ mysql_database) or Die ("Could Not Select Database");
$ query_flush = "delete from". $ mysql_table;
Mysql_Query ($ Query_Flush, $ Link) OR Die ("Flush Failed");
$ list = `/ bin / ps --auxc`;
$ LINES = EXPLODE ("/ N", $ list);
$ linenu = count ($ LINES);
For ($ I = 1; $ i <$ linenu; $ i ) {
$ FIELDS = EXPLODE ("", $ LINES [$ I]);
$ K = 0;
For ($ j = 0; $ j
IF (Strlen ($ FIELDS [$ J])> 0) {
IF ($ k <11) {
$ FIELD [$ I] [$ K] = $ FIELDS [$ J];
}
$ K ;
}
}
}
For ($ I = 1; $ i <$ linenu-1; $ i ) {
#echo "
";
$ query_insert = "INSERT INTO". $ mysql_table. "VALUES (";
For ($ jj = 0; $ jj <11; $ jj ) {
#echo "
". $ field [$ i] [$ j]. " td>";
IF ($ jj <10) {$ query_insert = $ query_insert. "/" ". $ field [$ I] [$ jj]." / ",";
IF ($ jj == 10) {$ query_insert = $ query_insert. "/" ". $ field [$ i] [$ jj]." / ")"
}
Mysql_Query ($ Query_Insert, $ LINK) OR DIE ("INSERT DATA FAILD !!");
}
$ query_select = "SELECT USER, PID, CPU, MEM, VSZ, RSS, TTY, STAT, START, TIME, Command from Memcpu Order By CPU DESC, Command";
$ Result = mysql_query ($ query_select, $ link) or Die ("SELECT FAILED !!");
$ Num_Rows = mysql_num_rows ($ result);
While ($ row = mysql_fetch_Array ($ Result, $ LINK) {
Echo " |
";
For ($ I = 0; $ I <11; $ i ) {
Echo "
". $ ROW [$ I]. " td>";
}
Echo " TR>";
}
?>
table>
body>
html>
转载请注明原文地址:https://www.9cbs.com/read-57945.html
|