/** * 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 FROM est_overview AS t1, type_of_est as t2, type_of_entertain as t3 WHERE t1.publish = 'Y' AND t1.est_id = t2.est_id AND t2.est_type = 'Restaurants' AND t1.est_id = t3.est_id AND t3.ent_type = 'Birthday Parties' AND substring(t1.est_name,1,1) = 'a ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
1 - 7 of 7 Results |
|
Place to Go: Bars/Nightclubs Delivery Pizza Reservations Accepted Restaurants Sports Bars Take Out WiFi Hotspots
Amenities Arcade Games Bar Bingo Big Screen TV Birthday Parties Catering Darts Family Friendly Happy Hour Karaoke Pull tabs Texas Hold'em Trivia Wi-Fi
Place to Go: Cafés Deli Restaurants Take Out
Amenities Banquet Birthday Parties Catering Family Friendly Receptions/wedding Take Out
Place to Go: Bars/Nightclubs Nightclub Restaurants
Amenities Arcade Games Bachelor/ette Party Specials Banquet Big Screen TV Birthday Parties Brunch Catering Children's Menu College Football Darts Family Friendly Jukebox Live Music Meetings Pool Tables Pull tabs Receptions/wedding Reservations Accepted Texas Hold'em
Place to Go: Breakfest Catering Delivery Open 24 Hours Pizza Restaurants Take Out
Amenities Birthday Parties Catering Family Friendly
Place to Go: Breakfast Catering Delivery Open 24 Hours Pizza Restaurants Take Out
Amenities Birthday Parties Catering Family Friendly
Place to Go: Catering Delivery Receptions/Weddings Reservations Accepted Restaurants Take Out
Amenities Banquet Birthday Parties Brunch Catering Family Friendly Receptions/wedding Reservations Accepted Take Out
Place to Go: Bars/Nightclubs Cafés Catering Coffee/Tea Houses Outdoor/Patio Pizza Receptions/Weddings Restaurants Take Out WiFi Hotspots
Amenities Birthday Parties Brunch Catering Family Friendly Happy Hour Live Music Open Mic/Amateur Night Outdoor/Patio Receptions/wedding Wi-Fi
1 - 7 of 7 Results |