/** * 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 = 'Reservations Accepted ' AND t1.est_id = t3.est_id AND t3.ent_type = 'Private Party ' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Steaks' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Place to Go: Bars/Nightclubs Reservations Accepted Restaurants Sports Bars Take Out WiFi Hotspots
Cuisine: American BBQ Burgers Chicken Fish Pizza Salad Seafood Soup Southern BBQ Steaks Take out Vegetarian Wings
Amenities Arcade Games Banquet Big Screen TV Birthday Parties Darts Happy Hour Private Party Receptions/wedding Reservations Accepted Wi-Fi
Place to Go: Bars/Nightclubs Breakfast Catering Outdoor/Patio Receptions/Weddings Reservations Accepted Restaurants Sports Bars Take Out
Cuisine: American Breakfast Burgers Fish Pizza Salad Soup Steaks Take out Vegetarian
Amenities Arcade Games Bachelor/ette Party Specials Banquet Bar Bingo Big Screen TV Bingo Birthday Parties Breakfast Catering Dart Tournaments Darts Dine in / Take out Guys Night Happy Hour Jukebox Karaoke Ladies Night Live DJ Live Music Meat Raffle Outdoor/Patio Private Party Pull tabs Receptions/wedding Reservations Accepted Steel tip Darts Take Out
Place to Go: Bars/Nightclubs Catering Receptions/Weddings Reservations Accepted Restaurants Take Out
Cuisine: American Asian BBQ Buffet Catering Chinese Fish fresh Salad Grill Hmong Japanese Korean Laos Meat Salad Salad Bar Seafood Steaks Sushi Take out Thai Vegetarian Vietnamese
Amenities All You Can Eat Banquet Birthday Parties Buffet Catering Children's Menu Family Friendly Karaoke Private Party Receptions/wedding Reservations Accepted Take Out
Place to Go: Arcades Bars/Nightclubs Catering Outdoor/Patio Reservations Accepted Restaurants Sports Bars Take Out Weekend Breakfast/Brunch WiFi Hotspots
Cuisine: American BBQ Burgers Catering Chicken Fish fresh Salad Italian Mediterranean Mexican Seafood Soup Steaks Take out Vegetarian Weekend Breakfast Wings
Amenities Arcade Games Ballon lady (kids) Banquet Bar Bingo Big Screen TV Bingo Birthday Parties Breakfast Breakfast Weekend Brunch Specials Darts DTV Family Friendly Family Fun Gift Cards Happy Hour Jukebox Karaoke Live Music Meeting Room Outdoor/Patio Private Party Pull tabs Reservations Accepted Take Out Trivia Wi-Fi
1 - 4 of 4 Results |