saveIntoErrorLog("DBConnection.php", "DBConnection()", "mysqli_connect()", mysqli_connect_error()); return false; } // Set charset for the connection mysqli_set_charset($connection, 'utf8'); $this->connection = $connection; $this->statement = true; // With mysqli_connect, database is selected automatically return true; /*} catch (Exception $e) { $this->saveIntoErrorLog("DBConnection.php", "DBConnection()", "", $e); return false; }*/ } function CloseConnection() { //try { $close = mysqli_close($this->connection); if(!$close) { $this->saveIntoErrorLog("DBConnection.php", "CloseConnection()", "mysqli_close()"); } return true; /*} catch (Exception $e) { $this->saveIntoErrorLog("DBConnection.php", "CloseConnection()", "", $e); return false; }*/ } /** * Execute query for select */ function SelectQuery($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysql_query($this->dbQuery, $this->connection); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $rowCount = 0; $resultData = array(); while($rowData = mysql_fetch_array($this->dbResult, MYSQL_ASSOC)) { $resultData[$rowCount] = $rowData; $rowCount++; } mysql_free_result($this->dbResult); return $resultData; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Execute query for Insert */ function InsertQuery($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysql_query($this->dbQuery, $this->connection); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $id = mysql_insert_id(); mysql_free_result($this->dbResult); return $id; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Execute query for Update/Delete */ function ExecuteQuery($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysqli_query($this->connection, $this->dbQuery); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $rows = 0; $rows = mysqli_affected_rows($this->connection); mysqli_free_result($this->dbResult); return $rows; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Execute queries for webservice */ function SelectQueryResult($fileName="", $methodName="") { //try { if($this->connection && $this->statement) { if(empty($this->dbQuery)) { return false; } $this->dbResult = mysql_query($this->dbQuery, $this->connection); if(!$this->dbResult) { $this->saveIntoErrorLog($fileName, $methodName, $this->dbQuery); return false; } $resultData = $this->dbResult; //mysql_free_result($this->dbResult); return $resultData; } else { return false; } /*} catch (Exception $e) { $this->saveIntoErrorLog($fileName, $methodName, "", $e); return false; }*/ } /** * Use this method to log the database errors. */ function saveIntoErrorLog($fileName="", $methodName="", $sqlQuery="", $exception="") { $errorCode = mysql_errno(); $errorText = mysql_error(); $errorMessage = "File: ".$fileName.", Method/Function: ".$methodName.", Query: ".$sqlQuery.", Error: ".$errorCode."-".$errorText; if($exception != "") $errorMessage.= " Exception : ".$exception ; // timestamp for the error entry $errorMessage = "[".date("j-M-Y H:i:s (T)")."] ".$errorMessage."\r\n"; // save to the error log error_log($errorMessage, 3, ERROR_LOG."ErrorLog".date("j-M-Y").".log"); } } //ends the class over here ?> SELECT t1.est_id, t1.icon, t1.est_name, t1.est_street, t1.est_city, t1.est_state, t1.est_zip, t1.est_phone, t1.accnt_type, t1.percentoffcard, t2.est_type, t3.ent_type, t5.music_type FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Outdoor/Patio' AND t1.est_id = t3.est_id AND t3.ent_type = 'Jukebox ' AND t1.est_id = t5.est_id AND t5.music_type = 'DJ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30 Outdoor/Patio DJ Music with Jukebox in the Twin Cities | Twincitiesfun.com



Outdoor/Patio DJ Music with Jukebox in the Twin Cities

5 Results, Scroll down to view
Search Options
+More Map
Sort: Featured | Name | City
1 - 5 of 5 Results

Lord Fletcher's

3746 Sunset Dr Spring Park, MN 55384
952-471-8513

Place to Go: Bars/Nightclubs  Fine Dining  Nightclub  Outdoor/Patio  Restaurants  Sports Bars  Take Out 

Music: Acoustic  Blues  DJ  Jukebox  Live Music  Reggae  Rock 

Amenities Arcade Games  Banquet  Big Screen TV  Brunch  Catering  Dancing  Family Friendly  Indoor Sports  Jukebox  Karaoke  Ladies Night  Live Music  NFL Sunday Ticket  Open Mic/Amateur Night  Outdoor/Patio  Pull tabs  Receptions/wedding  Reservations Accepted  Sand Volleyball  Take Out 

SOS Social Club

1417 Helmo Ave. North Oakdale, MN 55128
651-735-2400

Place to Go: 18+ Clubs  Alcohol Free  Bars/Nightclubs  Billiards/Pool Halls  Cafés  Coffee/Tea Houses  Outdoor/Patio  Pizza  Restaurants  Social Club  WiFi Hotspots 

Music: Blues  DJ  Jazz  Jukebox  Live Music  R&B  Rock 

Amenities Arcade Games  Banquet  Big Screen TV  Birthday Parties  Cards  Dance Lessons  Dancing  Darts  Family Friendly  Featured Hotspots  Foosball  Jukebox  Live DJ  Live Music  Outdoor/Patio  Pool Tables  Receptions/wedding  TV  Wi-Fi 

Vannelli's By The Lake

55 S. Lake St Forest Lake, MN 55025
651-395-2400

Place to Go: Bars/Nightclubs  Catering  Delivery  Music Venue  Outdoor/Patio  Pizza  Receptions/Weddings  Reservations Accepted  Restaurants  Sports Bars  Take Out  WiFi Hotspots 

Music: 80's  Country  DJ  House  Jukebox  Live Music  Rock  Top 40 

Amenities Arcade Games  Bachelor/ette Party Specials  Banquet  Bar Bingo  Big Screen TV  Birthday Parties  Brunch  Brunch Specials  Catering  Darts  Family Friendly  Featured Hotspots  Happy Hour  Indoor Bocce Ball  Indoor Sports  Jukebox  Karaoke  Live Music  Outdoor/Patio  Progressive Bingo  Pull tabs  Receptions/wedding  Wi-Fi 

End Zone Bar & Grill

Closed Ramsey, MN 55303
763-433-2615

Place to Go: Bars/Nightclubs  Outdoor/Patio  Reservations Accepted  Restaurants  Sports Bars  Take Out  WiFi Hotspots 

Music: 80's  Acoustic  Country  DJ  House  Jukebox  Live Music  Oldies  Rock  Top 40 

Amenities Arcade Games  Bar Bingo  Big Screen TV  Birthday Parties  College Football  Darts  DTV  Family Friendly  Featured Hotspots  Happy Hour  Jukebox  Ladies Night  Live Music  Outdoor/Patio  Progressive Bingo  Pull tabs  Texas Hold'em  Wi-Fi 

Fatboys Bar & Grill

Closed East Bethel, MN 55011
763-434-8181

Place to Go: Bars/Nightclubs  Nightclub  Outdoor/Patio  Restaurants  Sports Bars  Take Out 

Music: Acoustic  Blues  Country  DJ  House  Jukebox  Live Music  R&B  Rock 

Amenities Arcade Games  Big Screen TV  Brunch  Catering  Dancing  Darts  Family Friendly  Jukebox  Karaoke  Kids Eat Free  Ladies Night  Live Music  NFL Sunday Ticket  Outdoor/Patio  Pool Tables  Pull tabs  Receptions/wedding  Take Out  Texas Hold'em 


1 - 5 of 5 Results
*All information is deemed reliable, but unfortunatly cannot not be guaranteed. Events & prices are subject to change.
Popular Searches

Minneapolis Happy Hour

Minneapolis Restaurants

Lunch Specials at Restaurants in St. Paul

Bars/Nightclubs with Indoor Sports

Drink Specials in Mpls