[root@9c9c cpu]# cat cpu.php
<html>
<title>进程CPU占用比率分布</title>
<body>
<table align=center>
<tr bgcolor=#0000ff><td><font color=white>USER</font></td><td><font color=white>PID</font></td><td><font color=white>%CPU</font></td><td><font color=white>%MEM</font></td><td><font color=white>VSZ</font></td><td><font color=white>RSS</font></td><td><font color=white>TTY</font></td><td><font color=white>STAT</font></td><td><font color=white>START</font></td><td><font color=white>TIME</font></td><td><font color=white>COMMAND</font></td></tr>
<?
$mysql_host="localhost";
$mysql_user="gestation";
$mysql_password="9cyunyuxitong";
$mysql_database="system";
$mysql_table="memcpu";
$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<count($fields);$j++){
if(strlen($fields[$j])>0){
if($k<11){
$field[$i][$k]=$fields[$j];
}
$k++;
}
}
}
for($i=1;$i<$linenu-1;$i++){
#echo "<tr>";
$query_insert="INSERT INTO ".$mysql_table." VALUES(";
for($jj=0;$jj<11;$jj++){
#echo "<td bgcolor=#00cc00>".$field[$i][$jj]."</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 "<tr bgcolor=#00cc00>";
for($i=0;$i<11;$i++){
echo "<td>".$row[$i]."</td>";
}
echo "</tr>";
}
?>
</table>
</body>
</html>