Skip to content

Instantly share code, notes, and snippets.

@everaldo

everaldo/contador.php

Created May 8, 2015 23:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save everaldo/8e68d143cb776f6fafa9 to your computer and use it in GitHub Desktop.
Save everaldo/8e68d143cb776f6fafa9 to your computer and use it in GitHub Desktop.
Download ZIP
Contador de visitas
Raw
contador.php
<!DOCTYPE html>
<html>
<head>
<meta charset=utf-8 />
<title>Contador de Visitas</title>
</head>
<body>
<?php
function get_num_visitas(){
//conectar
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
die('Não foi possível conectar: ' . mysql_error());
}
mysql_select_db("contador");
$query = "SELECT total " .
"FROM `visitas` " .
"ORDER BY total ASC LIMIT 1";
$result = mysql_query($query);
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}
$row = mysql_fetch_array($result);
mysql_close($link);
return $row["total"];
//fazer consulta
//retornar total
}
function imprime_visitas($contador){
return "<h1>" . $contador . "</h1>";
}
function contar_visita(){
//conectar
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
die('Não foi possível conectar: ' . mysql_error());
}
mysql_select_db("contador");
$query = "UPDATE `visitas` " .
"SET total = total + 1";
$result = mysql_query($query);
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
mysql_close($link);
}
contar_visita();
$contador = get_num_visitas();
echo imprime_visitas($contador);
?>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment