connect_error ) {
die( "Connection failed: " . $conn->connect_error );
}
//========== GET ABOUT US DATA FROM DATABASE ==============
$sql = "SELECT *FROM content WHERE page='$content_call'";
$result = $conn->query( $sql );
if ( $result->num_rows > 0 ) {
// output data of each row
while ( $row = $result->fetch_assoc() ) {
$thecontent = $row[ 'content' ];
}
} else {
//echo "0 results";
}
//========== GET EVENT DATA FROM DATABASE ==============
if (empty($_GET['id'])) {
$page_id='1';
}
else{
$page_id=$_GET['id'];
}
$sql = "SELECT *FROM events WHERE id='$page_id' ";
$result = $conn->query( $sql );
if ( $result->num_rows > 0 ) {
// output data of each row
while ( $row = $result->fetch_assoc() ) {
$event_name = $row[ 'event_name' ];
$content = $row[ 'event_content' ];
$id = $row[ 'id' ];
$start_time = $row[ 'event_time_start' ];
$finish_time = $row[ 'event_time_finish' ];
$location = $row[ 'event_location' ];
$event_month = $row[ 'event_month' ];
$event_day = $row[ 'event_day' ];
$event_year = $row[ 'event_year' ];
}
} else {
//echo "0 results";
}
if($event_month == '01'){
$event_month = "January";
}
elseif($event_month == '02'){
$event_month = "Febuary";
}
elseif($event_month == '03'){
$event_month = "March";
}
elseif($event_month == '04'){
$event_month = "Aprial";
}
elseif($event_month == '05'){
$event_month = "May";
}
elseif($event_month == '06'){
$event_month = "June";
}
elseif($event_month == '07'){
$event_month = "July";
}
elseif($event_month == '08'){
$event_month = "August";
}
elseif($event_month == '09'){
$event_month = "September";
}
elseif($event_month == '10'){
$event_month = "October";
}
elseif($event_month == '11'){
$event_month = "November";
}
elseif($event_month == '12'){
$event_month = "December";
}
//Create the count down
$date = strtotime("$event_month $event_day, $event_year $start_time");
$remaining = $date - time();
$days_remaining = floor($remaining/60/60/24);
$hours_remaining = floor(($remaining-($days_remaining*60*60*24))/60/60);
$min_remaining = floor(($remaining-($days_remaining*60*60*24)-($hours_remaining*60*60))/60);
$seconds_remaining = floor((($remaining-($days_remaining*60*60*24)-($hours_remaining*60*60))-($minutes_remaining*60))/120);
$sql = "SELECT *FROM events";
$result = $conn->query( $sql );
if ( $result->num_rows > 0 ) {
// output data of each row
while ( $row = $result->fetch_assoc() ) {
$side_bar_events .= " ".$row[ 'event_name' ]."".$row[ 'event_month' ]."";
}
} else {
echo "0 results";
}
$conn->close();
?>
