set_charset("utf8");
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
return $conn;
return 2;
}
public function readtableCountTotal(){
$conn = $this->connectDBBDD();
$res = mysqli_query($conn,"SELECT COUNT(id) FROM tbl_registro_general;");
$info = mysqli_fetch_array($res)[0];
$conn->close();
return $info;
}
public function readtableCount01($val){
$conn = $this->connectDBBDD();
$res = mysqli_query($conn,"SELECT COUNT(id) FROM tbl_registro_general WHERE expl LIKE '%".$val."%' AND (date >= '".date('Y-m-d', strtotime('-1 year'))." 00:00:00' AND date <= '".date('Y-m-d', strtotime('now'))." 23:59:59');");
$info = mysqli_fetch_array($res)[0];
$conn->close();
return $info;
}
public function readtableCount02($va1,$va2,$va3){
$conn = $this->connectDBBDD();
$res = mysqli_query($conn,"SELECT COUNT(id) FROM tbl_registro_general WHERE expl NOT LIKE '%".$va1."%' AND expl NOT LIKE '%".$va2."%' AND expl NOT LIKE '%".$va3."%' AND (date >= '".date('Y-m-d', strtotime('-1 year'))." 00:00:00' AND date <= '".date('Y-m-d', strtotime('now'))." 23:59:59');");
$info = mysqli_fetch_array($res)[0];
$conn->close();
return $info;
}
public function readtablePorcent01($val){
$conn = $this->connectDBBDD();
$info = ((mysqli_fetch_array(mysqli_query($conn,"SELECT COUNT(id) FROM tbl_registro_general WHERE expl LIKE '%".$val."%' AND (date >= '".date('Y-m-d', strtotime('-1 year'))." 00:00:00' AND date <= '".date('Y-m-d', strtotime('now'))." 23:59:59');"))[0])*100)/(mysqli_fetch_array(mysqli_query($conn,"SELECT COUNT(id) FROM tbl_registro_general; WHERE (date >= '".date('Y-m-d', strtotime('-1 year'))." 00:00:00' AND date <= '".date('Y-m-d', strtotime('now'))." 23:59:59')"))[0]);
//$info = $val.",".(mysqli_fetch_array(mysqli_query($conn,"SELECT COUNT(id) FROM tbl_registro_general WHERE expl LIKE '%".$val."%';"))[0]).",".(mysqli_fetch_array(mysqli_query($conn,"SELECT COUNT(id) FROM tbl_registro_general;"))[0])." = ".$info;
$conn->close();
return $info;
}
public function readtableDB11(){
$conn = $this->connectDBBDD();
$a = 1;
$str = "";
$res = mysqli_query($conn,"SELECT id_documento,titulo,vistas,descargas FROM tbl_documentos WHERE activo = 1 ORDER BY descargas DESC LIMIT 0,40;");
while($cRow = mysqli_fetch_array($res)){
$info[$a][1] = $cRow[0];
$info[$a][2] = $cRow[1];
$info[$a][3] = $cRow[2];
$info[$a][4] = $cRow[3];
$a++;
}
$conn->close();
for($b = 1;$b < $a;$b++) $str = $str."| ".$b.' | '.substr($info[$b][2],0,70)."... | ".$info[$b][3]." | ".$info[$b][4]." |
\n";
return $str;
}
public function readtableDB12(){
$conn = $this->connectDBBDD();
$a = 1;
$str = "";
$res = mysqli_query($conn,"SELECT id_encuesta_base,encuesta,vistas FROM tbl_bases_encuestas WHERE activo = 1 ORDER BY vistas DESC LIMIT 0,50;");
while($cRow = mysqli_fetch_array($res)){
$info[$a][1] = $cRow[0];
$info[$a][2] = $cRow[1];
$info[$a][3] = $cRow[2];
$a++;
}
$conn->close();
for($b = 1;$b < $a;$b++) $str = $str."| ".$b.' | '.substr($info[$b][2],0,85)."... | ".$info[$b][3]." |
\n";
return $str;
}
}
?>
Estadísticas Algunos valores mostrados pueden ser una aproximación.
| 40 Documentos Más Visitados | Vistas | Descargas |
|---|
readtableDB11(); ?>
| 40 Archivos Más Visitados | Vistas |
|---|
readtableDB12(); ?>
readtableCount01("Bot");*/ ?>
readtablePorcent01("Bot");*/ ?>
readtableCountTotal();
$n01 = ($baseDeDatosDS->readtableCount01("Chrome")*100)/$nt; // Chrome
$n02 = ($baseDeDatosDS->readtableCount01("MSIE")*100)/$nt; // IE
$n03 = ($baseDeDatosDS->readtableCount01("Firefox")*100)/$nt; // FireFox
$n04 = ($baseDeDatosDS->readtableCount01("Edge")*100)/$nt; // Edge
$n05 = ($baseDeDatosDS->readtableCount01("Version")*100)/$nt; // Safari
$n06 = ($baseDeDatosDS->readtableCount01("Opera")*100)/$nt; // Opera
$n07 = ($baseDeDatosDS->readtableCount01("Bot")*100)/$nt; // Bot
$n08 = 0;//$nt-$n01-$n02-$n03-$n04-$n05-$n06-$n07; // Otro
?>
readtableCount01("Windows")*100)/$dt; // Windows
$d02 = ($baseDeDatosDS->readtableCount01("Mac")*100)/$dt; // Mac
$d03 = ($baseDeDatosDS->readtableCount01("Linux")*100)/$dt; // Linux
?>
readtableCount01("Bot","Tab","Mobile")*100)/$st; // PC
$s02 = ($baseDeDatosDS->readtableCount01("Tab")*100)/$st; // Tab
$s03 = ($baseDeDatosDS->readtableCount01("Mobile")*100)/$st; // Telefono
?>