<?php
//date  4/14/2016
//Smupper v3
//author: Jeff Swenson js@mt.net j.swenson@simplixity.net
///user snmpget to retrieve ap information.

//set date variable
$date = date("Y/m/d");

//connect to database via pdo
$host = '127.0.0.1'; //host variable
$db   = 'adatabase';//database name variable
$user = 'root';//database user variable
$pass = "MontanaNet4**";//database user password variable
$charset = 'utf8';//database charset type variable

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";

$opt = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];

$pdo = new PDO($dsn, $user, $pass, $opt);

//this is a counter
$acount = '0';

//load sm list file: this is a list of IPS
$array = array(); // this is the  array for the data from  siteList.txt will be stored.
$handle = fopen("alist.txt", "r") or die("epic fail");

//read through the list and put the IPS into an array
while(($row = fgetcsv($handle, 1000, ",")) !== FALSE) {
	$array[$row[0]] = $row[0];
	}
fclose($handle);

//display ammount of sites loaded in the array
echo "there is ".  count($array) . " sites loaded into the application" . "<br>";

sort($array);
//loop through each item in the array
foreach($array as $key => $ip){
		$community = "micadmpasscomm";
		//set the object ids
		$oid = ".1.3.6.1.2.1.1.5.0";
		$oid2 = ".1.3.6.1.4.1.161.19.3.1.7.1.0";
		$oidCC = ".1.3.6.1.4.1.161.19.3.1.10.1.1.6.1";

		//build the snmp2 get strings for each object id
		$test = snmp2_get($ip, $community, $oid);//ap name
		$test2 = snmp2_get($ip, $community, $oid2); //sm count
		$test3 = snmp2_get($ip, $community, $oidCC); //color code

		$acount++;//add one to count
		try{
				//echo $acount;

				//this is the variable for the ap name raw input
				$testa = substr($test, 5);
				//this is the variable for the sm count raw input
				$test2a = substr($test2, 5);
				//this is the variable for the color code raw input
				$test3a = substr($test3, 3);

				//this is for showing the raw output before anyhting is trimmed
				//print "ap name :" . $test . "sm count :" . $test2 . "<br>";
				//ap name :STRING: "HOGBK-SW-2.4-FSK-2 {A13098};VS 180deg"sm count :Gauge32: 23


				//trim the values in the array so they are human readable
				//ap trims as expected "HOGBK-SW-2.4-FSK-2
				$ap = explode(' {',substr($test,strpos($test,': ') + 2))[0];

				//count does not trim as expected Gauge32: 23
				//this does not work *****************
				$count = explode(' {',substr($test2,strpos($test2,':') - 7));
				//this does not work *****************

				//this is not needed at this time | to display color code of said ap
				//. " color code: " . substr($test3,strpos($test3,': ') + 2);

						//insert into the database with pdo
						//this does not seem to work either
						   $stmt = $pdo->prepare("INSERT INTO nodeCounts(NodeID, Count, DateLogged) VALUES (:NodeID, :Count, :DateLogged)");

						   $stmt->bindParam(':NodeID', $ap);
						   $stmt->bindParam(':Count', $count);
						   $stmt->bindParam(':DateLogged', $date);
						   //echo the date
						   echo  $date ."<br>";

						   //echo the snmp  ap name
						   echo $ap ."<br>";//this echos "acceptable" but still has issues because of needing a different needle for the haystack

						   //echo the amount of registered sm to ap

						 //this does not work *****************
							 echo $count ."<br>";//this just echos "Array"
						   //if i echo $test2 i get Gauge32: 38
						  //when i should echo $count i should get 38
						   //this does not work *****************

			} catch (PDOException $e) {
						    echo "Error: " . $e->getMessage();
						    }//end pdo insert to database.
			}
			$pdo = null;
?>