Connect to specified MySQL server
| public Open ( string $database = null, string $server = null, string $username = null, string $password = null, string $charset = null, boolean $pcon = false ) : boolean | ||
| $database | string | (Optional) Database name |
| $server | string | (Optional) Host address |
| $username | string | (Optional) User name |
| $password | string | (Optional) Password |
| $charset | string | (Optional) Character set |
| $pcon | boolean | (Optional) Persistant connection |
| return | boolean | Returns TRUE on success or FALSE on error |
function DB_Escape($String)
{
/******************************************************************************/
#$__args_types = Array('string');
#-------------------------------------------------------------------------------
$__args__ = Func_Get_Args();
eval(FUNCTION_INIT);
/******************************************************************************/
$Link =& Link_Get('DB');
#-------------------------------------------------------------------------------
if (!Is_Object($Link)) {
#-------------------------------------------------------------------------------
$Config = Config();
#-------------------------------------------------------------------------------
$Link = new MySQL($Config['DBConnection']);
#-------------------------------------------------------------------------------
if (Is_Error($Link->Open())) {
#-------------------------------------------------------------------------------
$Link = NULL;
#-------------------------------------------------------------------------------
return ERROR | @Trigger_Error('[DB_Query]: невозможно соединиться с базой данных');
#-------------------------------------------------------------------------------
}
#-------------------------------------------------------------------------------
if (Is_Error($Link->SelectDB())) {
#-------------------------------------------------------------------------------
$Link = NULL;
#-------------------------------------------------------------------------------
return ERROR | @Trigger_Error('[DB_Query]: невозможно выбрать базу данных');
#-------------------------------------------------------------------------------
}
#-------------------------------------------------------------------------------
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
return MySQL_Real_Escape_String($String);
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
}
<?php
ini_set("display_errors", 0);
include "./classes/mysql.class.php";
if ($_GET['pid'] == "") {
echo "enter pid in url";
exit;
} else {
$reqparam = $_GET['pid'];
}
$db = new MySQL();
$db->Open();
$sql1 = "SELECT p.name, DATE_FORMAT(p.age,'%d-%b-%Y') as dob, floor((((YEAR(NOW()) - YEAR(p.age)))*12 + (((MONTH(NOW()) - MONTH(p.age)))))/12) as age, place FROM person p where p.personid = '" . $reqparam . "'";
$row1 = $db->QueryArray($sql1);
?>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-type" content="text/html;charset=utf-8" />
<meta name="viewport" content="width=360, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0,target-densitydpi=device-dpi, user-scalable=no">
<meta http-equiv="cache-control" content="max-age=0" />
<meta http-equiv="cache-control" content="no-cache" />
<meta http-equiv="expires" content="0" />
<meta http-equiv="expires" content="Tue, 01 Jan 1980 1:00:00 GMT" />
<meta http-equiv="pragma" content="no-cache" />
<title><?php
echo $row1[0][0];
?>
- Filmography</title>
<!-- / END -->
-- --------------------------------------------
-- SQL to generate test table
-- --------------------------------------------
CREATE TABLE `test` (
`TestID` int(10) NOT NULL auto_increment,
`Color` varchar(15) default NULL,
`Age` int(10) default NULL,
PRIMARY KEY (`TestID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------
*/
// --- Open the database --------------------------------------------
// (Also note that you can fill in the variables in the top of the class
// if you want to automatically connect when the object is created. If
// you fill in the values when you create the obect, this is not needed.)
if (!$db->Open("test", "localhost", "root", "password")) {
$db->Kill();
}
echo "You are connected to the database<br />\n";
// --- Insert a new record ------------------------------------------
$sql = "INSERT INTO Test (Color, Age) Values ('Red', 7)";
if (!$db->Query($sql)) {
$db->Kill();
}
echo "Last ID inserted was: " . $db->GetLastInsertID();
// --- Or insert a new record with transaction processing -----------
$sql = "INSERT INTO Test (Color, Age) Values ('Blue', 3)";
$db->TransactionBegin();
if ($db->Query($sql)) {
$db->TransactionEnd();
echo "Last ID inserted was: " . $db->GetLastInsertID() . "<br /><br />\n";
// Twig engine
include_once $APP_DIR . "/lib/Twig/Autoloader.php";
Twig_Autoloader::register();
$loader = new Twig_Loader_Filesystem($APP_DIR . "/template");
if ($config->twig_cache) {
$twig = new Twig_Environment($loader, array('debug' => $config->twig_debug, 'cache' => $APP_DIR . "/cache/" . $env));
} else {
$twig = new Twig_Environment($loader, array('debug' => $config->twig_debug, 'cache' => ""));
}
//load extentions
$twig->addExtension(new Twig_Extension_User());
// BootStrap framework object
$cms = new bootstrap();
// Database framework object
$db = new MySQL();
if (!$db->Open($config->db_name, $config->db_host, $config->db_user, $config->db_pass)) {
echo "There was a error connecting to the database of ssa, please try again later.";
@$db->Kill();
}
$db->ThrowExceptions = true;
// User object
$user = new user();
//Set error settings
if ($config->debug) {
error_reporting(-1);
ini_set('display_errors', '1');
} else {
error_reporting(0);
ini_set('display_errors', '0');
}
// Stop loading stuff below, because its media
/*
*
* @project 0xSentinel
* @author KinG-InFeT
* @licence GNU/GPL
*
* @file banner.php
*
* @link http://0xproject.netsons.org#0xSentinel
*
*/
include "config.php";
include_once "lib/mysql.class.php";
include_once "lib/layout.class.php";
$mysql = new MySQL();
$mysql->Open($db_host, $db_user, $db_pass, $db_name);
$active = $mysql->Query("SELECT * FROM 0xSentinel_settings");
$row = mysql_fetch_array($active);
$image = "images/banner.png";
$im = ImageCreateFromPNG($image);
imageAlphaBlending($im, TRUE);
imageSaveAlpha($im, TRUE);
$txt_color = ImageColorAllocate($im, 80, 80, 80);
if ($row['active'] == 1) {
$color_status = ImageColorAllocate($im, 80, 80, 80);
} else {
$color_status = ImageColorAllocate($im, 255, 0, 0);
}
$attack_blocked = intval(mysql_num_rows($mysql->Query("SELECT * FROM 0xSentinel_logs")));
$version = VERSION;
ImageString($im, 2, 10, 25, "Version: {$version}", $txt_color);
$Args = Args();
#-------------------------------------------------------------------------------
$Server = (string) @$Args['Server'];
$Port = (int) @$Args['Port'];
$User = (string) @$Args['User'];
$Password = (string) @$Args['Password'];
$DbName = (string) @$Args['DbName'];
$Users = (string) @$Args['Users'];
#-------------------------------------------------------------------------------
$Course = 30;
#-------------------------------------------------------------------------------
$Params = array('Server' => $Server, 'Port' => $Port, 'User' => $User, 'Password' => $Password, 'DbName' => $DbName);
#-------------------------------------------------------------------------------
$Link = new MySQL($Params);
#-------------------------------------------------------------------------------
if (Is_Error($Link->Open())) {
return 'Не удалось подключиться к серверу MySQL';
}
#-------------------------------------------------------------------------------
$Result = $Link->Query(SPrintF('SET NAMES `%s`', $Charset));
if (Is_Error($Result)) {
return $Link->GetError();
}
#-------------------------------------------------------------------------------
if (Is_Error($Link->SelectDB())) {
return $Link->GetError();
}
#-------------------------------------------------------------------------------
$Query = 'SELECT * FROM `users`';
#-------------------------------------------------------------------------------
if ($Users) {
// Final step
if ($nextstep == 'final' && checkAuth()) {
//
// Installation actions
// - Set collected data
//
// Let's start with a clean sheet
$err = 0;
// Include MySQL class && initiate
/*MARKER*/
require_once BASE_PATH . '/lib/class/mysql.class.php';
$db = new MySQL();
//
// Try database connection
//
if (!$db->Open(null, $_SESSION['variables']['db_host'], $_SESSION['variables']['db_user'], $_SESSION['variables']['db_pass'], 'utf8', 'utf8_unicode_ci')) {
$errors[] = 'Error: could not connect to the database engine';
$errors[] = $db->Error();
$errors[] = $db->MyDyingMessage();
$err++;
} else {
$log[] = "Database engine connection successful";
}
//
// Either Select the database or create it when it does not exist yet
//
if (!$db->SelectDatabase($_SESSION['variables']['db_name'])) {
if (!$db->CreateDatabase($_SESSION['variables']['db_name'])) {
$errors[] = 'Error: could not create the database "' . $_SESSION['variables']['db_name'] . '"';
$errors[] = $db->Error();
$errors[] = $db->MyDyingMessage();
<?php
/* Basic Achievements MVC model */
require_once __ROOT__ . "core/includes/class/mysql.class.php";
require_once __ROOT__ . "core/includes/smarty/Smarty.class.php";
$db = new MySQL(false, $sql_dbname, $sql_host, $sql_user, $sql_pass, $sql_charset, $sql_pcon);
$success = $db->Open();
if (!$success) {
die("Couldn't establish database connection. Check your configuration file.");
}
$db->TimerStart();
require_once __ROOT__ . "core/includes/achievements/achievements.class.php";
$achievements = new Achievements();
require_once __ROOT__ . "core/includes/func/func.inc.php";
require_once __ROOT__ . "core/controllers/initialize.php";
$smarty = new Controller();
$smarty->setTemplateDir(__ROOT__ . "themes/{$current_theme}/");
require_once __ROOT__ . "/core/language/LanguageInit.inc.php";
require_once __ROOT__ . "core/controllers/main.ctr.php";
require_once __ROOT__ . "core/controllers/content_controllers/" . ACLIB::GetContent() . ".ctr.php";
$smarty->debugging = $smarty_debug;
$db->TimerStop();
if (isset($_GET['simplified'])) {
$smarty->displayTemplate(__ROOT__ . "themes/{$current_theme}/templates/main_game.tpl");
} else {
$smarty->displayTemplate(__ROOT__ . "themes/{$current_theme}/templates/main.tpl");
}
$language = $cfg['language'];
}
// blow away $cfg['language'] to ensure the language file(s) are loaded this time - it's our first anyhow.
unset($cfg['language']);
$language = SetUpLanguageAndLocale($language);
// SECURITY ==
// Include security file only for administration directory
$location = explode("/", $_SERVER['PHP_SELF']);
$php_src_is_admin_code = in_array("admin", $location);
if ($php_src_is_admin_code) {
/*MARKER*/
require_once BASE_PATH . '/admin/includes/security.inc.php';
}
// DATABASE ==
// All set! Now this statement will connect to the database
if (!$db->Open($cfg['db_name'], $cfg['db_host'], $cfg['db_user'], $cfg['db_pass'])) {
$db->Kill($ccms['lang']['system']['error_database']);
}
// ENVIRONMENT ==
// Some variables to help this file orientate on its environment
$current = basename(filterParam4FullFilePath($_SERVER['REQUEST_URI']));
// [i_a] $curr_page was identical (enough) to $pagereq before
$pagereq = checkSpecialPageName(getGETparam4Filename('page'), SPG_GIVE_PAGENAME);
$ccms['pagereq'] = $pagereq;
$ccms['printing'] = getGETparam4boolYN('printing', 'N');
$preview = getGETparam4IdOrNumber('preview');
// in fact, it's a hash plus ID!
$preview = IsValidPreviewCode($preview);
$ccms['preview'] = $preview ? 'Y' : 'N';
//$ccms['responsecode'] = null; // default: 200 : OK
//$ccms['page_id'] = false;