/**
* 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>
