<?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();