SNMP

<?PHP
set_time_limit(0);
//include("../connect.php");
$conn=mysqli_connect("localhost", "*", "*", "*");
$query=mysqli_query($conn, "SELECT id, ip, name FROM printers ORDER BY INET_ATON(ip)");
while($list=mysqli_fetch_assoc($query))
{
    if(snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.1.1.0"))
    {
        if(!snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.12.1.1.4.1.2"))
        {
            $color['black']=preg_replace("/[^0-9]/", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.11.1.1.9.1.1")[0]);
            $color['cyan']="NA";
            $color['magenta']="NA";
            $color['yellow']="NA";
        }
        else
        {
            $color1=preg_replace("/[^a-z]/", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.12.1.1.4.1.1")[0]);
            $color2=preg_replace("/[^a-z]/", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.12.1.1.4.1.2")[0]);
            $color3=preg_replace("/[^a-z]/", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.12.1.1.4.1.3")[0]);
            $color4=preg_replace("/[^a-z]/", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.12.1.1.4.1.4")[0]);
            $color[$color1]=preg_replace("/[^0-9]/", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.11.1.1.9.1.1")[0]);
            $color[$color2]=preg_replace("/[^0-9]/", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.11.1.1.9.1.2")[0]);
            $color[$color3]=preg_replace("/[^0-9]/", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.11.1.1.9.1.3")[0]);
            $color[$color4]=preg_replace("/[^0-9]/", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.11.1.1.9.1.4")[0]);
        }
        if(strstr($list['name'], "M300"))
        {
            $color['black']=preg_replace("/[^0-9]/", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.11.1.1.9.1.2")[0]);
        }
        if($color['black']=="")
        {
            $color['black']="NA";
        }

        if(snmpget($list['ip'], "public", "iso.3.6.1.4.1.1347.43.10.1.1.12.1.1")=="")
        {
            $pages=preg_replace("/[^0-9]/", "", str_ireplace("counter32", "", snmpwalk($list['ip'], "public", "iso.3.6.1.2.1.43.10.2.1.4.1.1")[0]));
        }
        else
        {
            $pages=preg_replace("/[^0-9]/", "", snmpget($list['ip'], "public", "iso.3.6.1.4.1.1347.43.10.1.1.12.1.1"));
        }
        $logdate=date("YmdHi");
        $today=date("Ymd");
        $prep=mysqli_stmt_init($conn);
        $finder=mysqli_query($conn, "SELECT id FROM statistics WHERE printerid='".$list['id']."' AND logdate LIKE '".$today."%'");
        if(mysqli_num_rows($finder)==1)
        {
            $element=mysqli_fetch_assoc($finder);
            mysqli_stmt_prepare($prep, "UPDATE statistics SET printerid=?, cyan=?, magenta=?, yellow=?, black=?, pages=?, logdate=? WHERE id=?");
            mysqli_stmt_bind_param($prep, "issssiii", $list['id'], $color['cyan'], $color['magenta'], $color['yellow'], $color['black'], $pages, $logdate, $element['id']);
        }
        else
        {
            mysqli_stmt_prepare($prep, "INSERT INTO statistics (printerid, cyan, magenta, yellow, black, pages, logdate) VALUES (?, ?, ?, ?, ?, ?, ?)");
            mysqli_stmt_bind_param($prep, "issssis", $list['id'], $color['cyan'], $color['magenta'], $color['yellow'], $color['black'], $pages, $logdate);
        }
        mysqli_stmt_execute($prep);
        mysqli_stmt_close($prep);
    }
}