/** * 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, t4.cuisine_type, t5.music_type FROM est_overview AS t1, type_of_est as t2, type_of_cuisine as t4, type_of_music as t5 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Receptions/Weddings ' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Vegetarian' AND t1.est_id = t5.est_id AND t5.music_type = 'Blues ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Place to Go: Bars/Nightclubs Cafés Catering Coffee/Tea Houses Outdoor/Patio Pizza Receptions/Weddings Restaurants Take Out WiFi Hotspots
Music: Acoustic Alternative Blues Country DJ Eclectic Folk Hip Hop House Irish Jazz Latin Live Concerts Live Music Other R&B Reggae Rock World
Cuisine: American Fish French Greek Mexican Muffins Organic Pizza Salad Soup Thai Vegan Vegetarian
Place to Go: Bars/Nightclubs Catering Receptions/Weddings Reservations Accepted Restaurants Take Out WiFi Hotspots
Music: 80's Blues House Jazz Live Music Rock Top 40
Cuisine: Salad Seafood Soup Vegetarian Vietnamese
Place to Go: Bars/Nightclubs Catering Delivery Music Venue Outdoor/Patio Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out WiFi Hotspots
Music: Blues House Live Music Rock Top 40
Cuisine: American Buffet Cafeteria Style Mexican Pizza Seafood Soup Steaks Subs Vegetarian
Place to Go: Bars/Nightclubs Catering Fundraising Outdoor/Patio Receptions/Weddings Rentals Reservations Accepted Restaurants Social Club Sports Bars Take Out WiFi Hotspots
Music: Blues Cajun Music Country Dinning Music Jazz Live Music Rock
Cuisine: American Burgers Chicken fresh Salad Pizza Salad Seafood Soup Vegetarian
Place to Go: Bars/Nightclubs Delivery Family Fun Outdoor/Patio Pizza Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out
Music: 80's Blues Country Eclectic House Jazz Live Music Rock Top 40 World
Cuisine: American Italian Pizza Salad Bar Subs Vegetarian Wings
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
Music: 80's Alternative Blues DJ Eclectic Jazz Latin Live Music Piano R&B Reggae Rock Salsa
Cuisine: American Italian Mexican Modern Comfort Food Pizza Salad Seafood Soup Steaks Tapas Vegetarian
Place to Go: 21+ Clubs Bars/Nightclubs Billiards/Pool Halls Catering Delivery Music Venue Outdoor/Patio Pizza Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out Weekend Breakfast/Brunch WiFi Hotspots
Music: Blues Country Live Music R&B Rock
Cuisine: American Breakfast Mexican Pizza Soup Steaks Vegetarian
1 - 7 of 7 Results |