/** * 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, t4.cuisine_type FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3, type_of_cuisine as t4 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Receptions/Weddings ' AND t1.est_id = t3.est_id AND t3.ent_type = 'Featured Hotspots' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Salad' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Place to Go: Bars/Nightclubs Billiards/Pool Halls Outdoor/Patio Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out WiFi Hotspots
Cuisine: American Pizza Salad Soup Steaks Subs Vegetarian
Amenities Arcade Games Banquet Big Screen TV Bingo Birthday Parties Brunch Specials Darts Family Friendly Featured Hotspots Happy Hour Indoor Sports Jukebox Karaoke Kids Eat Free Outdoor/Patio Pool Tables Pull tabs Receptions/wedding Restaurant Employee Hospitality Specials Trivia Wi-Fi
Place to Go: Bakery Cafés Catering Deli Delivery Outdoor/Patio Receptions/Weddings Restaurants Take Out WiFi Hotspots
Cuisine: American Breakfast Cookies Cupcakes Muffins Organic Pizza Salad Soup Subs Vegan Vegetarian
Amenities Birthday Parties Catering Family Friendly Featured Hotspots Outdoor/Patio Receptions/wedding Wi-Fi
Place to Go: Bars/Nightclubs Catering Receptions/Weddings Reservations Accepted Restaurants Take Out WiFi Hotspots
Cuisine: American Italian Pizza Salad Seafood Soup Steaks Vegan Vegetarian
Amenities Banquet Brunch Catering Featured Hotspots Happy Hour Receptions/wedding Wi-Fi
Place to Go: Bars/Nightclubs Breakfast Cafés Catering Delivery Fine Dining Martini Bar Outdoor/Patio Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out Weekend Breakfast/Brunch WiFi Hotspots
Cuisine: American Italian Mexican Modern Comfort Food Pizza Salad Seafood Soup Steaks Tapas Vegetarian
Amenities Banquet Big Screen TV Birthday Parties Brunch Brunch Specials Catering Featured Hotspots Happy Hour Karaoke Live Music Outdoor/Patio Receptions/wedding Satellite TV Trivia Wi-Fi
Place to Go: Bars/Nightclubs Catering Outdoor/Patio Receptions/Weddings Reservations Accepted Restaurants Take Out WiFi Hotspots
Cuisine: All Deitary Needs Custom Menu Options Gluten Free MSG Free Organic Salad Seafood Soup Sushi Thai Vegan Vegetarian
Amenities Birthday Parties Catering Family Friendly Featured Hotspots Outdoor/Patio Receptions/wedding Wi-Fi
Place to Go: Bars/Nightclubs Catering Music Venue Outdoor/Patio Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out WiFi Hotspots
Cuisine: American Breakfast Salad Seafood Soup Vegan Vietnamese
Amenities Arcade Games Bar Bingo Big Screen TV Birthday Parties Breakfast Brunch Brunch Specials Catering College Football Corporate Team Building Family Friendly Featured Hotspots Happy Hour Jukebox Karaoke Live Music Outdoor/Patio Progressive Bingo Pull tabs Receptions/wedding Restaurant Employee Hospitality Specials Trivia Wi-Fi
Place to Go: Bars/Nightclubs Catering Pizza Receptions/Weddings Reservations Accepted Restaurants Take Out
Cuisine: American Italian Pizza Salad Soup Subs Vegetarian
Amenities Big Screen TV Birthday Parties Catering College Football College Sport Team Specials Family Friendly Featured Hotspots Grooms Dinners Kids Eat Free Receptions/wedding
1 - 7 of 7 Results |