/** * 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; }
/** * 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; }
/** Conecta com o banco de dados com o pattern SingleTon * Retorna um objeto PDO! **/ private static function conectar() { try { if (self::$instance == null) { // DSN configurado para mySQL, se o seu banco de dados não for mySQL // Reconfigure o DSN! $dsn = 'mysql:host=' . self::$Host . ';dbname=' . self::$Dbsa; $options = [PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES UTF8"]; self::$instance = new PDO($dsn, self::$User, self::$Pass, $options); } } catch (PDOException $ex) { PHPErro($ex->getCode(), $ex->getMessage(), $ex->getFile(), $ex->getLine()); die; } self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return self::$instance; }
/** * <b>Executa a query preparada</b> * * @return boolean */ protected function commit() { try { $this->Stmt->execute(); $this->Result = $this->getRowCount(); } catch (PDOException $ex) { PHPErro($ex->getCode(), $ex->getMessage(), $ex->getFile(), $ex->getLine()); $this->Result = false; } return $this->Result; }
/** * <b>Executa a query preparada</b> * * @return boolean */ protected function Commit() { try { if (!$this->BindParam) { $this->Stmt->execute($this->Dados); } else { $this->Stmt->execute(); } $this->Result = $this->getRowCount(); } catch (PDOException $ex) { PHPErro($ex->getCode(), $ex->getMessage(), $ex->getFile(), $ex->getLine()); $this->Result = false; } return $this->Result; }
require './_app/Config.inc.php'; $PDO = new Conn(); $name = 'Chrome'; $views = '250'; try { $qRCreate = "INSERT INTO ws_siteviews_agent (agent_name, agent_views) VALUES (?, ?)"; $create = $PDO->getConn()->prepare($qRCreate); $create->bindParam(1, $name, PDO::PARAM_STR, 15); $create->bindParam(2, $views, PDO::PARAM_INT, 5); $create->execute(); if ($create->rowCount()) { echo "{$PDO->getConn()->lastInsertId()} - Cadastrado com sucesso <hr>"; } $qRSelect = "SELECT * FROM ws_siteviews_agent WHERE agent_views >= :visitas"; $select = $PDO->getConn()->prepare($qRSelect); $select->bindValue(':visitas', '7'); $select->execute(); if ($select->rowCount() >= 1) { echo "Pesquisa retornou {$select->rowCount()} resultado(s) <hr>"; $resultado = $select->fetchAll(PDO::FETCH_ASSOC); var_dump($resultado); } else { echo "Nenhum resultado encontrado <hr>"; } } catch (PDOException $e) { PHPErro($e->getCode(), $e->getMessage(), $e->getFile(), $e->getLine()); } ?> </body> </html>