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 = 'Big Screen TV' AND t1.est_id = t5.est_id AND t5.music_type = 'Hip Hop' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30 Outdoor/Patio Hip Hop Music with Big Screen TV in the Twin Cities | Twincitiesfun.com



Outdoor/Patio Hip Hop Music with Big Screen TV in the Twin Cities

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

Bogart's Nightclub / Apple Place Lanes

14917 Garrett Avenue S Apple Valley, MN 55124
952-432-1515

Place to Go: 21+ Clubs  Arcades  Bars/Nightclubs  Bowling Alleys  Nightclub  Outdoor/Patio  Pizza  Restaurants  Sports Bars  Take Out 

Music: 80's  All Types  Bar Top 40  Hip Hop  Live Music  R&B  Rock 

Amenities Arcade Games  Big Screen TV  Birthday Parties  Bowling  Corporate Team Building  Dancing  Family Friendly  Jukebox  Karaoke  Ladies Night  Live DJ  Live Music  Outdoor/Patio  Pool Tables  Pull tabs  Restaurant Employee Night  Take Out  Texas Hold'em 

Great Sun Buffet & Bar

1400 Nicollet Ave S. Minneapolis, MN 55403
612-871-2898

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

Music: Country  DJ  Hip Hop  House  Live Music  R&B  Reggae  Techno 

Amenities Bachelor/ette Party Specials  Big Screen TV  Birthday Parties  Catering  Family Friendly  Happy Hour  Kids Eat Free  Live Music  Outdoor/Patio  Restaurant Employee Hospitality Specials  Wi-Fi 

Senor Wong Resturant | Cocktail Lounge

111 East Kellogg Blvd St. Paul, MN 55101
651-224-2019

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

Music: Alternative  DJ  Folk  Hip Hop  House  Jazz  Latin  Punk Rock 

Amenities Big Screen TV  Darts  Family Friendly  Movies  Outdoor/Patio  Pool Tables  Receptions/wedding  Reservations Accepted  Restaurant Employee Night  Take Out  Wi-Fi 

Stadium Sports Bar

3600 Hoffman Rd White Bear Lake, MN 55110
651-770-8670

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

Music: Alternative  Blues  Country  Hip Hop  House  Rap  Rock 

Amenities Arcade Games  Big Screen TV  Darts  Family Friendly  NFL Sunday Ticket  Outdoor/Patio  Pull tabs  Receptions/wedding  Reservations Accepted 

Saba's Sports Bar & Grill

Closed Shakopee, MN 55379
952-496-9044

Place to Go: 21+ Clubs  Bars/Nightclubs  Billiards/Pool Halls  Nightclub  Outdoor/Patio  Restaurants  Sports Bars 

Music: DJ  Hip Hop  Jukebox  Latin  Mexican  R&B  Rap  Rock  Salsa 

Amenities Arcade Games  Big Screen TV  Dancing  Darts  Family Friendly  Ladies Night  NFL Sunday Ticket  Outdoor/Patio  Pool Tables  Soccer  Trivia 


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