Skip to content

Instantly share code, notes, and snippets.

@porfidev

porfidev/contador_ActualizarContador.php

Last active October 26, 2019 21:13
Show Gist options
  • Save porfidev/1c9b369426050c8e83b6a9dba21d1e38 to your computer and use it in GitHub Desktop.
Save porfidev/1c9b369426050c8e83b6a9dba21d1e38 to your computer and use it in GitHub Desktop.
Download ZIP
Contador con PHP y AJAX
Raw
contador_ActualizarContador.php
<?php
/**
* Created by PhpStorm.
* User: elporfirio
* Date: 20/08/16
* Time: 11:49 AM
*/
require('Contador.php');
require('Registro.php');
$oRegistro = new Registro;
$oContador = new Contador;
$oRegistro->verificarVisita($_SERVER['REMOTE_ADDR']);
$visitas = $oRegistro->obtenerRegistro();
if(count($visitas) <= 0){
$oRegistro->registrarVisita($_SERVER['REMOTE_ADDR']);
$oContador->actualizarContador();
}
echo json_encode(['cantidad' => $oContador->getCantidad()]);
Raw
contador_Conexion.php
<?php
/**
* Created by PhpStorm.
* User: elporfirio
* Date: 20/08/16
* Time: 11:25 AM
*/
class Conexion
{
#Datos para conexión
private $domain = "localhost";
private $database = "contador";
private $user = "homestead";
private $password = "secret";
private $conexion = null;
public function Conectar(){
#Conectarse a la base de datos
try {
$this->conexion = new PDO(
'mysql:host=' . $this->domain . ';dbname=' . $this->database .';port=3306',
$this->user,
$this->password,
array(
PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)
);
} catch (PDOException $ex){
echo "<strong>Error de Conexión: </strong>" . $ex->getMessage() . "<br>";
die();
}
}
public function getConexion(){
if($this->conexion == null){
$this->Conectar();
}
return $this->conexion;
}
}
Raw
contador_Contador.php
<?php
/**
* Created by PhpStorm.
* User: elporfirio
* Date: 20/08/16
* Time: 11:29 AM
*/
require_once('Conexion.php');
class Contador
{
protected $conexion;
protected $cantidad;
public function __construct()
{
$oConexion = new Conexion();
$this->conexion = $oConexion->getConexion();
$this->obtenerContador();
}
public function obtenerContador(){
#Consultar datos
try{
$query = 'SELECT cantidad FROM visitas WHERE id = 1';
$stmt = $this->conexion->prepare($query);
if($stmt->execute()){
$this->cantidad = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
} catch (PDOException $ex){
echo "<strong>Error de ejecución: </strong>" . $ex->getMessage() . "<br>";
die();
}
}
public function actualizarContador(){
try{
$query = 'UPDATE `contador`.`visitas`
SET `cantidad`= cantidad + 1
WHERE `id`= 1 ';
$stmt = $this->conexion->prepare($query);
if($stmt->execute()){
$this->obtenerContador();
}
} catch (PDOException $ex){
echo "<strong>Error de ejecución: </strong>" . $ex->getMessage() . "<br>";
die();
}
}
public function getCantidad(){
return $this->cantidad[0]['cantidad'];
}
}
Raw
contador_index.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<div id="contador">
<span></span>
</div>
<script src="https://code.jquery.com/jquery-3.1.0.min.js"></script>
<script>
$(document).ready(function(){
var url = 'ActualizarContador.php';
var divContador = $('#contador');
function obtenerYActualizar(){
$.get(url)
.done(function(result){
var resultado = JSON.parse(result);
divContador.find('span').text(resultado.cantidad);
setTimeout(obtenerYActualizar, 2000);
});
}
obtenerYActualizar();
});
</script>
</body>
</html>
Raw
contador_Registro.php
<?php
/**
* Created by PhpStorm.
* User: elporfirio
* Date: 20/08/16
* Time: 12:06 PM
*/
class Registro
{
protected $conexion;
protected $registro;
public function __construct()
{
$oConexion = new Conexion();
$this->conexion = $oConexion->getConexion();
}
public function registrarVisita($ip){
#Consultar datos
try{
$query = 'INSERT INTO `contador`.`registro_ip` (`ip_visita`, `fecha`)
VALUES (:ip, DATE(NOW()));';
$stmt = $this->conexion->prepare($query);
$stmt->bindParam(':ip', $ip);
if($stmt->execute()){
$this->registro = $this->conexion->lastInsertId();
}
} catch (PDOException $ex){
echo "<strong>Error de ejecución: </strong>" . $ex->getMessage() . "<br>";
die();
}
}
public function verificarVisita($ip){
#Consultar datos
try{
$query = 'SELECT * FROM contador.registro_ip
WHERE ip_visita = :ip
AND fecha = DATE(NOW())';
$stmt = $this->conexion->prepare($query);
$stmt->bindParam(':ip', $ip);
if($stmt->execute()){
$this->registro = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
} catch (PDOException $ex){
echo "<strong>Error de ejecución: </strong>" . $ex->getMessage() . "<br>";
die();
}
}
public function obtenerRegistro(){
return $this->registro;
}
}
Raw
sql_
-- MySQL dump 10.13 Distrib 5.7.12, for osx10.9 (x86_64)
--
-- Host: elporfirio.local Database: contador
-- ------------------------------------------------------
-- Server version 5.7.12
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `registro_ip`
--
DROP TABLE IF EXISTS `registro_ip`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `registro_ip` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip_visita` varchar(45) COLLATE utf8_spanish_ci DEFAULT NULL,
`fecha` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `visitas`
--
DROP TABLE IF EXISTS `visitas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visitas` (
`id` int(11) NOT NULL,
`cantidad` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `visitas`
--
LOCK TABLES `visitas` WRITE;
/*!40000 ALTER TABLE `visitas` DISABLE KEYS */;
INSERT INTO `visitas` VALUES (1,340);
/*!40000 ALTER TABLE `visitas` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2016-08-20 12:35:10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment