open_connection(); } public function open_connection() { $this->connection = mysqli_connect(DB_SERVER, DB_USER, DB_PASS, DB_NAME); if(mysqli_connect_errno()) { die("Database connection failed: " . mysqli_connect_error() . " (" . mysqli_connect_errno() . ")" ); } } public function close_connection() { if(isset($this->connection)) { mysqli_close($this->connection); unset($this->connection); } } public function query($sql) { $result = mysqli_query($this->connection, $sql); $this->confirm_query($result); return $result; } private function confirm_query($result) { if (!$result) { die("Database query failed."); } } } $database = new MySQLDatabase(); function get_bands_by_day($day, $web_display, $ord) { global $database; $result = $database->query("SELECT DISTINCT schedule.artist_id, artists.artist_name, artists.artist_website, artists.mail_city, artists.mail_state, artist_events.web_display FROM schedule JOIN artists ON schedule.artist_id = artists.artist_id JOIN artist_events ON artists.artist_id = artist_events.artist_id WHERE schedule.event_id = 13 AND schedule.perform_date = '".$day."' AND artist_events.web_display = ".$web_display." ORDER BY ".$ord." ASC"); return $result; } //images path for lineup $ip = "/var/www/html/2016/images/"; ?>

Latest News

SOCIAL CONNECTION

Twitter

JUST ANNOUNCED

15 / JANUARY / 2016

We are excited to announce Jordan Feliz to the line-up. Jordan Feliz moved to Nashville, got signed to a Indie Christian Label, and has a huge single killing the Radio Charts called "The River". Welcome back Jordan.

TICKETS NOW ON SALE

15 / JANUARY / 2016

We are excited to announce Jordan Feliz to the line-up. Jordan Feliz moved to Nashville, got signed to a Indie Christian Label, and has a huge single killing the Radio Charts called "The River". Welcome back Jordan.

PARDON THE MESS

15 / JANUARY / 2016

We are excited to announce Jordan Feliz to the line-up. Jordan Feliz moved to Nashville, got signed to a Indie Christian Label, and has a huge single killing the Radio Charts called "The River". Welcome back Jordan.

Share Post

Leave a Comment

Submitting Comment...

The server encountered an error.

Form received.

JOSHUA FEST

Copyright © 2016 Joshua Fest. All rights reserved.