/home/techb158/immovalet.ca/report/includes
Edit: /home/techb158/immovalet.ca/report/includes/db_connect.php (7824B)
set_charset("utf8") )
{
printf("Error loading character set utf8: %s\n", $mysqli->error);
}
if ($mysqli->connect_error) {
header("Location: ../error.php?err=Unable to connect to DB");
exit();
}else
{
//66.96.147.96
////96.21.93.17
//session_start();
//$dbhost = "108.163.138.165"; // this will ususally be 'localhost', but can sometimes differ
//$dbname = "TRANSIT"; // the name of the database that you are going to use for this project
//$dbuser = "SIGM"; // the username that you created, or were given, to access your database
//$dbpass = ""; // the password that you created, or were given, to access your database
//$port = "5493"; // the password that you created, or were given, to access your database
// $mysqlis = new mysqli("host='108.163.138.164' port='5493' dbname='TRANSIT' dbuser='SIGM'");
// //$mysqlis = new mysqli(HOSTNAME, USERNAME, DATABASENAME, USERPASSWORD, PORT);
//$mysqlis = pg_connect(HOSTNAME, PORT, USERNAME, DATABASENAME, USERPASSWORD);
///////////////////////////////////////////////////////////////
// $mysqlis = pg_pconnect("host=108.163.138.164 port=5493 dbname=TRANSIT user=SIGM") or die('DB Connection failed');
///////////////////////////////////////////////////////////////
//$db = pg_pconnect("host=108.163.138.164 port=5493 dbname=TRANSIT user=SIGM password=") or die('connection failed');
///////////////////////////////////////////////////////////////
//$mysqlis = pg_pconnect($dbhost, $port, $dbuser, $dbpass) or die("MySQL Error: " . mysql_error());
//mysql_select_db($dbname) or die("MySQL Error: " . mysql_error());
///////////////////////////////////////////////////////////////////////////////////////
//$mysqlis = new pgsql(HOSTNAME, USERNAME, DATABASENAME, true);
//$mysqlis->set_charset("utf8");
//if ($mysqlis->connect_error) {
// header("Location: ../error.php?err=Unable to connect error");
// exit();
//}
////////////////////////////////////////////////////////////////////////////////////////
//$db = pg_connect("host=108.163.138.164 port=5493 dbname=TRANSIT user=Bala password=bala123") or die ("unable to connect");
//$sql = 'CREATE TABLE "widget" ("widgetid" SERIAL PRIMARY KEY NOT NULL, "name" varchar(255) NOT NULL, "description" text)';
//pg_query($db, $sql) or die ("unable to create table");
//echo 'success';
////////////////////////////////////////////////////////////////////////////////////////
//try {
// //$conn = @pg_connect("host=108.163.138.164 dbname=TRANSIT user=Bala".
// // "password=bala123 sslmode=disable");
// $conn=pg_connect("host=108.163.138.165 port=5493 dbname=TRANSIT user=SIGM password=") or die ("unable to connect");
// echo 'success';
//} Catch (Exception $e) {
// Echo $e->getMessage();
//}
////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////
//$appName = $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
//if (!$connection = pg_connect("host=108.163.138.165 port=5493 dbname=demodist user=Bala password=bala123 options='--application_name=$appName'")){
//if (!$connection = pg_connect("host=108.163.138.165 port=5493 dbname=TRANSIT user=Bala password=bala123 options='--client_encoding=SQL_ASCII'")){
//if (!$connection = pg_connect("host=108.163.138.165 port=5493 dbname=TRANSIT user=Bala password=bala123 options='--client_encoding=UNICODE'")){
//if (!$connection = pg_connect("host=108.163.138.165 port=5493 dbname=TRANSIT user=Bala password=bala123 options='--client_encoding=UTF-8'")){
//if (!$connection = pg_connect("host=108.163.138.165 port=5493 dbname=TRANSIT user=Bala password=bala123 options='--client_encoding=WIN1252'")){
//if (!$connection = pg_connect("host=108.163.138.165 port=5493 dbname=demodist user=Bala password=bala123 options='--client_encoding=UTF-8'")){
//if (!$connection = pg_connect("host=108.163.138.165 port=5493 dbname=demodist user=Bala password=bala123")){
// $error = error_get_last();
// die ("Connection failed. Error was: ". $error['message']. "\n");
// }
// else {
//$encoding = pg_client_encoding($connection);
//die ("Client encoding is: ". $encoding. "\n");
// echo "Connection succesful.\n";
//pg_set_client_encoding($connection, 'UNICODE');
}
//pg_set_client_encoding($connection, 'UNICODE');
//pg_set_client_encoding($connection, 'utf8');
//$connection = new pg_connect(HOSTNAME, USERNAME, USERPASSWORD, DATABASENAME);
//$connection->set_charset("utf8");
//if ($connection->connect_error) {
// header("Location: ../error.php?err=Unable to connect to DB");
// exit();
//}
////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////
//$options = "host='108.163.138.164' port='5493' user='Bala' password='bala123' dbname='TRANSIT'";
//$conn = pg_connect($options);
//if (!$conn) {
// die('Could not connect');
//}else{
//echo 'Connected successfully';
//}
////////////////////////////////////////////////////////////////////////////////////////
//$conn=pg_connect("host=108.163.138.164 port=5493 dbname=TRANSIT user=Bala password=bala123");
//if (!$conn) {
// die('Could not connect');
//}else{
//echo 'Connected successfully';
//}
////////////////////////////////////////////////////////////////////////////////////////
// we connect to example.com and port
//$link = pg_connect("host=108.163.138.165 port=5493 dbname=TRANSIT user=Bala password=bala123 options='--client_encoding=SQL_ASCII'");
//if (!$link) {
// die('Could not connect');
//}
//echo 'Connected successfully';
////mysql_close($link);
////////////////////////////////////////////////////////////////////////////////////////
//$dbconn2 = pg_pconnect("host=108.163.138.164 port=5493 dbname=TRANSIT user=SIGM");
// $db_connection = pg_connect("host=108.163.138.164 port=5493 dbname=TRANSIT user=SIGM password=");
///////////////////////////////////////////////////////////////////////////////////////
// ////we connect to localhost at port 3307
//$username = "SIGM";
//$password = "";
//$host = "108.163.138.164";
//$database = "TRANSIT";
//$port = "5493";
//$link = pg_connect("$host, $username, $password");
//if (!$link) {
// die('Could not connect: ' . mysql_error());
//}
//echo 'Connected successfully';
//mysql_close($link);
////////////////////////////////////////////////////////////////////
//$username = "SIGM";
//$password = "";
//$host = "108.163.138.165";
//$database = "TRANSIT";
//$port = "5493";
//
//$conn = mysql_connect($host.':'.$port, $username, $password);
//$db=mysql_select_db($database,$conn);
/////////////////////////////////////////////////////////////////////////
// //// Begin Vault (this is in a vault, not actually hard-coded)
//$host="108.163.138.165";
//$dbuser="Bala";
//$dbpass="bala123";
//$dbname="TRANSIT";
//$port="5493";
////// End Vault
////
//try {
// $dbh = new PDO("pgsql:host=$host;dbname=$dbname", $dbuser, $dbpass);
// //$dbh = new PDO("mysql:host=$host;port=$port;dbname=$dbname;charset=utf8", $username);
// $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// echo "I am connected.
";
//
// // ... continue with your code
//
// // PDO closes connection at end of script
//} catch (PDOException $e) {
// echo 'PDO Exception: ' . $e->getMessage();
// exit();
//}
//}