/** * @desc returns the currently opened <code>DBConnection</code> instance or if none, * creates a new one * @return DBConnection the currently opened <code>DBConnection</code> instance */ public static function get_db_connection() { if (self::$db_connection === null) { $data = self::load_config(); self::init_factory($data['dbms']); self::$db_connection = self::new_db_connection(); self::$db_connection->connect($data); } return self::$db_connection; }
/** * Connect * * @param bool reconnect default FALSE * @return bool success * @throws rdbms.SQLConnectException */ public function connect($reconnect = FALSE) { if (is_resource($this->handle)) { return TRUE; } // Already connected if (!$reconnect && FALSE === $this->handle) { return FALSE; } // Previously failed connecting $this->_obs && $this->notifyObservers(new DBEvent(DBEvent::CONNECT, $reconnect)); if ($this->flags & DB_PERSISTENT) { $this->handle = mssql_pconnect($this->dsn->getHost(), $this->dsn->getUser(), $this->dsn->getPassword()); } else { $this->handle = mssql_connect($this->dsn->getHost(), $this->dsn->getUser(), $this->dsn->getPassword()); } if (!is_resource($this->handle)) { $e = new SQLConnectException(trim(mssql_get_last_message()), $this->dsn); xp::gc(__FILE__); throw $e; } xp::gc(__FILE__); $this->_obs && $this->notifyObservers(new DBEvent(DBEvent::CONNECTED, $reconnect)); return parent::connect(); }
static function fetchAll() { DBConnection::connect(); $result = DBConnection::select('SELECT * FROM post'); $posts = []; if ($result) { foreach ($result as $post) { array_push($posts, new Post($post->id, $post->title, false)); } } return $posts; }
static function fetchAll() { DBConnection::connect(); $result = DBConnection::select('SELECT * FROM user'); $users = []; if ($result) { foreach ($result as $user) { array_push($users, new User($user->id, $user->pseudo, false)); } } return $users; }
public static function getEvents() { $db = new DBConnection(); $link = $db->connect(); if ($link != null) { $query = "SELECT event_name,start_date,end_date,start_time FROM event"; $result = $link->query($query); $result_array = array(); $index = 0; while ($row = mysqli_fetch_assoc($result)) { $result_array[$index] = $row; $index = $index + 1; } $db->closeConnection(); return $result_array; } $db->closeConnection(); return null; }
/** * Connect * * @param bool reconnect default FALSE * @return bool success * @throws rdbms.SQLConnectException */ public function connect($reconnect = FALSE) { if ($this->handle->connected) { return TRUE; } // Already connected if (!$reconnect && NULL === $this->handle->connected) { return FALSE; } // Previously failed connecting try { $this->handle->connect($this->dsn->getUser(), $this->dsn->getPassword()); $this->_obs && $this->notifyObservers(new DBEvent(__FUNCTION__, $reconnect)); } catch (IOException $e) { $this->handle->connected = NULL; $this->_obs && $this->notifyObservers(new DBEvent(__FUNCTION__, $reconnect)); throw new SQLConnectException($e->getMessage(), $this->dsn); } return parent::connect(); }
function InitPage($login) { $page = $login; $lastPage = GetSessionVar('s_pageName'); $User = GetSessionVar('User'); if (empty($GLOBALS['page'])) { $GLOBALS['page'] = ''; } if (isset($_SERVER['REQUEST_URI']) && strpos($_SERVER['REQUEST_URI'], "login.php") == FALSE && strpos($_SERVER['REQUEST_URI'], "callback") == FALSE) { SetSessionVar('s_pageLast', $_SERVER['REQUEST_URI']); } $dbc = new DBConnection(); global $dbh; $dbh = $dbc->connect(); if ($login == "login" && !$User) { # Login required, but the User object isn't there. if (isset($_COOKIE[COOKIE_REMEMBER])) { # Try to fetch username from session require_once dirname(__FILE__) . "/../classes/system/session.class.php"; $Session = new Session(); if (!$Session->validate()) { exitTo("login.php"); } else { $User = new User(); $User->loadFromID($Session->_userid); SetSessionVar("User", $User); } } else { exitTo("login.php"); } } $GLOBALS['g_PHPSELF'] = $GLOBALS['page']; $GLOBALS['g_PAGE'] = $page; if (isset($_SERVER['HTTP_HOST'])) { $GLOBALS['g_SITEURL'] = $_SERVER['HTTP_HOST']; $GLOBALS['g_SITENAME'] = substr($GLOBALS['g_SITEURL'], 0, strlen($GLOBALS['g_SITEURL']) - 4); $GLOBALS['g_TITLE'] = $GLOBALS['g_SITENAME']; } $GLOBALS['g_ERRSTRS'] = array("", "", "", "", "", "", "", "", "", "", ""); $GLOBALS['DEBUG'] = ""; }
<?php require_once "config/DBConnection.php"; $db = new DBConnection(); $conn = $db->connect(); $userId = $_GET['user_id']; $pass = $_GET['password']; //check connection first before doing query $sql = "SELECT * FROM users WHERE user_id = '{$userId}' AND password = '******'"; $result = $conn->query($sql); if ($result->num_rows > 0) { $user = $result->fetch_object(); $response = array('status' => 'ok', 'message' => 'Successfully Login!', 'user' => $user); echo json_encode($response); die; } echo json_encode(array('status' => 'error', 'message' => 'Login Failed!')); $conn->close();
<?php /******************************************************************************* * Copyright (c) 2007-2009 Intalio, Inc. * All rights reserved. This program and the accompanying materials * are made available under the terms of the Eclipse Public License v1.0 * which accompanies this distribution, and is available at * http://www.eclipse.org/legal/epl-v10.html * * Contributors: * Antoine Toulme, Intalio Inc. *******************************************************************************/ // this file should be included in the spec files. // it will open a connection to a test database. error_reporting(E_ALL); ini_set('display_errors', '1'); require_once dirname(__FILE__) . "/../classes/system/dbconnection.class.php"; DBConnection::connect(dirname(__FILE__) . '/test.ini');
<?php include 'src/DBConnection.php'; include 'src/Login.php'; $login = new Login(); if ($login->is_session()) { $login->redirect(); } if (isset($_POST['submit'])) { if (!empty($_POST['username']) && !empty($_POST['password'])) { $dbObj = new DBConnection(); $db = $dbObj->connect(); $username = $_POST['username']; $password = $_POST['password']; $login->setDB($db); $login->setUsername($username); $login->setPassword($password); if ($login->verification()) { if ($login->createSession()) { $login->redirect(); } } else { echo 'username / password is incorrect'; } } }
$N = $sent[0]; $K = $sent[1]; $command = '/usr/bin/python /var/www/html/toyapp/toyapp-python/toyapp.py encrypt ' . $file_name . ' ' . $N . ' ' . $K; echo $command; //echo '<br />'.$command; //echo '<br />'; #$result = #exec($command);# $result = json_decode(exec($command, $status), true); $size = sizeof($result); //print_r($result); $i = 0; require_once '../includes/shareholdersapi.inc'; $shareholders = get_shareholders($sent[2]); //print_r($shareholders); require_once '../includes/DB_Abstraction.inc'; $db_con = new DBConnection(); $db_con->connect(); foreach ($result as $pair) { $uid = $shareholders[$i]['uid']; $db_con->insert('secrets', 'fid,uid,secret', "{$sent['2']},'{$uid}','[{$pair['0']},{$pair['1']}]'"); $i++; echo "<br />Secret {$i}: <input type='text' readonly='readonly' value='[{$pair['0']},{$pair['1']}]'/>"; } //print_r($result);//. ' <br />'; $db_con->update('file', "url='\\/toyapp\\/repo\\/{$fn}.enc',status=2", "fid={$sent['2']}"); $db_con->disconnect(); //unlink($file_name); } ?> </body> </html>
include 'MembersCtrl.php'; include 'src/Appointment.php'; if (isset($_POST['submit'])) { $data = array('name' => $_POST['name'], 'address' => $_POST['address'], 'age' => $_POST['age'], 'gender' => $_POST['gender'], 'hospital' => $_POST['hospital'], 'speciality' => $_POST['speciality'], 'appointment' => $_POST['appointment'], 'date' => $_POST['date'], 'time' => $_POST['time'], 'phone' => $_POST['phone'], 'doctor' => $_POST['doctor'], 'age' => $_POST['age'], 'gender' => $_POST['gender'], 'address' => $_POST['address']); $pass = true; foreach ($data as $var => $value) { if (empty($value)) { echo $var . " is empty!"; $pass = false; break; } } if ($pass) { $dbo = new DBConnection(); $db = $dbo->connect(); $appointment = new Appointment(); $appointment->setDB($db); $appointment->setPatientUser($data['name']); $appointment->setDoctor($data['doctor']); $appointment->setDate($data['date']); $appointment->setTime($data['time']); $appointment->setSpeciality($data['speciality']); $appointment->setAppointmentType($data['appointment']); $appointment->setHospital($data['hospital']); $appointment->setMobile($data['phone']); $appointment->setAge($data['age']); $appointment->setGender($data['gender']); $appointment->setCurrentUser($members->getSessionUser()); $appointment->setCurrentAddress($data['address']); if ($appointment->verification()) {
/** * Connect * * @param bool reconnect default FALSE * @return bool success * @throws rdbms.SQLConnectException */ public function connect($reconnect = FALSE) { if ($this->handle->connected) { return TRUE; } // Already connected if (!$reconnect && NULL === $this->handle->connected) { return FALSE; } // Previously failed connecting $this->_obs && $this->notifyObservers(new DBEvent(DBEvent::CONNECT, $reconnect)); try { $this->handle->connect($this->dsn->getUser(), $this->dsn->getPassword()); $this->_obs && $this->notifyObservers(new DBEvent(DBEvent::CONNECTED, $reconnect)); } catch (IOException $e) { $this->handle->connected = NULL; $this->_obs && $this->notifyObservers(new DBEvent(DBEvent::CONNECTED, $reconnect)); throw new SQLConnectException($e->getMessage(), $this->dsn); } try { $this->handle->exec('set names LATIN1'); // Figure out sql_mode and update formatter's escaperules accordingly // - See: http://bugs.mysql.com/bug.php?id=10214 // - Possible values: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html // "modes is a list of different modes separated by comma (,) characters." $modes = array_flip(explode(',', this(this($this->handle->consume($this->handle->query("show variables like 'sql_mode'")), 0), 1))); } catch (IOException $e) { // Ignore } // NO_BACKSLASH_ESCAPES: Disable the use of the backslash character // (\) as an escape character within strings. With this mode enabled, // backslash becomes any ordinary character like any other. // (Implemented in MySQL 5.0.1) isset($modes['NO_BACKSLASH_ESCAPES']) && $this->formatter->dialect->setEscapeRules(array('"' => '""')); return parent::connect(); }
/** * Connect * * @param bool reconnect default FALSE * @return bool success * @throws rdbms.SQLConnectException */ public function connect($reconnect = FALSE) { if (is_resource($this->handle)) { return TRUE; } // Already connected if (!$reconnect && FALSE === $this->handle) { return FALSE; } // Previously failed connecting // Connect via local sockets if "." is passed. This will not work on // Windows with the mysqlnd extension (see PHP bug #48082: "mysql_connect // does not work with named pipes"). For mysqlnd, we default to mysqlx // anyways, so this works transparently. $host = $this->dsn->getHost(); $ini = NULL; if ('.' === $host) { $sock = $this->dsn->getProperty('socket', NULL); if (0 === strncasecmp(PHP_OS, 'Win', 3)) { $connect = '.'; if (NULL !== $sock) { $ini = ini_set('mysql.default_socket'); ini_set('mysql.default_socket', substr($sock, 9)); // 9 = strlen("\\\\.\\pipe\\") } } else { $connect = NULL === $sock ? 'localhost' : ':' . $sock; } } else { if ('localhost' === $host) { $connect = '127.0.0.1:' . $this->dsn->getPort(3306); // Force TCP/IP } else { $connect = $host . ':' . $this->dsn->getPort(3306); } } $this->_obs && $this->notifyObservers(new DBEvent(DBEvent::CONNECT, $reconnect)); if ($this->flags & DB_PERSISTENT) { $this->handle = mysql_pconnect($connect, $this->dsn->getUser(), $this->dsn->getPassword()); } else { $this->handle = mysql_connect($connect, $this->dsn->getUser(), $this->dsn->getPassword(), $this->flags & DB_NEWLINK); } $this->_obs && $this->notifyObservers(new DBEvent(DBEvent::CONNECTED, $reconnect)); $ini && ini_set('mysql.default_socket', $ini); if (!is_resource($this->handle)) { $e = new SQLConnectException('#' . mysql_errno() . ': ' . mysql_error(), $this->dsn); xp::gc(__FILE__); throw $e; } mysql_query('set names LATIN1', $this->handle); // Figure out sql_mode and update formatter's escaperules accordingly // - See: http://bugs.mysql.com/bug.php?id=10214 // - Possible values: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html // "modes is a list of different modes separated by comma (,) characters." $modes = array_flip(explode(',', current(mysql_fetch_row(mysql_query("show variables like 'sql_mode'", $this->handle))))); // NO_BACKSLASH_ESCAPES: Disable the use of the backslash character // (\) as an escape character within strings. With this mode enabled, // backslash becomes any ordinary character like any other. // (Implemented in MySQL 5.0.1) isset($modes['NO_BACKSLASH_ESCAPES']) && $this->formatter->dialect->setEscapeRules(array('"' => '""')); return parent::connect(); }
public static function getMemberDetail($id) { $db = new DBConnection(); $link = $db->connect(); if ($link != null) { $query = "SELECT concat(first_name,\" \",last_name) AS name , gender , email ,mobile FROM member WHERE id ='" . $id . "'"; $result = $link->query($query); $db->closeConnection(); return $result; } $db->closeConnection(); return null; }
require_once "classes/pages.class.php"; require_once "classes/blocks.class.php"; require_once "classes/controls.class.php"; require_once "classes/news.class.php"; require_once "classes/contacts.class.php"; require_once "classes/clients.class.php"; require_once "classes/services.class.php"; require_once "classes/portfolios.class.php"; require_once "classes/categories.class.php"; require_once "classes/phpmailer.class.php"; $conn = new DBConnection(); $mysql_hostname = DBVariables::$mysql_hostname; $mysql_username = DBVariables::$mysql_username; $mysql_password = DBVariables::$mysql_password; $mysql_database = DBVariables::$mysql_database; $conn->connect($mysql_hostname, $mysql_username, $mysql_password, $mysql_database); $conn->debug = true; /****************************************************************/ //Functions /****************************************************************/ require_once "functions/pages.fun.php"; require_once "functions/blocks.fun.php"; require_once "functions/news.fun.php"; require_once "functions/clients.fun.php"; require_once "functions/categories.fun.php"; require_once "functions/portfolios.fun.php"; require_once "functions/services.fun.php"; require_once "functions/contacts.fun.php"; /****************************************************************/ GetCurrentNodeInformation(); if ($config["news"] > 0) {
* * Contributors: * Antoine Toulme, Intalio Inc. bug 248845: Refactoring generate1.php into different files with a functional approach *******************************************************************************/ /* * Documentation: http://wiki.eclipse.org/Babel_/_Server_Tool_Specification#Outputs */ ini_set("memory_limit", "64M"); require dirname(__FILE__) . "/../system/backend_functions.php"; global $addon; $context = $addon->callHook('context'); $work_dir = $addon->callHook('babel_working'); require dirname(__FILE__) . "/../system/dbconnection.class.php"; require dirname(__FILE__) . "/../system/feature.class.php"; $dbc = new DBConnection(); $dbh = $dbc->connect(); $work_context_dir = $work_dir . $context . "_site/"; $tmp_dir = $work_context_dir . "tmp/"; $output_dir = $work_context_dir . "output/"; $sites_dir = $work_context_dir . "sites/"; exec("rm -rf {$work_context_dir}*"); exec("mkdir -p {$output_dir}"); exec("mkdir -p {$sites_dir}"); //iterate over all the release trains foreach (ReleaseTrain::all() as $train) { $features = array(); // create a dedicated folder for each of them exec("mkdir -p {$sites_dir}/{$train->id}"); // create the output folder for temporary artifacts $output_dir_for_train = "{$output_dir}/{$train->id}/"; // iterate over each language
if (is_session_active()) { //$shares = array($_POST['1'] , $_POST['2'], $_POST['3']); $shares = array(); if (!empty($_POST['1'])) { array_push($shares, $_POST['1']); } if (!empty($_POST['2'])) { array_push($shares, $_POST['2']); } if (!empty($_POST['3'])) { array_push($shares, $_POST['3']); } //var_dump($shares); $reconstructed_secret = reconstruct($shares); $db = new DBConnection(); $db->connect(); $user = get_user_info(); $secret = $db->query('secret', 'secret', "uid='{$user}'", null, null, null)[0]['secret']; $db->delete('secret', "uid='{$user}'"); $db->disconnect(); if ($secret == $reconstructed_secret) { echo "Secrets matching. Access granted."; } else { echo "{$secret} != {$reconstructed_secret}. Access denied"; } } else { echo "fail"; } } else { echo "fail"; }
function setDB() { $dbObj = new DBConnection(); $this->db = $dbObj->connect(); }
// exit('Failed to remove database'); } } // #2: install offiria database if ($canProceed && !$database->createDatabase($dbo, $db_name)) { $link = ''; $link .= '<p>'; $link .= 'This is a fresh install of Offiria, <b>' . $db_name . '</b> database will be removed (this action is not reversible)<br />'; $query = "?{$variables}&remove_database=true"; $link .= '<a href="' . $query . '">Confirm</a>'; $link .= '</p>'; $errorMessage = $link; $canProceed = false; } // update connection based on the new database created $dbo = DBConnection::connect($db_name, $db_host, $db_uname, $db_pw); if ($canProceed && !$database->populateDatabase($dbo, FRAMEWORK_SQL_FILEPATH)) { $canProceed = false; $errorMessage = 'Failed to install framework'; // exit('Failed to install framework'); } if ($canProceed && !$database->populateDatabase($dbo, OFFIRIA_SQL_FILEPATH)) { $canProceed = false; $errorMessage = 'Failed to install Offiria'; // exit('Failed to install Offiria'); } if ($canProceed && !$database->installPatches($dbo, PATCHES_SQL_FILEDIR)) { $canProceed = false; $errorMessage = 'Failed to update patches'; // exit('Failed to update patches'); }