Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Pleae help me Where am i wrongly insert database detail for connectng

Newbie Spellweaver
Joined
Dec 30, 2012
Messages
16
Reaction score
0
<?php
$cleardb_url = parse_url(getenv("CLEARDB_DATABASE_URL"));
$cleardb_server = $cleardb_url["host"];
$cleardb_username = $cleardb_url["user"];
$cleardb_password = $cleardb_url["pass"];
$cleardb_db = substr($cleardb_url["path"], 1);
function sanitize_output($buffer)
{
$search = array(
'/\>[^\S ]+/s', // strip whitespaces after tags, except space
'/[^\S ]+\</s', // strip whitespaces before tags, except space
'/(\s)+/s' // shorten multiple whitespace sequences
);
$replace = array(
'>',
'<',
'\\1'
);

$buffer = preg_replace($search, $replace, $buffer);
return $buffer;
}
try {
ini_set("display_errors", "0");
//ob_start("sanitize_output");
ob_start();
$db = "ASD";
$db2 = "HSDB";
$user = "sa";
$password = "manoj";
$con = odbc_connect($db, $user, $password);
$con2 = odbc_connect($db2, $user, $password);
// Create connection
//$con = mysqli_connect($cleardb_server, $cleardb_username, $cleardb_password,$cleardb_db);
//$con2 = mysqli_connect($cleardb_server, $cleardb_username, $cleardb_password,$cleardb_db);

// Check connection
if (!$con) {
echo("Connection failed: " . mysqli_connect_error());
}
// Check connection
if (!$con2) {
echo("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
} catch (Throwable $ex) {
echo ("Sorry Not able to connect to odbc database!!");
}
//putenv("Asia/Kolkata");

session_start();
session_regenerate_id(true);

try {

define("MN1", $cleardb_server); //DNS HOST
define("ASD", $cleardb_db); //Database
define("sa", $cleardb_username); //username of the database
define("manoj", $cleardb_password); //password of the database
require 'class.MySqlDatabase.php';
$mysql = new MySqlDatabase();
$date = date('Y-m-d H:i:s');
/*require 'class.session.php';

$session = new session();
// Set to true if using https
$session->start_session('_s', false);

*/

/*
*
* ---------------------------------------------------------------------------------
* MYSQL DATABASE CONNECTION SETTINGS
* ---------------------------------------------------------------------------------
*/

define("MN1", $cleardb_server); //DNS HOST
define("ASD", $cleardb_db); //Database
define("sa", $cleardb_username); //username of the database
define("manoj", $cleardb_password); //password of the database
$MysqlConnect = new PDO("mysql:host=MN1" . MYSQL_DB_HOST . ";dbname=ASD" . MYSQL_DB_DBNAME, MYSQL_DB_USERNAME, MYSQL_DB_PASSWORD);
$MysqlConnect->setAttribute(PDO::ATTR_TIMEOUT, '1');
$MysqlConnect->setAttribute(PDO::ATTR_PERSISTENT, 'false');
$MysqlConnect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $ex) {
echo ("Sorry Not able to connect to mysql database!!");
}


/*
* ---------------------------------------------------------------------------------
* ODBC DATABASE CONNECTION SETTINGS
* ---------------------------------------------------------------------------------
*/
try {
define("localhost", "odbc:webasd"); //DNS HOST
define("sa", "sa"); //username of the database
define("manoj", "manoj"); //password of the database
define("localhost", $cleardb_server); //DNS HOST
define("webasd", $cleardb_db); //Database
define("sa", $cleardb_username); //username of the database
define("manoj", $cleardb_password); //password of the database
$OdbcConnect = new PDO("mysql:host=MN1" . MYSQL_DB_HOST1 . ";dbname=webasd" . MYSQL_DB_DBNAME1, MYSQL_DB_USERNAME1, MYSQL_DB_PASSWORD1);
$OdbcConnect->setAttribute(PDO::ATTR_TIMEOUT, '1');
$OdbcConnect->setAttribute(PDO::ATTR_PERSISTENT, 'false');
$OdbcConnect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $ex) {
echo ("Sorry Not able to connect to odbc database!!" . $ex->getMessage());
}

require 'report_pk_function.php';
 
Back
Top