/** * 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 ?> 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, t7.event_type FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3, 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 = t3.est_id AND t3.ent_type = 'Receptions/wedding' AND t1.est_id = t7.est_id AND t7.dotw = 'Sunday' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Place to Go: Bars/Nightclubs Catering Outdoor/Patio Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out WiFi Hotspots
Amenities Arcade Games Bar Bingo Big Screen TV Brunch Specials Catering Darts Easter & Mothers Day Brunch Family Friendly Happy Hour Karaoke Kids Eat Free Meat Raffle Outdoor/Patio Progressive Bingo Pull tabs Receptions/wedding Restaurant Employee Hospitality Specials Tri-wheel® Wi-Fi
call ahead for order and hours of operation
Place to Go: Arcades Bars/Nightclubs Billiards/Pool Halls Bowling Alleys Nightclub Outdoor/Patio Restaurants Sand Volleyball Sports Bars Take Out
Amenities Arcade Games Banquet Big Screen TV Bowling Darts Family Friendly Indoor Sports Jukebox Outdoor/Patio Pool Tables Pull tabs Receptions/wedding Sand Volleyball Take Out Texas Hold'em Trivia
call ahead for order and hours of operation
Place to Go: 18+ Clubs 21+ Clubs Arcades Bars/Nightclubs Bowling Alleys Fun Nightclub Outdoor/Patio Restaurants Sports Bars Take Out
Amenities Arcade Games Banquet Big Screen TV Birthday Parties Bowling Family Friendly Jukebox Karaoke Receptions/wedding Take Out
call ahead for order and hours of operation
Place to Go: Bars/Nightclubs Cafés Catering Hookah Lounge Outdoor/Patio Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out WiFi Hotspots
Amenities Banquet Belly Dancing Big Screen TV Birthday Parties Catering Children's Menu Dancing Family Friendly Featured Hotspots Happy Hour Hookah Kids Eat Free Live DJ Outdoor/Patio Pull tabs Receptions/wedding Reservations Accepted Shisha Take Out Wi-Fi
call ahead for order and hours of operation
1 - 4 of 4 Results |