<?
/**
* Programmer    : Nitin
* Module 	: Database Connection
* File Name : DBConnection.php
* Description : Database Connection Class
* Versions 	: PHP5, Apache 2.0 
* Last Modified : 23/08/2006
*/

class DBConnection {    

	var $connection, $statement, $dbQuery, $dbResult;

	// ///////////////////////////////////////////////////// //
	// PHP and MySQL Connection and Error Specific methods
	// ///////////////////////////////////////////////////// //
    
	function DBConnection()
	{
		//try {
			$dbUsername = MYSQL_DB_USER;
			$dbPassword = MYSQL_DB_PWD;
			$dbServer = MYSQL_DB_SERVER;
			$dbName = MYSQL_DB_NAME;

			// Use mysqli_connect instead of deprecated mysql_connect
			$connection = mysqli_connect($dbServer, $dbUsername, $dbPassword, $dbName);

			if(!$connection) {
			    $this->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
?>
<br/><br/><br/><br/><b>Connecting to MySQL server: p3plzcpnl506558.prod.phx3.secureserver.net with user: twincitiesfun</b><br/>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, t5.music_type, t7.event_type FROM est_overview AS t1, type_of_est as t2, type_of_music as t5, daily_events as t7 WHERE t1.publish = 'Y'  AND t1.est_id = t2.est_id AND t2.est_type = 'Outdoor/Patio           ' AND t1.est_id = t5.est_id AND t5.music_type = 'DJ' AND t1.est_id = t7.est_id AND t7.dotw = 'Thursday' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30Query: 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, t5.music_type, t7.event_type FROM est_overview AS t1, type_of_est as t2, type_of_music as t5, daily_events as t7 WHERE t1.publish = 'Y'  AND t1.est_id = t2.est_id AND t2.est_type = 'Outdoor/Patio           ' AND t1.est_id = t5.est_id AND t5.music_type = 'DJ' AND t1.est_id = t7.est_id AND t7.dotw = 'Thursday' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30<br/><br/><br/>Search is temporary unavailable.Query: SELECT date_format(date2, '%Y-%c-%e') as ArticleDate FROM featured_events<br/>Query: SELECT eo.est_id, est_name, est_city, icon FROM est_overview as eo, type_of_est as toe WHERE eo.est_id = toe.est_id AND toe.est_type = 'Restaurants' AND eo.accnt_type = 'P' AND publish = 'Y' ORDER BY RAND() LIMIT 3<br/>Query: SELECT eo.est_id, title, `description`, est_name, est_city FROM perks as p, est_overview as eo WHERE eo.est_id = p.est_id AND eo.publish = 'Y' ORDER BY RAND() LIMIT 3<br/>Query: SELECT est_type, count(*) AS Count FROM type_of_est as toe, est_overview as eo WHERE eo.est_id = toe.est_id AND eo.accnt_type = 'P' GROUP BY toe.est_type ORDER BY Count DESC LIMIT 8<br/>Query: SELECT ent_type, count(*) AS Count FROM type_of_entertain as toe, est_overview as eo WHERE eo.est_id = toe.est_id  AND eo.accnt_type = 'P' GROUP BY toe.ent_type ORDER BY Count DESC LIMIT 8<br/>Query: SELECT cuisine_type, count(*) AS Count FROM type_of_cuisine as toc, est_overview as eo WHERE eo.est_id = toc.est_id AND eo.accnt_type = 'P' GROUP BY toc.cuisine_type ORDER BY Count DESC LIMIT 8<br/>Query: SELECT music_type, count(*) AS Count FROM type_of_music as tom, est_overview as eo WHERE eo.est_id = tom.est_id AND eo.accnt_type = 'P' GROUP BY tom.music_type ORDER BY Count DESC LIMIT 8<br/>Query: SELECT perks_type, count(*) AS Count FROM type_of_perks as top, est_overview as eo WHERE eo.est_id = top.est_id AND eo.accnt_type = 'P' GROUP BY top.perks_type ORDER BY Count DESC LIMIT 8<br/>Query: SELECT est_city, count(*) AS Count FROM est_overview as eo WHERE eo.accnt_type = 'P' GROUP BY eo.est_city ORDER BY Count DESC LIMIT 8<br/>Query: SELECT event_type, count(*) AS Count FROM daily_events as de, est_overview as eo WHERE eo.est_id = de.est_id GROUP BY de.event_type ORDER BY Count DESC LIMIT 9<br/>Query: SELECT dotw, dotw_num, count(*) AS Count FROM daily_events as de, est_overview as eo WHERE eo.est_id = de.est_id GROUP BY de.dotw, de.dotw_num ORDER BY dotw_num ASC LIMIT 7<br/><!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <meta name="description" content="">
    <meta name="author" content="">
    <link rel="icon" type="image/x-icon" href="/img/favicon.ico" />

	
    <title>Things to do Thursdays Outdoor/Patio            DJ Music in the Twin Cities | Twincitiesfun.com</title>

    <!-- Bootstrap core CSS -->
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css" integrity="sha512-dTfge/zgoMYpP7QbHy4gWMEGsbsdZeCXz7irItjcC3sPUFtf0kuFbDz/ixG7ArTxmDjLXDmezHubeNikyKGVyQ==" crossorigin="anonymous">

	<!-- custom style -->
	<link rel="stylesheet" href="custom_style.css?v=1">

    <!-- Custom styles for this template -->
    <link href="/sticky-footer-navbar.css" rel="stylesheet">


    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
  </head>
  

  <body>
<?
	if($show_nav!==false) {
		require 'nav.php';
	}
?>
<br/><br/><br/><br/>
  <!--
	<div class="container-fluid" style="padding-top:60px">
		<div class="row">
			<div class="col-xs-12 text-center hidden-xs">
				<a href="http://www.discountpartybusmn.com" target="_blank">
					<img src="/img/DPB728x90.jpg" style='max-width:100%;'>
				</a>
			</div>
			<div class="col-xs-12 text-center visible-xs">
				<a href="http://www.discountpartybusmn.com" target="_blank">
					<img src="/images/discount_party_bus_logo_only.jpg" style='max-width:100%;'>
				</a>
			</div>
		
		</div>
	</div>
	-->

	
	<!-- Begin page content -->
    <div class="container-fluid" style="padding-top:10px;">
    	<div class="row">
    		<div class='col-xs-12'>
    			<div >
	<!-- Pagetitle -->
	<h1 class="pagetitle" align="center">Things to do Thursdays Outdoor/Patio            DJ Music in the Twin Cities</h1>

		
	<div class='visible-xs text-center' style='padding-top:15px;padding-bottom:15px;'>
		1 Result, Scroll down to view
	</div>
	<div class='hidden-xs'>
	<div align="center" style="margin-top:4px;margin-bottom:4px;"></div>	</div>	
</div>			</div>
		</div>
		
    	<div class="row">
			<div class="col-sm-3 col-xs-12">
							</div>
			<div class="col-sm-6  col-xs-12">
							</div>
			<div class="col-sm-3 col-xs-12">
				
	
			<div class="panel panel-default">
			<div class="panel-heading">
				<div class="panel-title">Popular Searches</div>
			</div>
			<div class="panel-body">
				<p><a href="search.php?dotw=all&event_type=Happy+Hour&est_city=Minneapolis">Minneapolis Happy Hour</a></p>
				<p><a href="search.php?est_city=Minneapolis&est_type=Restaurants">Minneapolis Restaurants</a></p>
				<p><a href="search.php?est_city=St.+Paul&event_type=Lunch+Specials">Lunch Specials at Restaurants in St. Paul</a></p>
				<p><a href="search.php?est_type=Bars/Nightclubs&ent_type=Indoor+Sports">Bars/Nightclubs with Indoor Sports</a></p>
				<p><a href="search.php?est_city=Minneapolis&event_type=Drink+Specials">Drink Specials in Mpls</a></p>
			</div>
		</div>
	
	
			<div class="panel panel-default">
			<div class="panel-body">
				<div align="center" style="margin-top:4px;margin-bottom:4px;"></div>			</div>
		</div>
	
	
			</div>
		</div>
	</div>

<?
// Initialize footer content display variable if not set
if (!isset($show_footer_content)) {
    $show_footer_content = true; // Default to showing footer content
}
// Initialize validator JS requirement variable if not set
if (!isset($require_validator_js)) {
    $require_validator_js = false; // Default to not requiring validator JS
}
?>
    <footer class="footer">
      <div class="container">
      	<p class="text-muted">
      		<!-- 
			<div class='pull-right'>
				<a href="/sitemap.xml">Sitemap</a>
			</div>
			-->
			 <!-- pull-left -->
			Copyright 2025 TwinCitiesFun.com.
			
		</p>
      	
      	
      	<!--
      	<p class="text-muted">
			<div class='pull-right'>
				<a href="/sitemap.xml">Sitemap</a>
			</div>
			<div class='pull-right'>
				<a href="/sitemap.xml">Sitemap</a>
			</div>
			<div class='pull-right'>
				<a href="/sitemap.xml">Sitemap</a>
			</div>
			<div class='pull-left'>
				Copyright 2025 TwinCitiesFun.com.
			</div>
		</p>
		-->
      </div>
      
    </footer>

    <!-- Bootstrap core JavaScript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js" integrity="sha512-K1qjQ+NcF2TYO/eI3M6v8EiNYZfA95pQumfvcVrTHtwQVDG+aHRqLi/ETn2uB+1JqwYqVG3LIvdm9lj6imS/pQ==" crossorigin="anonymous"></script>
	
    <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
    <script src="/ie10-viewport-bug-workaround.js"></script>
    
    
<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-77Z6KG7R2Y"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'G-77Z6KG7R2Y');
</script>
  </body>
</html>