 |
|
โค้ดเป้นแบบนี้นะครับ
หน้าแรก ip.php
Code (PHP)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<center>
<table width ="300" border ="1">
<TR>
<!-- Row 1 -->
<TD align=center colspan=2> เลือกหมายเลข ip ที่ต้องการ </TD>
</TR>
<TR>
<!-- Row 2 -->
<TD align=center> เลือก </TD>
<TD align=center> หมายเลข ip </TD>
</TR>
<form method="post" action="command.php" name="frmContact">
<?
$host = "localhost";
$username="root";
$password = "1234";
$dbname = "ap_via_gm";
mysql_connect($host,$username,$password) or die("ไม่สามารถติดต่อเซิร์ฟเวอร์ฐานข้อมูลได้");
//select database เลือกฐานข้อมูล
mysql_select_db($dbname) or die("ไม่สามารถเลือกฐานข้อมูลได้");
//$loop = 0;
$sql = "SELECT ap_serial, ap_ip, numport FROM access_point WHERE ap_use = 'use'";
$dbQuery = mysql_query($sql);
while($result = mysql_fetch_array($dbQuery)){
$ap_ip = $result["ap_ip"];
$port = $result["numport"];
echo "<tr>";
echo "<td align =center><input type=checkbox name= ap_ip[] value=$ap_ip></td>";
echo "<td align =center>$ap_ip</td>";
echo "</tr>";
//$loop++;
}
?>
<input type="submit" name="button" value="OK" onclick = ""/>
</table>
</center>
</form>
</body>
</html>
หน้าที่ 2 command.php
Code (PHP)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<center>
<table width ="500" border ="1">
<TR>
<!-- Row 1 -->
<TD align=center colspan=1> รายละเอียด </TD>
<TD align=center colspan=2> สถานะอุปกรณ์ </TD>
<TD align=center colspan=2> สถานะเครือข่าย </TD>
</TR>
<TR>
<!-- Row 2 -->
<TD align=center> หมายเลข ip </TD>
<TD align=center> รุ่น </TD>
<TD align=center> เวลาที่ใช้</TD>
<TD align=center> อุปกรณ์ </TD>
<TD align=center> ผู้ใช้ </TD>
</TR>
<form method="post" action="process.php" name="frmContact">
<?
$host = "localhost";
$username="root";
$password = "1234";
$dbname = "ap_via_gm";
mysql_connect($host,$username,$password) or die("ไม่สามารถติดต่อเซิร์ฟเวอร์ฐานข้อมูลได้");
mysql_select_db($dbname) or die("ไม่สามารถเลือกฐานข้อมูลได้");
$ap_ip = $_POST["ap_ip"];
foreach ($ap_ip as $ip){
$ips = $ip;
//select database เลือกฐานข้อมูล
$sql = "SELECT ap_serial, ap_ip, numport FROM access_point WHERE ap_ip = '$ips' AND ap_use = 'use'";
$dbQuery = mysql_query($sql);
while($result = mysql_fetch_array($dbQuery)){
//$port = $result['numport']
echo "<tr>";
echo "<td align =center>".$result['ap_ip']."</td>";
echo "<td align =center><input type=checkbox name= select[] value=sysDescr.0 /></td>";
echo "<td align =center><input type=checkbox name= select[] value=ifLastChange.10".$result['numport']."></td>";
echo "<td align =center><input type=checkbox name= select[] value=ifAdminStatus.10".$result['numport']."></td>";
echo "<td align =center><input type=checkbox name= select[] value=ifOperStatus.10".$result['numport']."></td>";
echo "</tr>";
echo "<input name='ip[]' type='hidden' value='$ips' />";
echo "<input name='port' type='hidden' value='".$result['numport']."' />";
}
}
?>
<input type="submit" name="button" id="button" value="Submit" />
</form>
</table>
</center>
</body>
</html>
หน้าที่ 3 process.php
Code (PHP)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?
/*$ap_ip = $_POST['ip'];
foreach ($ap_ip as $ip){
$ips = $ip;
//$port = $_POST['port'];
foreach ($_POST['port'] as $pt){
$ptt = $pt;
echo $ips."<br>";
echo $ptt."<br>";
}
//$logData[3];
//for($i=0;$i< $ptt;$i++){
function item($ips,$ptt){
$selectItem = Sprintf("c:\usr\bin\snmpget -v 2c -c public %s ifLastChange.10%d",$ips,$i);
return $selectItem;
/* $logData[0] = $selectItem;
$selectItem = Sprintf("c:\usr\bin\snmpget -v 2c -c public %s ifLastChange.10%d",$ips,$i);
$logData[1] = $selectItem;
$selectItem = Sprintf("c:\usr\bin\snmpget -v 2c -c public %s ifAdminStatus.10%d",$ips,$i);
$logData[2] = $selectItem;
$selectItem = Sprintf("c:\usr\bin\snmpget -v 2c -c public %s ifOperStatus.10%d",$ips,$i);
$logData[3] = $selectItem;
echo $i." ";
echo $_POST['port'];
for($j=0;$j<3;$j++)
{
echo $logData[$j]."<br>";
}
}
}
/* include ("mibtest.php");
$end = $_POST["select"];
echo $end; */
//echo $item = item($ips,$ptt);
//}
//} */
function chkModel($ip){
$selectItem = Sprintf("c:\usr\bin\snmpget -v 2c -c public %s sysDscr.0",$ip);
return $selectItem;
}
$ap_ip = $_POST["ip"];
foreach ($ap_ip as $ip){
$cmd = chkModel($ip);
echo $cmd."<br>";
}
function chkTime($ip){
$selectItem = Sprintf("c:\usr\bin\snmpget -v 2c -c public %s ifLastChange",$ip);
return $selectItem;
}
$ap_ip = $_POST["ip"];
foreach ($ap_ip as $ip){
$cmd1 = chkTime($ip);
echo $cmd1."<br>";
}
function chkAdmin($ip,$i){
$selectItem = Sprintf("c:\usr\bin\snmpget -v 2c -c public %s ifAdminStatus.10%d",$ip,$i);
return $selectItem;
}
$ap_ip = $_POST["ip"];
$j=$_POST['port'];
foreach ($ap_ip as $ip){
for ($i=0;$i<$j;$i++){
$cmd2 = chkAdmin($ip,$i);
echo $cmd2."<br>";
}
}
function chkUser($ip,$i){
$selectItem = Sprintf("c:\usr\bin\snmpget -v 2c -c public %s ifOperStatus.10%d",$ip,$i);
return $selectItem;
}
$ap_ip = $_POST["ip"];
$j=$_POST['port'];
foreach ($ap_ip as $ip){
for ($i=0;$i<$j;$i++){
$cmd2 = chkUser($ip,$i);
echo $cmd2."<br>";
}
}
?>
</body>
</html>
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2012-06-15 17:49:50 |
By :
oletheory |
View :
1166 |
Reply :
11 |
|
 |
 |
 |
 |
|
|
|
|
 |
Quote:
