public function count($condicao = "") { try { if (!empty($condicao)) { $query = 'SELECT COUNT(*) AS total FROM ' . self::$tabela . ' WHERE excluido = 0 AND ' . $condicao; } else { $query = 'SELECT COUNT(*) AS total FROM ' . self::$tabela . ' WHERE excluido = 0'; } $result = $this->conexao->prepare($query); $result->execute(); $resultado = $result->fetch(PDO::FETCH_ASSOC); return $resultado['total']; } catch (PDOException $e) { Conexao::alertaEnviaEmail("<code>" . $e->getMessage() . "</code>", $_SERVER['SCRIPT_NAME']); } }
protected function selecionarPorId($model, $id) { try { $result = $this->conexao->prepare("SELECT *\n\t\t\t\t\t\t\t\t\t\t \t FROM " . $model::$tabela . "\n\t\t\t\t\t\t\t\t\t\t \t WHERE id = :id"); $result->bindParam(':id', $id, PDO::PARAM_INT); $result->execute(); $linha = $result->fetch(PDO::FETCH_ASSOC); $arrayModel = get_object_vars($model); foreach ($arrayModel as $indice => $valor) { if (!in_array($indice, array('tabela', 'conexao'))) { $model->{$indice} = $linha[$indice]; } } } catch (PDOException $e) { Conexao::alertaEnviaEmail("<code>" . $e->getMessage() . "</code>", $_SERVER['SCRIPT_NAME']); } }