baseline

baseline.php

        <?php
        
        //Pull historical daily; assumes that historical has at least as many years as the generated.
        $sql = "select * from verde_historical_daily where year <= :year";
        
        $core = Core::getInstance();
        $stmt = $core->dbh->prepare($sql);
        $stmt->bindParam(':year', $totalYears, PDO::PARAM_INT);
        try {
            $stmt->execute()
            while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
                $historicalDailyYear[] = $row['year'];
                $historicalDailyDay[] = $row['day'];
                $historicalDailyFlow[] = $row['flow'];
            }
        }
        catch (PDOException $e){
            echo $e->getMessage();
        }