function systemDatabase() { $dbMainHost = "db153.pair.com"; $dbMainUser = "******"; $dbMainPass = "******"; $dbMainDbse = "reinfurt_point"; $dbConnect = MYSQL_CONNECT($dbMainHost, $dbMainUser, $dbMainPass); MYSQL_SELECT_DB($dbMainDbse, $dbConnect); }
/** * Connecting To Database; * * @param $debug = false; **/ private function Databases($debug = true) { global $config; $this->db = $config['iSafe']['databases']['db_name']; $this->db_host = $config['iSafe']['databases']['db_host']; $this->db_user = $config['iSafe']['databases']['db_user']; $this->db_pass = $config['iSafe']['databases']['db_pass']; MYSQL_CONNECT($this->db_host, $this->db_user, $this->db_pass) or die($this->debug(1, __LINE__, __FILE__)); MYSQL_SELECT_DB($this->db) or die($this->debug(2, __LINE__, __FILE__)); }
public function __construct($db) { $this->name = $db->getName(); // load relation list for table $this->relation = $db->relation; // establish connection to db server $this->dbResource = @MYSQL_CONNECT($db->server, $db->user, $db->password); if (!$this->dbResource) { OLIVError::fire('no database connection'); return FALSE; } else { // connection established // select database and set prefix @MYSQL_SELECT_DB($this->name); if (array_key_exists('prefix', $db)) { $this->prefix = $db['prefix']; } return $this->dbResource; } }
} // connected, now lets select the database if ($dbname) { if (!@MYSQL_SELECT_DB($dbname, $connection)) { // The database does not exist... try to create it: if (!@DB_Query("CREATE DATABASE {$dbname}")) { $installerrors[] = '创建数据库 "' . $dbname . '" 失败! 您的用户名可能没有创建数据库的权限.<br />' . mysql_error(); } else { mysql_query("set names 'utf8'"); mysql_query("SET COLLATION_CONNECTION='utf8_general_ci'"); mysql_query("ALTER DATABASE `{$dbname}` DEFAULT CHARACTER SET utf8 COLLATE 'utf8_general_ci'"); if ($sqlversion >= '5.0') { mysql_query("SET sql_mode=''"); } // Success! Database created MYSQL_SELECT_DB($dbname, $connection); } } } else { $installerrors[] = '请输入数据库名称.'; } } else { // could not connect $installerrors[] = '无法连接MySql数据库服务器, 信息:<br />' . mysql_error(); } } else { // mysql extensions not installed $installerrors[] = '网站服务器环境不支持MySql数据库.'; } if (!isset($installerrors)) { $SqlLines = @file('welive.sql');
class parser { function parse_message($text, $settings = array()) { return $text; } } $parser = new parser(); /* END */ preg_match('/^([a-z]+)\\./', $_SERVER['SERVER_NAME'], $subdomain); if (is_dir($cfg['language_abs'] . '/' . $subdomain[1]) && $subdomain[1] != "") { $flolang->language = $subdomain[1]; } $flolang->load("global"); $db = MYSQL_CONNECT($cfg['dbhost'], $cfg['dbuser'], $cfg['dbpasswd']) or die("No Database connection"); MYSQL_SELECT_DB($cfg['dbname'], $db) or die("No Database connection"); MYSQL_QUERY("SET NAMES 'utf8'"); require_once $cfg['root_abs'] . "/functions.php"; define('is_florensia', 1); require_once $cfg['root_abs'] . "/class_florensia.php"; $florensia = new class_florensia(); $color1 = 255; $color2 = 255; $color3 = 255; $columnname_x = 0; $columnall_start = 10; $columnvalue_x = 300; $picturewidth = 310; $fontsize = 9; $steps = 12; if ($_REQUEST['small']) {
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Test ModRewrite</title> <meta http-equiv='Content-Type' content='text/html; charset=UTF-8'> </head> <body> <?php @MYSQL_CONNECT("localhost", "iggmp", "grumblfurz34"); @MYSQL_SELECT_DB("iggmp"); $res = mysql_query("SELECT * FROM lang_railway_summary"); echo mysql_num_rows($res); while ($entry = mysql_fetch_array($res)) { $text = utf8_encode($entry['content']); echo $entry['content'] . "<hr>" . $text . "<hr><hr>"; } ?> </body> </html>
$i++; } $queryitemtables = MYSQL_QUERY("SHOW TABLES FROM florensia LIKE 'server_questtext_%'"); while ($itemtables = MYSQL_FETCH_ARRAY($queryitemtables)) { $tablelist[$i][$itemtables[0]]['searchkey'] = "questlistid"; $tablelist[$i][$itemtables[0]]['ignore'] = "id"; $i++; } /* */ //NOT IMPLEMENTED: server_skilltrees, server_items_idtable, server_upgraderule, server_seal_option //missbrauch der cache-funktion -> einfacheres einschreiben und ggf. workarounds fuer keys mit nummern/sonderzeichen $sqldiff = new class_cache(); $sqldiff->load_cache("sqldiff"); $sqldiff->write_cache("timestamp", date("U")); $dbold = MYSQL_CONNECT($cfg['dbhost'], $cfg['dbuser'], $cfg['dbpasswd'], TRUE) or die("No Database connection"); MYSQL_SELECT_DB("{$oldtable}", $dbold) or die("No Database connection"); MYSQL_QUERY("SET NAMES 'utf8'", $dbold); foreach ($tablelist as $globalkey => $value) { foreach ($tablelist[$globalkey] as $table => $tablesettings) { $diffentries = 0; $newentries = 0; unset($allentries, $exceptkeys, $content); $allentries = array(); $querytabledata = MYSQL_QUERY("SELECT * FROM {$table} " . $tablelist[$globalkey][$table]['dbwhere'], $db); while ($tabledata = MYSQL_FETCH_ASSOC($querytabledata)) { $querytabledata_old = MYSQL_QUERY("SELECT * FROM {$table} WHERE " . $tablelist[$globalkey][$table]['searchkey'] . "='" . $tabledata[$tablelist[$globalkey][$table]['searchkey']] . "'", $dbold); if ($tabledata_old = MYSQL_FETCH_ASSOC($querytabledata_old)) { foreach (explode(",", $tablelist[$globalkey][$table]['ignore']) as $ignorekey) { unset($tabledata[$ignorekey], $tabledata_old[$ignorekey]); } $arraydiff = array_diff_assoc($tabledata, $tabledata_old);
$dbname = "iemu_ls"; if (isset($_POST['submit'])) { $login = $_POST['login']; $password = $_POST['password']; $email = $_POST['email']; if (strlen($login) <= 32) { if (empty($login)) { echo 'Fill login'; } elseif (empty($password)) { echo 'Fill password'; } elseif (empty($email)) { echo 'Fill E-mail'; } else { $password = md5($password); if ($msconn = mysql_connect($dbhost, $dbuser, $dbpassword)) { if (!MYSQL_SELECT_DB($dbname)) { exit('Select DB Error'); } $mdpass = md5($login) . $password; $query = "INSERT INTO accounts (id, login, password, email, email_status, access, hash) VALUES ('', '" . $login . "', '" . $mdpass . "', '" . $email . "', '0', '0', '')"; mysql_query($query); echo 'Account has been created.'; } } } } ?>
* Include HTML parsing functionality. * We depend on the presence of the XML_HTMLSax PEAR package for PHP ({@link http://pear.php.net/package/XML_HTMLSax}). * You can probably install this like this: * * pear install XML_HTMLSax * */ require_once 'XML/XML_HTMLSax.php'; /** * Include RSS feed creation functionality. * We depend on the presence of FeedCreator.class.php for PHP ({@link http://www.bitfolge.de/rsscreator-en.html}). */ require_once "feedcreator.class.php"; // Connect to the MySQL server MYSQL_CONNECT($db_host, $db_user, $db_pw); MYSQL_SELECT_DB($db) or die("Unable to select database"); //Select previously indexed URLs from the cache table, and put them into an array $oneurl $query = "select url from {$db_table}"; $result = MYSQL_QUERY($query); $howmanyrecords = MYSQL_NUM_ROWS($result); $currentrecord = 0; while ($currentrecord < $howmanyrecords) { $url = trim(MYSQL_RESULT($result, $currentrecord, "url")); $oneurl[$url] = 1; $currentrecord++; } date_default_timezone_set('America/Halifax'); /** * Handlers for HTML parsing. */ class MyHandler
<?php $hostname = "localhost"; $username = "******"; $password = "******"; $dbName = "DatabaseName"; MYSQL_CONNECT($hostname, $username, $password) or die("Unable to connect to database."); MYSQL_SELECT_DB("{$dbName}") or die("Unable to select database");
$thispayment_amount_3 = "480.00"; $thispayment_amount_4 = "720.00"; $thispayment_currency = "USD"; // Validate transaction details against subscription request if ($txn_type == $thistxn_type && $payment_status == $thispayment_status && ($payment_amount == $thispayment_amount_1 && $item_name == $thisitem_name_1 || $payment_amount == $thispayment_amount_2 && $item_name == $thisitem_name_2 || $payment_amount == $thispayment_amount_3 && $item_name == $thisitem_name_3 || $payment_amount == $thispayment_amount_4 && $item_name == $thisitem_name_4) && $payment_currency == $thispayment_currency && $receiver_email == $thisreceiver_email) { // Pass if ($debug) { $debugString .= "\n 1.0 transaction details validated"; } // Connect to Subscriptions database $dbMainHost = "db147b.pair.com"; $dbMainUser = "******"; $dbMainPass = "******"; $dbMainDbse = "reinfurt_servinglibrarysubscriptions"; $dbConnect = MYSQL_CONNECT($dbMainHost, $dbMainUser, $dbMainPass); MYSQL_SELECT_DB($dbMainDbse, $dbConnect); // Check that txn_id has not been previously processed // if duplicate, then exit() $sql = "SELECT id, notes FROM objects WHERE notes={$txn_id}"; $result = MYSQL_QUERY($sql); if ($result) { if ($debug) { $debugString .= "\n 1.1 txn_id {$txn_id} already exists -- exiting"; } if ($debug) { mail($IPNemail, 'debug write', $debugString, $IPNemail); } exit("This txn_id already exists"); } // Pre-process variables $payment_date = $payment_date ? date("Y-m-d H:i:s", strtotime($payment_date)) : NULL;
<?php //var_dump($_GET); if (!isset($_GET['startp'])) { $_GET['startp'] = ""; $_GET['startp'] = 0; } if (!isset($_GET['lpp'])) { $_GET['lpp'] = 50; } $lpp = 50; if (!isset($_GET['userlog'])) { $_GET['userlog'] = ""; } include 'config.inc.php'; MYSQL_CONNECT("{$sql_server}", "{$sql_user}", "{$sql_pw}"); MYSQL_SELECT_DB("{$sql_db}"); $sql = ""; if (!empty($_GET['userlog'])) { $sql = "SELECT * \n\tFROM ftp_transfer \n\tWHERE username = '******'userlog'] . "' \n\tORDER BY lokale_zeit DESC limit " . $_GET['startp'] . ",{$lpp}"; } else { $sql = "SELECT * \n\tFROM ftp_transfer \n\tORDER BY lokale_zeit DESC limit " . $_GET['startp'] . ",{$lpp}"; } $result = MYSQL_QUERY($sql); $line = 0; while ($row = mysql_fetch_array($result)) { if ($line == 0) { echo "<TR class=\"blau\">\n"; } else { echo "<TR>\n"; } //$row[1] = preg_replace("/", "/ ", $row[1]);
require 'include/picmgmt.inc.php'; pageheader($lang_util_php['title']); if (!GALLERY_ADMIN_MODE) { die('Access denied'); } global $albumtbl, $picturetbl, $categorytbl, $usertbl, $lang_util_php; $albumtbl = $CONFIG['TABLE_PREFIX'] . 'albums'; $picturetbl = $CONFIG['TABLE_PREFIX'] . 'pictures'; $categorytbl = $CONFIG['TABLE_PREFIX'] . 'categories'; $usertbl = $CONFIG['TABLE_PREFIX'] . 'users'; // initialize vars $startpic = ''; $action = ""; $action = $_POST['action']; MYSQL_CONNECT($CONFIG['dbserver'], $CONFIG['dbuser'], $CONFIG['dbpass']) or die("can't connect to mysql server"); MYSQL_SELECT_DB($CONFIG['dbname']); function my_flush() { print str_repeat(" ", 4096); // force a flush } function filenametotitle($delete) { $albumid = $_POST['albumid']; $parsemode = $_POST['parsemode']; global $picturetbl, $lang_util_php; $query = "SELECT * FROM {$picturetbl} WHERE aid = '{$albumid}'"; $result = MYSQL_QUERY($query); $num = mysql_numrows($result); $i = 0; while ($i < $num) {
<head> <?php include 'inc/favicon.inc.php'; ?> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" /> <title>Unbenanntes Dokument</title> <?php $server = "localhost"; $user = "******"; $passwort = "EWbrVxjt"; $datenbank = "db854004"; MYSQL_CONNECT($server, $user, $passwort) or die("Fehler - Datenbankserver nicht erreichbar"); #Verbindung zum Datenbankserver herstellen MYSQL_SELECT_DB($datenbank) or die("Fehler - Datenbank nicht vorhanden"); #Verbindung zur Datenbank herstellen $daten = mysql_query("Select * from termine"); #Auswahl - Abfrage (Select) auf die Tabelle Termine (wichtig: Tabelle ist nicht Datenbank) ?> </head> <body> <?php while ($termine = mysql_fetch_array($daten)) { # Schleifenbeginn, Ausgabe der Datensätze am Bildschirm echo $termine[1]; } ?>
<?php $db_server = "localhost"; $db_name = "bs"; $db_user = "******"; $db_passwort = "bspw"; // when change this, then need to edit schema.sql define("DB_PREFIX", "bs_"); $db = @MYSQL_CONNECT($db_server, $db_user, $db_passwort) or die("Konnte keine Verbindung zur Datenbank herstellen"); $db_select = @MYSQL_SELECT_DB($db_name);
//$DB_TBLName, $DB_DBName, may also be commented out & passed to the browser //as parameters in a query string, so that this code may be easily reused for //any MySQL table or any MySQL database on your server //DEFINE SQL QUERY: //edit this to suit your needs /* Leave the connection info below as it is: just edit the above. (Editing of code past this point recommended only for advanced users.) */ //create MySQL connection $Connect = @MYSQL_CONNECT($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect to MySQL:<br>" . MYSQL_ERROR() . "<br>" . MYSQL_ERRNO()); //select database $Db = @MYSQL_SELECT_DB($DB_DBName, $Connect) or die("Couldn't select database:<br>" . MYSQL_ERROR() . "<br>" . MYSQL_ERRNO()); //execute query $result = @MYSQL_QUERY($sql, $Connect) or die("Couldn't execute query:<br>" . MYSQL_ERROR() . "<br>" . MYSQL_ERRNO()); //if this parameter is included ($w=1), file returned will be in word format ('.doc') //if parameter is not included, file returned will be in excel format ('.xls') if (isset($w) && $w == 1) { $file_type = "msword"; $file_ending = "doc"; } else { $file_type = "vnd.ms-excel"; $file_ending = "xls"; } //header info for browser: determines file type ('.doc' or '.xls') HEADER("Content-Type: application/{$file_type}"); HEADER("Content-Disposition: attachment; filename=database_dump.{$file_ending}"); HEADER("Pragma: no-cache");