<?php
session_start();
require 'db.php';
$user = $_POST['user'];
$pass = $_POST['pass'];
$db = new DBmysql('192.168.0.93', 'pelisio', 'pel2015', 'pelisio');
if ($result = $db->consulta2("SELECT user,pass,activo FROM usuario WHERE user = '******';")) {
if ($result['activo'] != 1) {
echo "3";
} else {
if ($result['pass'] != $pass) {
echo "2";
} else {
$_SESSION["userid"] = $user;
echo "1";
}
}
} else {
echo 404;
}
$db->desconectar();
<?php
require 'db.php';
$cod = $_POST['cod'];
$db = new DBmysql('192.168.0.93', 'pelisio', 'pel2015', 'pelisio');
$temp = $db->consulta2("SELECT IFNULL(COUNT(cod),0) total FROM votos WHERE cod =" . $cod);
echo $temp['total'];
//echo json_encode($temp);
<?php
require 'db.php';
$ipvisitante = $_SERVER["REMOTE_ADDR"];
$idpelicula = $_REQUEST['id'];
$db = new DBmysql('192.168.0.93', 'pelisio', 'pel2015', 'pelisio');
$temp1 = $db->consulta2("SELECT IFNULL(COUNT(pip),0) AS votos FROM votos WHERE pip = '" . $_SERVER["REMOTE_ADDR"] . "';");
if ($temp1['votos'] == '0') {
$statement = $db->statment("INSERT INTO votos (cod, pip) VALUES(?, ?)");
$statement->bind_param('is', $idpelicula, $ipvisitante);
$statement->execute();
$statement->close();
$temp = $db->consulta2("SELECT cod, SUM(1) AS total FROM votos WHERE cod = " . $idpelicula);
echo $temp['total'];
} else {
echo 0;
}
$db->desconectar();
