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();
