$this->rain_noah3[$i] = $row;
}
}
}
$i = $i + 1;
}
}
}
global $con;
$con = mysqli_connect($host, $user, $pass, $db);
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$query = "SELECT max_rain_2year, rain_noah, rain_noah2, rain_noah3 FROM site_rain_props WHERE LEFT(name,3) = '{$site}'";
$result = mysqli_query($con, $query);
$maxAndTables = mysqli_fetch_assoc($result);
//var_dump($maxAndTables);
$noahArray = ['rain_noah', 'rain_noah2', 'rain_noah3'];
$rain_info = new Noah();
//var_dump($noah);
$rain_info->max_rain_2year = $maxAndTables['max_rain_2year'];
foreach ($noahArray as $name) {
$rain_info->getData($con, $name, $maxAndTables[$name], $start_date, $end_date, $limit);
}
//var_dump($rain_info);
mysqli_close($con);
//echo json_encode($rain_info);
return json_encode($rain_info);
}
# Testing Area
# getRainfallNoah('agb', '2015-01-21', null, null, null, null, null, null);
