/**
* 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, t3.ent_type, t4.cuisine_type FROM est_overview AS t1, type_of_entertain as t3, type_of_cuisine as t4 WHERE t1.publish = 'Y' AND t1.est_id = t3.est_id AND t3.ent_type = 'Children\'s Menu' AND t1.est_id = t4.est_id AND t4.cuisine_type = 'Grill' AND substring(t1.est_name,1,1) = 'b ' GROUP BY t1.est_id ORDER BY t1.accnt_type ASC, t1.est_name ASC LIMIT 0, 30
Grill Food Children's Menu in the Twin Cities | Twincitiesfun.com
if($show_nav!==false) {
require 'nav.php';
}
?>
Grill Food Children's Menu in the Twin Cities
1 Result, Scroll down to view
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
3809 Highway 13 W. Burnsville, MN 55337
952-882-2911
Cuisine:
All Deitary Needs
American
Asian
Burgers
Dessert Menu
Fish
fresh Salad
Grill
Homemade Pastry
Jamaican
Kids Menu
Meat
Mexican
MSG Free
Pizza
Salad
Seafood
Soul Food
Southwestern
Specialty Sandwhich
Take out
Vegetarian
Wings
Amenities
Arcade Games
Bachelor/ette Party Specials
Bands
Birthday Parties
Children's Menu
Darts
Dine in / Take out
DTV
Family Friendly
Full-Service Bar
Gift Cards
Grooms Dinners
Happy Hour
Jukebox
Live Music
NFL Sunday Ticket
Outdoor/Patio
Private Party
Pull tabs
Receptions/wedding
Take Out
TV
Wi-Fi
*All information is deemed reliable, but unfortunatly cannot not be guaranteed. Events & prices are subject to change.
// Initialize footer content display variable if not set
if (!isset($show_footer_content)) {
$show_footer_content = true; // Default to showing footer content
}
// Initialize validator JS requirement variable if not set
if (!isset($require_validator_js)) {
$require_validator_js = false; // Default to not requiring validator JS
}
?>