my friend i tried the query and its ok...... but it doesn´t work....
if echo 0 = the user has been logued in... if echo 1= the values are wrong
and if echo 2; = there are not values entered by the user
<?php
if ($_POST['usuario']!= '' && $_POST['password']!= ''){
$username = "root";
$password = "chrystopher";
$databasename = "encuestasavandaro";
try {
$db = new PDO("mysql:dbname=$databasename",$username,$password);
}
catch (PDOException $e) {
die ($e->getMessage());
}
$query = $db-> prepare('SELECT a.rol, b.usuario FROM rollusuario a,
usuarios b WHERE a.id_rol = b.id_rol AND b.password = SHA(:password) AND
b.usuario = :usuario');
$query->execute(array( 'password' => $_POST['password'], 'usario'
=> $_POST['usuario']));
$results = $query->fetchAll(PDO::FETCH_ASSOC);
// gracefully exit the database
$query = null;
$db = null;
if (count($results) == 1) {
// this is actually sufficient to say the user is logged in, no need for
anything else
session_start();
$_SESSION["autentificado"]= true;
$_SESSION["usuario"]= $_POST["usuario"]."|".$results[0]['rol'];
echo 0;
}
else {
echo 1;
}
}else{
echo 2;
}
?>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
