require 'dbConnection.php'; require 'dateSpecification.php'; require 'functions.php'; try { // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM solemnities_or_feasts"; $result = $conn->query($sql); $events = array(); $datesSFM = array(); $counter = 0; $OTWeekdays = getWeekdaysOfOT(); $LentWeekdays = getWeekdaysOfLent(); $EasterWeekdays = getWeekdaysOfEaster(); $AdventWeekdays = getWeekdaysOfAdvent(); $OTSundays = getSundaysOfOT(); $LentSundays = getSundaysOfLent(); $EasterSundays = getSundaysOfEaster(); $AdventSundays = getSundaysOfEaster(); $otCount = count($OTWeekdays); $lentwCount = count($LentWeekdays); $easterwCount = count($EasterWeekdays); $adventwCount = count($AdventWeekdays); $otsCount = count($OTSundays); $lentsCount = count($OTSundays); $eastersCount = count($OTSundays); $adventsCount = count($OTSundays);
<?php require 'dbConnection.php'; require 'dateSpecification.php'; require 'eventDeterminant.php'; require 'functions.php'; //For Weekday $allWeekdays = getWeekdaysOfOT(); $countOfWeekdays = count($allWeekdays); //count of Sundays $skipCheck = $weekAfterPentecost - $weeksBeforeLent; //echo $skipCheck; //For Calendar try { $url = 'mysql:dbname=' . $dbname . ';host=' . $servername . ''; // Connect to database $connection = new PDO($url, $username, $password); // Prepare and execute query if ($skipCheck > 1) { $skipValue = $weeksBeforeLent + 1; //echo "You have reached if statement." . $skipValue; $query = "SELECT * FROM weekday_reading WHERE weekday_cycle_num = '" . $weekdayCycle . "' AND weekday_weeknum !='" . $skipValue . "'"; } else { $query = "SELECT * FROM weekday_reading WHERE weekday_cycle_type = '" . $weekdayCycle . "'"; //echo "You have reached else statement."; } //echo $query; $sth = $connection->prepare($query); $sth->execute(); // Returning array $events = array();