public static function giveAuthor($id) { $db = new Conn(); if ($id == '0') { return 'Anonymous'; } else { $author = mysql_fetch_array($db->db_query("SELECT username FROM members WHERE id='{$id}'")); return $author['username']; } }
/** * <b>Não é passado com os Joins</b> * * @return array[Objetos] */ public function findAll() { $sql = "SELECT * FROM {$this->Table}"; $this->Stmt = Conn::prepare($sql); $this->Stmt->execute(); return $this->Stmt->fetchAll(); }
private function Connect() { // obteve a conexão $this->conn = parent::getConn(); //cria a query $this->create = $this->conn->prepare($this->create); }
/** * **************************************** * *********** PRIVATE METHODS ************ * **************************************** */ private function Connect() { $this->Conn = parent::getConn(); $this->Read = $this->Conn->prepare($this->Select); // Retornar resultados em arrays $this->Read->setFetchMode(PDO::FETCH_ASSOC); }
/** * @param $Account ClientAccount */ public static function updateAccount($Account) { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Conn.php"; $sql = "UPDATE ClientAccount SET Balance = ? WHERE AccountNum = ?"; $stmt = Conn::get()->prepare($sql); $stmt->execute(array($Account->getBalance(), $Account->getAccountNum())); }
/** * @param $employee Employee * @param $dependent Dependent */ public static function addDependent($employee, $dependent) { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Conn.php"; $sql = "INSERT INTO Dependents (EID, CID, Fname, Lname, Relation, Birthday) VALUES (?, ?, ?, ?, ?, ?)"; $stmt = Conn::get()->prepare($sql); $stmt->execute(array($employee->getEID(), $employee->getCID(), $dependent->getFname(), $dependent->getLname(), $dependent->getRelation(), $dependent->Birthday)); }
public static function getInstance() { if (is_null(self::$instance)) { self::$instance = new self(); } return self::$instance; }
/** * PRIVATE METODOS */ private function Connect() { /** Pega a Conexão com a Class Pai Conn e atribui ao $this->Conn */ $this->Conn = parent::getConn(); /** Cria o Prepare Statement do Select */ $this->Update = $this->Conn->prepare($this->Update); }
protected static function Conexao() { if (self::$Conection == null) { self::$Conection = mysqli_connect(self::$Host, self::$User, self::$Pass, self::$Base); } return self::$Conection; echo self::$Conection; }
public function __construct() { self::$conn = mysql_connect($this->mysql_host, $this->mysql_username, $this->mysql_password); if (!self::$conn) { die('Can\'t connect to database'); } mysql_select_db("{$this->mysql_database}"); }
/** * PRIVATE METODOS */ private function Connect() { /** Pega a Conexão com a Class Pai Conn e atribui ao $this->Conn */ $this->Conn = parent::getConn(); /** Cria o Prepare Statement do Select */ $this->Read = $this->Conn->prepare($this->Select); /** Seta o retorno dos dados no Formato fetch_assoc */ $this->Read->setFetchMode(PDO::FETCH_ASSOC); }
public static function getRoleList() { include_once "../../bossflex/DB/Conn.php"; $sql = "SELECT RoleID, Role\n FROM UserRole\n ORDER BY RoleID DESC \n LIMIT 0 , 30"; $stmt = Conn::get()->query($sql, PDO::FETCH_ASSOC); $roleList = array(); while ($role = $stmt->fetchObject(__CLASS__)) { $roleList[] = $role; } return $roleList; }
public static function getCodeList() { include_once "../../bossflex/DB/Conn.php"; $sql = "SELECT Code, Reason\n FROM DisableCode"; $stmt = Conn::get()->query($sql, PDO::FETCH_ASSOC); $codeList = array(); while ($code = $stmt->fetchObject(__CLASS__)) { $codeList[] = $code; } return $codeList; }
public function cadastrar_paciente() { $conn = parent::connect(); $result = $conn->query("INSERT INTO paciente (nome,cpf,data_nasc,telefone,endereco,nome_user,senha) VALUES ('" . $this->getNome_completo() . "','" . $this->getCpf() . "','" . $this->getData_nasc() . "','" . $this->getTelefone() . "','" . $this->getEndereco() . "','" . $this->getNome_user() . "','" . $this->getSenha() . "')"); if ($result) { $m = 1; } else { $m = 0; } return $m; }
public static function getReport() { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Conn.php"; $conn = Conn::get(); $sql = "SELECT * FROM Exception ORDER BY TimeStamp DESC"; try { return $conn->query($sql); } catch (Exception $e) { return null; } }
public function excluir_secretaria() { $conn = parent::connect(); $id = $this->getId(); $result = $conn->query("DELETE FROM secretaria WHERE cod_secretaria = {$id}"); if ($result) { $result = 1; } else { $result = 0; } return $result; }
public function BackupDatabase($database) { $connection = parent::getConnection(); // try{ // $backup = $connection->prepare('mysqldump -u root -p 123456 '. $database .' > ' . HOME . 'archives/backup.sql'); // $backup->execute(); // return true; // }catch(Exception $e){ // return false; // $this->result = $e; // } return system('mysqldump -u root -p 123456 ' . $database . ' > ' . HOME . 'archives/backup.sql'); }
/** * 数据库连接 */ public static function &getConn() { if (self::$conn == null) { $conn = new PDO(sprintf(Config::DB_LINK, DIR_ROOT), "charset=UTF-8"); if (IS_DEBUG) { $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } else { $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); } self::$conn = $conn; } return self::$conn; }
private static function Conectar() { try { if (self::$connect == null) { $dsn = 'mysql:host=' . self::$host . ';dbname=' . self::$dbsa; $options = [PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES UTF8']; self::$connect = new PDO($dsn, self::$user, self::$pass, $options); } } catch (PDOException $e) { die("Erro {$e->getMessage()}"); } self::$connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return self::$connect; }
public static function depositAmt($AccountNum, $DepositedByUID, $Amount, $PayRollDate) { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Conn.php"; $db = Conn::get(); $sql = "INSERT INTO Deposit (AccountNum, DepositedByUID, Amount, PayRollDate) VALUES (?, ?, ?, ?)"; $stmt = $db->prepare($sql); $stmt->execute(array($AccountNum, $DepositedByUID, $Amount, $PayRollDate)); $depID = $db->lastInsertId(); $sql = "SELECT * FROM Deposit WHERE DepositID = :id"; $stmt = Conn::get()->prepare($sql); $stmt->bindParam(":id", $depID, PDO::PARAM_INT); $stmt->execute(); return $stmt->fetchObject(__CLASS__); }
private static function Connection() { if (self::$connect == null) { try { $dsn = 'mysql:host=' . self::$host . ';dbname=' . self::$database; $options = [PDO::MYSQL_ATTR_INIT_COMMAND => 'set names utf8']; self::$connect = new PDO($dsn, self::$user, self::$pass, $options); } catch (PDOException $ex) { die('Erro: ' . $ex->getMessage()); } } self::$connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return self::$connect; }
/** * Conecta com o banco de dados com o pattern singleton. * Retorna um objeto PDO! */ private static function conectar() { try { if (self::$Connect == null) { $dsn = 'mysql:host=' . self::$Host . ';dbname=' . self::$Dbsa; $options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES UTF8'); self::$Connect = new PDO($dsn, self::$User, self::$Pass, $options); } } catch (PDOException $e) { die($e->getMessage()); } self::$Connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return self::$Connect; }
public function getNumUsers() { try { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Conn.php"; $sql = "SELECT count(UID) AS numUsers FROM User WHERE CID = :CID"; $stmt = Conn::get()->prepare($sql); $stmt->bindParam(":CID", $this->CID, PDO::PARAM_INT); $stmt->execute(); return $stmt->fetch()["numUsers"]; } catch (Exception $e) { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/Helpers/ErrorReport.php"; ErrorReport::send($_SERVER["SCRIPT_NAME"], $e->getMessage(), $_SERVER['REMOTE_ADDR'], true); return -1; } }
/** * Conecta com o banco de dados com o pattern singleton. * Retorna um objeto PDO! */ private static function Conectar() { try { if (self::$Connect == null) { $dsn = 'mysql:host=' . self::$Host . ';dbname=' . self::$Dbsa; $options = [PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES latin1']; self::$Connect = new PDO($dsn, self::$User, self::$Pass, $options); } } catch (PDOException $e) { PHPErro($e->getCode(), $e->getMessage(), $e->getFile(), $e->getLine()); die; } self::$Connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return self::$Connect; }
/** * Connects to the database using Singleton. * Returns a PDO object. */ private static function ConnectDB() { try { if (self::$Connect == null) { //dsn define qual o DB a ser usado. No caso estamos usando o MySQL. $dsn = 'mysql:host=' . self::$Host . ';dbname=' . self::$Dbsa; $options = [PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES UTF8']; self::$Connect = new PDO($dsn, self::$User, self::$Pass, $options); } } catch (PDOException $e) { PHPError($e->getCode(), $e->getMessage(), $e->getFile(), $e->getLine()); die; } self::$Connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return self::$Connect; }
/** * @param $ticket Ticket * @return Ledger */ public static function addTicket($ticket) { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Conn.php"; $db = Conn::get(); $sql = "INSERT INTO Ledger (AccountNum, TicketNum, Amount, Detail) VALUES (?, ?, ?, ?)"; $stmt = $db->prepare($sql); $stmt->execute(array($ticket->getAccountNum(), $ticket->getTicketNum(), $ticket->getAmount(), $ticket->getDescription())); $depID = $db->lastInsertId(); $sql = "SELECT * FROM Ledger WHERE TransID = :id"; $stmt = Conn::get()->prepare($sql); $stmt->bindParam(":id", $depID, PDO::PARAM_INT); $stmt->execute(); $trans = $stmt->fetchObject(__CLASS__); Ledger::recordTransaction($trans); return $trans; }
/** * Connecta com o banco de dados pattern singleton. * Retorna um objeto PDO! */ private static function getInstance() { try { if (!isset(self::$instance)) { $dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME; $options = [PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES UTF8']; self::$instance = new PDO($dsn, DB_USER, DB_PASS, $options); self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); self::$instance->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ); } } catch (PDOException $ex) { PHPErro($ex->getCode(), $ex->getMessage(), $ex->getFile(), $ex->getLine()); die; } return self::$instance; }
public static function query($sql, $link_identifier = NULL) { if (empty($sql)) { throw new MyException('empty sql'); //return null; } if (empty($link_identifier)) { $link_identifier = Conn::getConnection(); } // var_dump($sql); // var_dump($link_identifier); $result = mysql_query($sql, $link_identifier); if (!$result) { throw new MyException("Fail query: ({$sql}) mysql_error: " . mysql_error()); //return null; return NULL; } return $result; }
public function __construct() { require_once BASEPATH . DIRECTORY_SEPARATOR . APPPATH . DIRECTORY_SEPARATOR . 'config' . DIRECTORY_SEPARATOR . 'database.php'; if (!defined('HOSTNAME') || !defined('USERNAME') || !defined('PASSWORD') || !defined('DBNAME') || !defined('MYSQLPORT')) { foreach ($_db['userlogin'] as $key => $value) { $key = strtoupper($key); define($key, $value); } //die('Arquivo de configuração não está configurado corretamente. Configure o caminho do servidor mysql, com porta login e senha.'); } $this->pdo = Conn::connect(); $this->code = null; $this->elementQuery['tabela'] = ''; $this->elementQuery['campos'] = ''; $this->elementQuery['valores'] = ''; $this->elementQuery['condicao'] = ''; $this->elementQuery['orderBy'] = ''; $this->elementQuery['limit'] = ''; $this->elementQuery['parameters'] = array(); }
/** * @param $User User * @param $Password * @return bool */ public static function changePassword($User, $Password) { try { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Conn.php"; include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/DB/Models/User.php"; $sql = "UPDATE Auth SET Password = :Pass WHERE UID = :UID"; $cost = 10; $salt = strtr(base64_encode(mcrypt_create_iv(16, MCRYPT_DEV_URANDOM)), '+', '.'); $salt = sprintf("\$2a\$%02d\$", $cost) . $salt; $Password = crypt($Password, $salt); $stmt = Conn::get()->prepare($sql); $stmt->bindParam(":UID", $User->getUID()); $stmt->bindParam(":Pass", $Password); $stmt->execute(); return true; } catch (Exception $e) { include_once $_SERVER['DOCUMENT_ROOT'] . "/bossflex/Helpers/ErrorReport.php"; ErrorReport::send($_SERVER["SCRIPT_NAME"], $e->getMessage(), $_SERVER['REMOTE_ADDR'], true); return false; } }