public function query($sql, $params = []) {
$stmt = $this->pdo->prepare($sql);
$stmt->execute($params);
return $stmt;
}
private function __construct() {
$dsn = "mysql:host=$this->host;dbname=$this->db;charset=$this->charset";
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
try {
$this->pdo = new PDO($dsn, $this->user, $this->pass, $options);
} catch (PDOException $e) {
throw new PDOException($e->getMessage(), (int)$e->getCode());
}
}
// UPLINK_ESTABLISHMENT
SECURE_COMMUNICATION
// NODE_LOCATION
SECTOR: 7-G
LATITUDE: 38.5767° N
LONGITUDE: 92.1735° W
TIMEZONE: UTC-6
UPLINK_VIEW_ACTIVE
