whF6gwrD

1<?php
2if(isset($_POST["submit"])){
3
4if(!empty($_POST['email']) && !empty($_POST['clave'])) {
5    $email=$_POST['email'];
6    $clave=$_POST['clave'];
7
8    $con=mysql_connect('localhost','root','') or die(mysql_error());
9    mysql_select_db('usuario') or die("cannot select DB");
10
11    $query=mysql_query("SELECT * FROM login WHERE email='".$email."' AND clave='".$clave."'");
12    $numrows=mysql_num_rows($query);
13    if($numrows!=0)
14    {
15    while($row=mysql_fetch_assoc($query))
16    {
17    $dbusername=$row['email'];
18    $dbpassword=$row['clave'];
19    }
20
21    if($email == $dbusername && $clave == $dbpassword)
22    {
23    session_start();
24    $_SESSION['sess_user']=$email;
25
26    /* Redirect browser */
27    header("Location: Inicio.php");
28    }
29    } else {
30    echo "Nombre de usuario invalido o clave incorrecta";
31    }
32
33} else {
34    echo "Todos los campos son requeridos";
35}
36}
37	
38CREATE TABLE IF NOT EXISTS `my_chart_data` (
39  `category` date NOT NULL,
40  `value1` int(11) NOT NULL,
41  `value2` int(11) NOT NULL
42);
43	
44if($email == $dbusername && $clave == $dbpassword)
45        {
46        session_start();
47        $_SESSION['sess_user']=$email;
48  mysql_query("UPDATE my_chart_data SET value1 = +1 WHERE  category");
49
50        /* Redirect browser */
51        header("Location: Inicio.php");
52        }
53        } else {
54        echo "Nombre de usuario invalido o clave incorrecta";
55 mysql_query("UPDATE my_chart_data SET value2 = +1 WHERE  category");
56        }
57
58    } else {
59        echo "Todos los campos son requeridos";
60    }
61    }