I have a problem with the login.
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\wamp\www\droidlogin\funciones_bd.php on line 68
the name of the table is ocbup_users
In the database password is stored encrypted.
funciones_db
<?php
class funciones_BD {
private $db;
// constructor
function __construct() {
require_once 'connectbd.php';
// connecting to database
$this->db = new DB_Connect();
$this->db->connect();
}
// destructor
function __destruct() {
}
/**
* agregar nuevo usuario
*/
public function adduser($username, $password) {
$result = mysql_query("INSERT INTO ocbup_users(username,passw) VALUES('$username', '$password')");
// check for successful store
if ($result) {
return true;
} else {
return false;
}
}
/**
* Verificar si el usuario ya existe por el username
*/
public function isuserexist($username) {
$result = mysql_query("SELECT username from ocbup_users WHERE username = '$username'");
$num_rows = mysql_num_rows($result); //numero de filas retornadas
if ($num_rows > 0) {
// el usuario existe
return true;
} else {
// no existe
return false;
}
}
public function login($user,$passw){
$result=mysql_query("SELECT COUNT(*) FROM ocbup_users WHERE username='$user' AND passw='$passw' ");
$count = mysql_fetch_row($result);
/*como el usuario debe ser unico cuenta el numero de ocurrencias con esos datos*/
if ($count[0]==0){
return true;
}else{
return false;
}
}
}
?>
