public function connect()
{
if (!self::$connection) {
self::$connection = mysql_connect($this->server, $this->username, $this->password);
}
mysql_select_db($this->db);
}
public static function getInstance()
{
//get an instance of the connection
if (Connection::$connection === NULL) {
//if the connection is null
// connect to the database local using the credentials
$host = "localhost";
$database = "CA1-TourBusMassacre";
$username = "******";
$password = "******";
// connection for college database
// $host = "daneel";
// $database = "N00143233playground";
// $username = "******";
// $password = "******";
$dsn = "mysql:host=" . $host . ";dbname=" . $database;
//url for connection
Connection::$connection = new PDO($dsn, $username, $password);
//Connection is made with the variables above
if (!Connection::$connection) {
//if there is no connection
die("Could not connect to database");
//die
}
}
return Connection::$connection;
//return the connection from the credentials above
}
public static function getInstance()
{
if (empty(self::$connection)) {
self::$connection = new self();
return self::$connection;
}
}
public static function get()
{
if (self::$connection == false) {
self::$connection = new PDO('mysql:host=' . self::$host . ';dbname=' . self::$dbname, self::$user, self::$pwd, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\'', PDO::ATTR_CASE => 'SET lc_time_names = \'fr_FR\''));
return self::$connection;
} else {
return self::$connection;
}
}
protected static function open_connection()
{
//initialize connection
self::$connection = new mysqli(self::$server, self::$user, self::$password, self::$database);
//error in connection
if (self::$connection->connect_errno) {
echo 'Cannot connect to MySQL server : ' . self::$connection->connect_error;
die;
}
}
public function connect()
{
if (!isset(self::$connection)) {
//Filen .ini innehåller databasuppkopplingsinfo som databasnamn, lösenord m.m.
$config = parse_ini_file('./config.ini');
//denna fil läggs utanför den mappar användare kan nå för att skydda databasinfo
self::$connection = new mysqli('localhost', $config['username'], $config['password'], $config['dbname']);
}
return self::$connection;
}
public static function create($host, $dbname, $user, $pass)
{
if (self::$connection == null) {
try {
self::$connection = new PDO("mysql:host={$host};dbname={$dbname}", $user, $pass);
} catch (PDOException $e) {
}
}
return self::$connection;
}
/**
* Connect to the database
*
* @return bool false on failure / mysqli MySQLi object instance on success
*/
public function connect()
{
if (!isset(self::$connection)) {
$config = parse_ini_file(__DIR__ . '/../resources/dbconfig.ini');
self::$connection = new mysqli($config['host'], $config['username'], $config['password'], $config['dbname']);
}
if (self::$connection === false) {
return false;
}
return self::$connection;
}
/**
* Get the connection to the database
*/
public static function get()
{
if (self::$connection == false) {
try {
self::$connection = new PDO('mysql:host=' . self::$host . ';dbname=' . self::$dbname, self::$user, self::$pwd, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\'', PDO::ATTR_CASE => 'SET lc_time_names = \'de_DE\'', PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION));
return self::$connection;
} catch (Exception $e) {
echo "erreur de connexion : " . $e->getMessage();
}
} else {
return self::$connection;
}
}
public function get()
{
$sql = $this->_select;
try {
$db = parent::connection();
$stmt = $db->query($sql);
$result = $stmt->fetchAll(PDO::FETCH_OBJ);
$db = null;
echo json_encode($result);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
public function getUser($id)
{
$sql = $this->_select . " WHERE id = :id";
try {
$db = parent::connection();
$stmt = $db->prepare($sql);
$stmt->bindParam("id", $id);
$stmt->execute();
$result = $stmt->fetchObject();
$db = null;
echo json_encode($result);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
public static function getInstance()
{
if (Connection::$connection === NULL) {
// connect to the database
$host = "localhost";
$database = "photo_gallery";
$username = "******";
$password = "";
$dsn = "mysql:host=" . $host . ";dbname=" . $database;
Connection::$connection = new PDO($dsn, $username, $password);
if (!Connection::$connection) {
die("Could not connect to database");
}
}
return Connection::$connection;
}
public function get()
{
$sql = $this->_select . " LIMIT 1";
try {
$db = parent::connection();
$stmt = $db->prepare($sql);
$stmt->execute();
$result = $stmt->fetchObject();
$db = null;
$result->info = preg_replace("'\r?\n'", '', $result->info);
$result->info = stripslashes($result->info);
$result->info = stripcslashes($result->info);
echo json_encode($result);
} catch (PDOException $e) {
echo '{"error":{"text":' . $e->getMessage() . '}}';
}
}
public static function getInstance()
{
if (Connection::$connection === NULL) {
// connect to the database
$host = "localhost";
//logging into the database
$db = "highland_books_database";
$user = "******";
$password = "******";
$dsn = "mysql:host=" . $host . ";dbname=" . $db;
Connection::$connection = new PDO($dsn, $user, $password);
if (!Connection::$connection) {
die("Could not connect to database");
}
}
return Connection::$connection;
}
function descargaApk($array)
{
try {
if ($array != NULL) {
$con = new Connection();
$mysql = $con->connection();
$this->sql = "SELECT\n\t\t\t\taplicativo.ubicacion\n\t\t\t\tFROM usuarios\n\t\t\t\tINNER JOIN permisos on permisos.idUsuario = usuarios.id\n\t\t\t\tINNER JOIN aplicativo on aplicativo.id = permisos.idAplicativo\n\t\t\t\twhere\n\t\t\t\tusuarios.id = " . $array['usu'] . "\n\t\t\t\tand\n\t\t\t\taplicativo.id = " . $array['app'] . "\n\t\t\t\tand permisos.estado = 0";
$resultado = mysql_query($this->sql);
$fila = mysql_fetch_array($resultado);
$con->disconnect($mysql);
} else {
$fila = $array;
}
} catch (Exception $e) {
echo 'Excepción capturada: ', $e->getMessage(), "\n";
}
return $fila;
}
public static function getInstance()
{
/* Creates new connection if connection doesn't already exist */
if (Connection::$connection === NULL) {
$host = 'localhost';
//specify login details to phpmyadmin page
$database = 'Yoink2';
$username = '******';
$password = '';
$dsn = 'mysql:dbname=' . $database . ";host=" . $host;
Connection::$connection = new PDO($dsn, $username, $password);
if (!Connection::$connection) {
//tests the connection
die("Could not connect to database!");
}
}
return Connection::$connection;
}
public static function getInstance()
{
if (Connection::$connection === NULL) {
// connect to the database local
$host = "localhost";
$database = "CA1-TourBusMassacre";
$username = "******";
$password = "******";
// connection for college database
// $host = "daneel";
// $database = "N00143233playground";
// $username = "******";
// $password = "******";
$dsn = "mysql:host=" . $host . ";dbname=" . $database;
Connection::$connection = new PDO($dsn, $username, $password);
if (!Connection::$connection) {
die("Could not connect to database");
}
}
return Connection::$connection;
}
private function Connect()
{
if (!self::$connection) {
self::$connection = mysql_connect(Settings::Get('DB_SERVER'), Settings::Get('DB_USERNAME'), Settings::Get('DB_PASSWORD')) or die('Unable to connect: ' . mysql_error());
mysql_select_db(Settings::Get('DB_DATABASE')) or die('Unable to select: ' . mysql_error());
}
}
