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);
 }
Example #4
0
 /**
  * ****************************************
  * *********** 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);
 }
Example #5
0
 /**
  * @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()));
 }
Example #6
0
 /**
  * @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;
 }
Example #8
0
 /**
  * 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}");
 }
Example #11
0
 /**
  * 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);
 }
Example #12
0
 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;
 }
Example #13
0
 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;
 }
Example #15
0
 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;
 }
Example #17
0
 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');
 }
Example #18
0
 /**
  * 数据库连接
  */
 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;
 }
Example #19
0
 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;
 }
Example #20
0
 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__);
 }
Example #21
0
 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;
 }
Example #22
0
 /**
  * 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;
 }
Example #23
0
 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;
     }
 }
Example #24
0
 /**
  * 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;
 }
Example #25
0
 /**
  * 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;
 }
Example #26
0
 /**
  * @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;
 }
Example #28
0
 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;
 }
Example #29
0
 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();
 }
Example #30
0
 /**
  * @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;
     }
 }